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”)
- special/accented characters (UTF8 )
all possible complications you can encounter.