We have a requirement where we want to do a wildcard kind of search along with fuzzy search.
So consider a field with below values :
- aero123
- aero1
- dynaaero
- dynaaeromatic
If user searches for any of these : aero , aer0, ae, er0i
All these searches should return the above values
For wildcard we are using ngrams and fuzzy with auto for fuzzy search.
However, while doing a fuzzy search it does not consider partial matches
Is it possible to combine the 2 searches and get results? How ?