find matching names - Fuzzy Match

[mp2624]

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 Name	Weird Name	Expected return
George	Jingo	Georje
John	Elton	Jon
Ringo	Ziggy	Jingo
Paul	Elvis	Pol
	Georje
	Jon
	Jingo
	Pol

Any help is greatly appreciated 

[CharlieS · Accepted solution]

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".