AFAIK this does require VBA code. I wrote an Access utility in VBA
that does exactly this cho it works by scrubbing punctuation out of
each list, then comparing each "word" ("Ed" and "Begley" and "Jr" are
each words in this context) in each entry in list A to each word in
each entry in list B. The output is an integer number corresponding to
the number of word matches found.