Last post Aug 27, 2018 03:03 AM by Deepak Panchal
Aug 23, 2018 04:48 AM|RobertH3|LINK
I wish to be able to detect if someone is entering data into a field that may be the same but one may contain a spelling error or be off by one word.
My table is a list of tasks
A task in the database may be "Clean Bathroom"
If an admin wants to enter a new task for selection and enters "Clean Bath Room" or "Clean Bath-Room" or they enter "Clean Baathroom"
This is for a Stored Procedure
Aug 27, 2018 03:03 AM|Deepak Panchal|LINK
You can try to use Soundex() or Difference() to get the desired result.
You can refer example below.
Data in table.
WHERE SOUNDEX('Clean Bathroom') = SOUNDEX(col1)
WHERE DIFFERENCE(col1, 'Clean Bathroom') >= 3