Fuzzy Match(levenshtein distance) is not producing match score

[ddeep71]

Fuzzy match with levenshtein distance is not producing any score for words like below. even if I keep the match threshold 10%.  Can you guys help me on this please. 

1. DARDASHTI 
2. DARDASHTI M.D.

3.MICHAEL
4. MICHAEL M.D.

[OllieClarke]

Hi @ddeep71 I think there might be a couple of things happening here:

Firstly, make sure you check 'Generate Keys for Each word' as that will help with the M.D. being purged.

Secondly, make sure the the 'Match Threshold' in the tool configuration (rather than in the match option configuration) is also set to a lower threshold to allow the matches to come through. 60% is a bit more generous and could help. edit: I see that you'd already done this, my bad

Hope those changes help,

Ollie 

[ddeep71]

Hi Ollie,

Thanks for the suggestion. Yes, if I select the option "generate keys for each word" I am getting match score. But with this option checked, I am getting pretty good match score for 1. DARDASHTI, 2.MICHAEL DARDASHTI(71%). which I think is really not acceptable for me. Unfortunately all the algorithms are doing the same in Alteryx. 

Wondering if I could get actual result like Python: