Fuzz match settings to improve match rate

[shriramr]

Hello,

I have been exploring using the Fuzzy match tool to identify similar stores emerging from 2 different lists.

I was expecting that all 3 stores from my salesforce list would match to at least one store in my master acc list.

The output of the fuzzy match tool only seems to return Walmart.

I have tried to relax the criteria through match threshold and match weight, altered a few match functions, but can't seem to figure what it would take to match the 2 additional stores.

Your help is much appreciated.

Thank you.

[caltang · Accepted solution]

I've tried my hand at it:

[caltang]

These are my changes in the config vis-a-vis yours:

Since you are using company names from the USA, they have a built in function for that specifically. Hope this helps.

[shriramr]

Thank you for your help!!

Interesting why there are 2 different match threshold values.

Any idea which how the software considers each of these inputs?