mysql ?join? how to allow a table of synonyms/misspellings/thesaurus
This project has a pretty simple (web) user-search into the Description field of their db.
currently we use Descr LIKE '%$SearchTerm%'
How is easiest to allow (the cross product of) $SearchTerm to "first" be looked up in a table of synonyms (and common misspellings) so then that "translated" (correct/alternate) keyword can also be searched for in the Description column along with the existing search for $SearchTerm to still happen.
This is an InnoDB table. (I'd rather not get into a full text search using a different db model)