AndrewJ1313 Posted June 19, 2010 Share Posted June 19, 2010 Is it possible to train your search query to find similar words to what the user submitted? Example, the word "Lobster" is in the database, using Full text search with IN BOOLEAN MODE, if the user submits "Lobst" and the wild card variable "*" is added after the word, it will find "Lobster", but is there a way to still get the proper results if the user were to enter the word "Lobsters" - or plural? Would it be best to automatically remove the last two letters of all words submitted that are over five characters long and just add the wild card? Just curious if there is an easier way to do this and I'm just over analyzing. Cheers, Andrew Quote Link to comment Share on other sites More sharing options...
dabaR Posted June 19, 2010 Share Posted June 19, 2010 Hi there. Make a iterates over each letter "l, lo, lob, lobs..." that keeps a previous_iteration_results and a obtains a current_iteration results. As soon as there are no matches in current_iteration_results, you return previous_iteration_results. Quote Link to comment Share on other sites More sharing options...
AndrewJ1313 Posted June 19, 2010 Author Share Posted June 19, 2010 I knew I was over analyzing Thanks for the info! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.