Fuzzy match - within the same table and add a column

[h12]

Hi all

Below is the table that I have:

c1_Code	c1_role	c1_name	r_code	r_role	r_Name
1A	45	Joe Smith	1A	45	Joey Smith
1A	45	Joe Smith	1A	45	Tony Turner
1A	45	Joe Smith	1A	45	Paul Dickson
B4	23	Bob Marley	B4	23	Bob Marleye
B4	23	Bob Marley	B4	23	Tony Turner

I would like to perform a fuzzy match on the two name columns and then have a column added to the table with the % (the % below are random):

c1_Code	c1_role	c1_name	r_code	r_role	r_Name	Fuzzy %
1A	45	Joe Smith	1A	45	Joey Smith	99
1A	45	Joe Smith	1A	45	Tony Turner	60
1A	45	Joe Smith	1A	45	Paul Dickson	60
B4	23	Bob Marley	B4	23	Bob Marleye	99
B4	23	Bob Marley	B4	23	Tony Turner	60

The idea is that I can now filter out the rows which have less than 80% match score and identify the differences in the way the names are spelt

Many thanks!

[Raj]

@h12 find the workflow attached
mark done if solved.

[h12]

@rajThank you for your prompt reply! I think the first join tool should be joining on name2 right? Also, the 'Tony Turner' row as well as Paul Dickson seems to disappear..