Fuzzy Match Workflow

[nmotiani]

I am trying to match org names to another list of org names.

Since the names from both datasets don't exactly match, which is why I cant use the join tool. How do I figure out the close matches? Can someone help me build a short workflow?

example:

Data Set 1

Organization	ID
Apple	1
Orange	2
Banana	3
Kiwi	4

Data Set 2

Organization	ID
Apple Association	A
Orange Company	B
Banana and brothers	C
Kiwi and Co.	D

[jrlindem · Accepted solution]

Instead of Fuzzy Match, use the Find Replace tool!  See below.

[jrlindem]

Following up on this.  @nmotiani  did this solve your need?  If so, please mark the solution for other's benefit!  -Jay

[mkeiffer]

@nmotiani  My approach to this would be first do a Find and Replace on common business name terms (Company, Co., Association, etc.) and then from there, I would do a Fuzzy Match tool and try to find the matches in that manner.  If interested, I could build you a quick workflow with the data you provided to illustrate this.