vlookup for finding out wrongly spelled names and yet match the match

Dear Friends

So many times you might have come across my problem.We are having a list of 200 names.We have got our manager or colleague giving another list of same names which are spelled wrongly by one or two letters (ex Instead of Winston ,it is pronounced Winstonn) still it should match because seven letters of this name matches. I tried with this formula "LOOKUP(2,1/SEARCH($a$1:$a$200,d1),$a$1:$a$200)" but it does not work well
I took a sample list from my database ..In my case both lists A and B are having some mistakes still I want to match each other on the basis of maximum number of continuous letters matching each other

Can any body help to solve my problem

List A
Mary Mathew
George Mathew
K Thomos John
John Abraham S
Michael John
Valsa Mary Mathew
Anu George MP
Anju George K
Valsa Maryy Mathew
Thomas Mathen
Michael Thomas Mathew


List B
Anu George Mathew
Thomos Jo M
Michael Thoms
John Abrhm
George Math
Mary Mathew Johnson
Micael John
Valsa Marry Math
Anjuu George
Thomas Mathhen
K Thomos

Finally it should match as

List A List B
Mary Mathew Mary Mathew Johnson
George Mathew George Math
K Thomos John K Thomos
John Abraham S John Abrhm
Michael John Micael John
Valsa Mary Mathew Valsa Marry Math
Anu George MP Anu George Mathew
Anju George K Anjuu George
Valsa Maryy Mathew Valsa Marry Mathew
Thomas Mathen Thomas Mathhen
Michael Thomas Mathew Michael Thoms

thank you very much for your response sir..for fuzzy look up i need to install a software..is there anyother way by formula or by macro sir?

You can use a wildcard with VLOOKUP

VLOOKUP("*" & A2 & "*", .........

If that helps?

how exactly i should use because it returns error when i use it like VLOOKUP("*"&D9&"*",$F$9:$F$19,1) or VLOOKUP("*"&D9&"*",$F$9:$F$19,0)

Can you provide a sample with some data showing what you are trying to return? It works for me, but I may not understand what you are after.