I need to identify some close match's in 2 sets off data and was thinking of using soundex and the difference function.
The difference function supposedly represents the following:-
4 - Best Match,
3 - Relative Match
2 - Fair Match
1 - Poor Match
but as a test i did the following query and its result was a rating of 4
SELECT DIFFERENCE('Ailsa', 'alk')
How can this be the "best match"?
Am I best using LIKE instead?