Finding and extracting names

Hi everyone, i have a list of shorthand names (list a), along with a list of full names (list b).

The number of names may not match exactly, but i want to turn all the shorthand names into the full names provided a certain number of letters from names in list (a) match list (b)

So for example, list (a) - John W D, list (b) - John William Doe
turn John W D into John William Doe since J, O, H (or O, H, N etc) match up and are in sequence. What kind of function would i be looking to use?

This is definitely not a foolproof way of doing this, so i was wondering if you have any suggestions? thanks in advance!

If you attach your workbook I can provide a solution.