Posted by Alexander Kuznetsov on 11/20/58 11:28

if you are 100% sure you cannot sue full text search,
do it yourself:
for instanse, for row
ID Make Model
1 Toyota Camry

add these row to an additional table (ID, TOKEN)

1 TOYOTA
1 OYOTA
1 YOTA
1 OTA
1 TA
1 A
1 CAMRY
1 AMRY
1 MRY
1 RY
1 Y

etc.

that done, instead of MODEL LIKE '%OYO%' or MAKE LIKE '%OYO%' you can
use

TOKEN LIKE 'OYO%' which is sargeable

Maintaining tokens is another story, long and boring

[Back to original message]