Identifying misspelled names?

[Excel_VBA]

I have a column of names in one workbook, and a column in another workbook. Some of the names in the first workbook are misspelled. For example:

Jesse (workbook1) vs. Jessie (workbook2)
Madelynne (workbook1) vs. Madeline (workbook2)

I am trying to use a function that can look at the names in Workbook1 and match them with the correct spelling in Workbook2 as if the values in Workbook1 are spelled exactly the same as they appear in Workbook2.

I've seen some references to products called Fuzzy Match or Fuzzy Duplicates, but I am trying to come up with my own formula.