Fuzzy name match

Question

Hi,

I found that the default Alteryx Common Nicknames database is not very complete. For example, Antonietta nick name could be Tony but it's not included in the database. I have a couple questions:

1. Does any one have a more complete common nickname list?

2. When I add more nicknames to this table, do I need to include potential misspellings, for example "Antoinette" instead of "Antonietta"?

Thanks!

abacon · Answer

@Hong_Hu to piggy back on @dreldrel, the fuzzy match tool is tricky and might be more trouble than it's worth. Additionally, using a predefined DB of aliases for a value will always be tricky. I would either use the GenAI tools or use your preferred LLM to generate your own table - I did this before or address normalization and it was a great workaround.

Bacon

dreldrel · Answer

I personally don't like fuzzy match. You can consider schema match in the Gen AI tool, which can help you match the data as well

Hong_Hu · Answer

In addition, how should I try to match these names:

1. Yermis Croussett vs. YERNIS CIROUSSETT (Misspelled names)

2. CESAR GARCIA vs. CESAR SANTIAGO GARCIA (Middle name)

Thanks again!