Compare two lists of words to find closest matches

Hello, I'm trying to figure out how I can compare one list of words to another, and get the closest match based on the number of similar letters in the cell. I have the Levenshtein formula, which gives you the percentage match based on two cells, but I need a way to have these two different lists lined up in order to be able to use the formula.

One list of words is shorter, and the other list is more comprehensive. How can I do this?

Thanks, Elise

What you do mean by "lined up"? Are you comparing each word in one list to all other words in the other list? Or just one-to-one comparisons?

It would be helpful to provide your file, or at least a small sample so we can see better what you're trying to do. I have not implemented the Levenshtein formula before but I suspect it may need to be implemented as a macro.

(P.S. I work on Research Blvd in Rockville)

Something like this perhaps...ListCompare.xlsx