Fuzzy match in groups

[E_Sinha_home]

Hello

I want to have the Match percentages for every group. 

Refer to the screenshot below for reference. I have also attached a dummy dataset.

Thanks in advance

[E_Sinha_home]

like this

[exttrlo]

Please see my second reply.

Thanks

[exttrlo · Accepted solution]

Hi ,

I tightened up the matching on name and now the matching rates are much better. You can play around with word by word, or various versions of levenstein distance to get the best needed results from the window compare tool.

I attached the tempalte for the image below.

Sorry about the runaround

[E_Sinha_home]

Perfect ! Thanks a tonne @exttrlo 

[exttrlo]

One more thing to add...

I used the fuzzy match tool to do this only because I could not find any edit distance commands in the formula tool. If  there are any edit distance scoring methods in the tool, you can just plop a tool on instead of having to use fuzzy match.

Glad I could help.

best , ext