Optimize Search Query for considering singular, plural and suggest words like Google
Posted on 2006-06-29
How do I make a search query to include both singular and plural in a single query. Giving the query using: like '% %' does not help here. If i give either "House" or "Houses" in my search criteria, it should search for both "House" and "Houses" in the database.
Also, how do I achieve something like that in Google. When we type something wrong, it asks for "Do you mean ....... to search".