I am using Apache Solr 8.6 for providing search functionality in a project, and I have use case to search for Arabic text written in Latin characters and vise verse. Data are located in one collection mixed of Arabic and English text. for example:
If user search for Ahmed and there is احمد in the collection it should match. If user search for احمد and there Ahmed is in the collection it should match.
From my perspective I think I need to find (or buy) synonym list contains English and Arabic synonyms like: Ahmed,احمد book,كتاب
my solution Is:
use stemmed synonyms list, use synonym filter at index time, and use Arabic stem filter at query and index time.
Is there available synonym list like this. And if my solution is valid or there is another options like products or Solr plugins I have to explore before I go with my Solution.