find matching names - Fuzzy Match

Question

Hello Alteryx community,

I am trying to understand if I can use Fuzzy Match to match the names of a number of entities coming from two different files. Let me explain. I have a file with the correct names of some entities, and I have another entity with a large amount of entity names that might not be written exactly as they should be. I would like to run a flow (fuzzy match?) that returns a column that shows the which "incorrect" name matches with the correct name. See below a table that tries to illustrate what I am trying to achieve:

Full NameWeird NameExpected returnGeorgeJingoGeorjeJohn EltonJonRingo ZiggyJingoPaulElvisPol Georje  Jon  Jingo  Pol

Any help is greatly appreciated

CharlieS · Accepted Answer

I've put together a workflow to get you started using the Fuzzy Match tool. I'm honestly not very familiar with the methodology nuances of different match styles, so someone else will have to help there.

In the attached example, I was only able to match "Georje", "Jon", and "Pol".