Fuzzy Match Match Style "NickName" Extract

[Masond3]

Hi All, 

Daft question, whilst using alteryx there is a fuzzy matching match style of "Nickname" 

I was just wondering is there anyway i can get an extract of that Nickname Table ? 

Or know of any files/ links that have name to nickname list i use instead of making my own from scratch 

Regards 

Masond3

[ChrisTX · Accepted solution]

Check out one of these folders, depending on your version of Alteryx:

\ProgramFiles\Alteryx\RuntimeData\FuzzyMatch\Nicknames\

or
\Program Files\Alteryx\bin\RuntimeData\FuzzyMatch\Nicknames

Attached is the Nickname list we use

Tips and Tricks for Fuzzy Matching
Community > Designer > Browse Knowledge > Tips and Tricks for Fuzzy Matching

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tips-and-Tricks-for-Fuzzy-Matching/ta-p/1230

Guide to nickname fuzzy matching
Community > Designer > Browse Knowledge > Nicholas or Nick(name) - A Guide to Tweaking your Fuzzy Matching
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Nicholas-or-Nick-name-A-Guide-to-Tweaking-yo...

Version 11.0 help > Reference > Fuzzy FAQ
Adding to the Nickname table can be done by updating the database (Common Nicknames.yxdb ) located

in one of the folders above

https://help.alteryx.com/11.0/index.htm#FuzzyFAQ.htm%3FTocPath%3DReference%7C_____24

Tips and Tricks when working with Nicknames

• Set Generate Keys to “None” when using the Names w/ Nicknames match style IF you have the First Name in a single field.
• If your name is contained in a single field (John Smith or Smith, John), you will want to select a method to Generate Keys and check the box “Generate Keys for Each Word”.
• The “Soundex” method of generating keys is generally preferred when working with names.

Chris

[Masond3]

Hi @ChrisTX 

Thanks for sending those pathways.  :)