Calculate name string percentage based on fuzzy lookup or Excel VBA

[Jyotirmaya]

I have a excel file where in sheet1 I have column A B C, In Column B, I want to test the strings matching percentage, what can I do to check it ?? Using Fuzzylookup or excel VBA ? Please help

 

[kvsrinivasamurthy]

Explain with example of required result.

 

[Jyotirmaya]

Example - 1

Example -2

Please check

 

[kvsrinivasamurthy]

Not clear.