How to Detect Similar Strings Where one may contain a spelling error

Question

User-1193791088 posted

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

Answer 1

User347430248 posted

Hi RobertH3,

You can try to use Soundex() or Difference() to get the desired result.

You can refer example below.

Data in table.

Query:

SELECT *
FROM comp_test
WHERE SOUNDEX('Clean Bathroom') = SOUNDEX(col1)

OR

SELECT *
FROM comp_test
WHERE DIFFERENCE(col1, 'Clean Bathroom') >= 3

Output:

Reference:

SOUNDEX (Transact-SQL)

DIFFERENCE (Transact-SQL)

Regards

Deepak