Comparing Names

[Masond3]

HI Team , 

Hoping your well. 

I need some help, i would like to compare "Name 1" vs "Name 2". Based on the comparison i would like to provide a "Helper" which articulates the difference between the name comparison.

I see four distinct buckets for the helper; 

• Name Change : Names completely different ( no comparison ) 
• Name Same  -  Abbreviation , Punctuation :  Name is the same, there is a punctuation  (Comma, semicolon ) however there is abbreviations in the name ;

For example 
LTD = Limited 
Inc = Incorporation
Corp = Corporation 

• Name Same - Punctuation  : Names exactly the same, however there is just a punctuation  (Comma, semicolon ) in the name
• Name Change - Punctuation : Names are very similar , But there is a change 

Name 1	Name 2	Helper
Mason Ltd	Nike Corp	Name Change
Apple Brands, Inc	Apple Brands, Incorporation.	Name Same -  Abbreviation , Punctuation
Tyndale Enterprises, Inc	KTyndale Enterprises, Inc	Name Same - Punctuation
Hello Treasury, Llc.	Hello Treasury, Llc	Name Same - Punctuation
Delli Properties	Delli Properties, Llc	Name Change - Punctuation
London Orthopaedic Hospital	London Orthopaedic Hospital, Llc	Name Change - Punctuation

Looking forward to your help 

[randreag]

hi @Masond3 

There are multiple options but the way to compare the complete word is etter using fuzzy match

here attached an example 

I hope it helps