You can simplify the equivalent of the full-text search service by breaking the name field into the parts you want to find and save them as an indexed property. You can even use Lucene parsers to tokenize and protect your fields.
This works a lot when working with a data warehouse: if you do not have a query operator that does what you want, predetermine the appropriate data so that your query becomes an equality test.
Alternatively, use the FTS service.
source share