compare two strings and calculate similarity between them 1

[abdellatif99]

compare two strings and calculate the degree of similarity between them.

 

[DSummZZZ]

Try the SOUNDEX() function.

?SOUNDEX('Dave')
?SOUNDEX('Davey')
?SOUNDEX('David')
?SOUNDEX('Davis')

Dave S.

 

[rgbean]

You may want to also look at the DIFFERENCE() function.

Rick

 

[furmious]

You may want to look at a third party product PhDbase. It's a 'fuzzy' compare/locate among other things. The soundex function gives some bizzar returns (like the same score for different words). You can find a number of hits on the web for PhDbase.