How I can Improve a Fuzzy match Score

Question

Hello,

I am trying to compare adresses each other with using Fuzzy Match Tool.

you can see the result below :

AdressAdress_matchingIdMatchScoreMatchScore_Adress605 3rd Avenue605 Third Avenue2002203 Rowan Street2203 Rowen St385851550 W Isaac DR1550 West Isaac DR49191340 S Patterson DR340 South Patterson DR584841555 W 3rd ST1555 Third Street6002310 S Winslow CT2310 Sth Winslow CT796961110 S Covenanter DR1110 Sth Covenanter DR889892430 S Brown AVE2430 Sth Brown Avenue991911918 W 3rd ST1918  Third Street1000

So, When the adress is written like 'Third' instead 3rd, the result return the value 0, even if the two adress are similars.

I've used this paramaters to do this fuzzy match

So wich options can improve the result when there is a number written in word (1th ==>first , 3rd ==> Third ....).

I've also an another question about the Fuzzy Match Tool, how i can avoid to having duplicates in the result, i give you this example :

IdId2MatchScoreMatchScore_Adress72372310010072395382827239538282953953100100691691919169196172726919617676

The Tool calculate the score with others Id and I don't know why.

Thank you for your help.

ArtApa · Answer

Hi @ByranCarter12 - Well, if you are to solve a business problem then nothing is boring. Building a lookup table is a valid approach. See example here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-235-Spell-It-Out-For-Me-Part-2/td-p/640995

The way the Address Match Style works it ignores: Ave, St, Rd, Blvd etc. If you want to change the style to Name, then the Score will jump up for this particular record, but you may have a lower case somewhere else:

That's why I wrote, it's an art. This is why it's called Fuzzy.

ByranCarter12 · Answer

@ArtApa

Thank you, I appreciate your help.

I also had this idea to replace some abbreviations to improve the score. But when it comes to words like (third, first, fifth...), it might be long and boring to list all the possibilities to replace. There is no way in the options to ignore ordinal values.

In addition, the result obtained is 0 while there are similarities between the two addresses.

ArtApa · Answer

Hi @ByranCarter12 - Fuzzy matching is an art. It is a very iterative process. Here are my comments:

* You may Need to prepare your data set first. In your particular scenario I converted "3rd" to "Third".
* Match everything that can be matched before Fuzzy matching
* Start with the default Match Style (Address)
* The longer the Max Key Length the lower the match score. For "Address" the default length is 8. You may want to reduce it to 6 or 4 to improve the score.
* The Unique tool will remove duplicates.

Here is how your solution may look like:

You may want to watch the following videos to learn more about Fuzzy Matching in Alteryx:

* https://community.alteryx.com/t5/Videos/Fuzzy-Matching-Intermediate-Users/td-p/43852
* https://community.alteryx.com/t5/Videos/Fuzzy-Matching-for-Beginners/td-p/330575
* https://community.alteryx.com/t5/Videos/Introduction-to-Fuzzy-Matching/td-p/43884

Enjoy!

FuzzyAddressAA.yxmd