Furzy Match help required on Names

[mmustkee]

Hi Team,

I have a list of around 1000 of names and I need to check to what extent, the names are matching. I need marching score and one common name as result for all the names in column A

Kindly refer example below:

Name	Result
Saif /Name	Saif /Name
Name/Saif	Saif /Name
Name/Saif MR	Saif /Name
MR Name/SaiF	Saif /Name
Kara/Tim
Kara,Tim
Dim/Tore Show
DimTore/ Show
Dim/Show tore
ERS/COL
RERS/COL
ERS/COL,
NDLER/JERRY L
NDLER/L JERRY
NDLER/JERRY
NDLER/L, JERRY
NDLER/JERRY,
NDLER/L JERRY ANDREW
HUG/XUEN
XUEN/HUG
XUEN,HUG
XUEN,HUG MS
XUEN,HUG DR

[mmustkee]

and if there are no match and the name is unique, then the same name should be appear in result.