I want to search for threads in my mysql database with Solr.
But i want it to not just search the thread words, but for similar words.
Eg. if a thread title is "dog for sale" and if the user searches for dogs the title will be in the result.
and also if a user searches for "mac os x" the word "snow leopard" will appear.
and the ability to link words the application thinks is related eg. house and apartment.
how is this kind of logic done?
i know that you can with solr look up words in a dictionary file you create/add, so solr will look for dogs and see what related words there are (eg. dog).
but where do you find such a dictionary?
i have no idea about this kind of implementation.
please point me into right direction.
thanks