I have a case where 2 terms may be used in a search (i.e. “sodium” and “natrium”) and I want results for both terms to be returned whenever EITHER is used.
I am aware of the use of regexp but wonder if this is the best approach (I may have several hundreds of these in various languages) considering:
partial matches (i.e. search for “sodi*”)
autocorrection (i.e. search for “sosium” or “narium”)
The question may seem simple but as there are more than 1 way to implement what I want I also need to know when the specific mapping of the synonym is applied , for example it is before or after the charset_table mapping as this may mean that case-independence is taken care of or not.