Determining similarity of two strings

Determining similarity of two strings

I am trying to compare two data sets to find addresses that do NOT match, but ignore small things like punctuation and capitalization.
For example, if one address is 200 W. 200 N. in one data set and 200 West 200 North in the other, that's fine. I just want to select rows where the values are way different, but I don't know if that's a possibility. I was hoping to use the DIFFERENCE function to select rows with certain SOUNDEX values, but it appears that function is not supported in Zoho Analytics.

Any ideas how I could achieve this?