I need some help regarding a search script. On my website, a user can enter in a search term; however, a very common word they may choose to search for can be spelled two different ways.
How do I structure the search so that if one spelling is entered it automatically retrieves records with the other spelling as well?
My guess would be something along the lines of a IF/THEN statement, but not sure (?).
Do you know all/some/most words that will be spelled two ways? You could set up a database table that has: ID, spelling 1, spelling 2. Then you would need to do a subquery within the search query. SubSelect Query
This function is probably going to come in handy. You’ll need a database of words though - perhaps there’s a dictionary app out there with an app to let you pull words.
The search is a full-text search constructed dynamically. I don’t really want to start tweaking with my database, but it seems I may have to do so in order to get this functionality.