I need to come up with technologies and tools that will address below requirement.
Requirement: To develop and/or use web based search tool that will allow a user to enter a phrase and it should display the results based on what it points in the database. For example, If we have a list of all tooth pastes in the data base than when a user enters in search box " tooth paste or collegiate or any other phrase related to tooth paste" system should display toothpastes or anything related to tooth paste. Could somebody tell me what tools are available (prefer open source) in the market that we can use and/or if we have to develop in house what technologies we should use.
Thanks in advance.