Fuzzy matching String and get the comparison and filter data which comparison is 97& or more show...

Hi Team,

i have a requirement to calculate Fuzzy logic as per below .

1. Have list of vendors name in one column .

2. Generating record ID against each vendor name.

3. Then it compare Vendor Name one to another and create another column MatchScore and MatchScorevendorname

4. if Vendor Name is matching 100 % one to another then MatchScore and MatchScorevendorname is 100% .

5. After generating Matching score then filter the data to show which has only 97% or more MatchScore.