I need to build a search algorithm based on keywords input by the user. I have some ideas running on possible implementations but would like to have your opinion. The table for search has a field with keywords and a field with description text (I want to search through both). Anyone has any recommendations? Speed is of importance. Also, do you guys know of any library I could use that matches similar keys, for example, if you search for dogs things related to canines might come up, or if you search of seats things related to chairs come up.
Thanks in advance for the help, don't be afraid to throw in heavy technical information
