I want to create a stored procedure which takes a project name and returns any project with a name similar or = to the input parameter. This is so the user can search for a project although the spelling may be incorrect or whatever.....
Any hints on how to start this? It seems that I could use SOUNDEX or DIFFERENCE, but I don't know where to start.
How do you make Full-Text search match similar sounding search words?
A. Use FREETEXT to search for words containing specified character values
This example searches for all product categories containing the words related to bread, candy, dry, and meat in the product description, such as breads, candies, dried, and meats.
WHERE FREETEXT (Description, 'sweetest candy bread and dry meat' )
Certainly not a perfect solution but it might help. I've not had much experience with it.