MATCH or LOOKUP to find where a string appears in two columns

[Churchy LaFemme]

Not sure I can articulate this correctly.

I have two columns (on different worksheets) that have names. In this example below, all the lines would be a match because at least one 4-letter string in each row matches. (Having any name match is enough, do not need to match all names.)

What I"m trying now is to yank the last names out and use them in alpha order, but that it this could go fast, that would be amazing and interseting.

This is in a no-macro environment, but I would be willint to use a maco, get my results, and then kill the macro before putting the workbooks back where they live.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Table 1
[/TD]
[TD]Table 2
[/TD]
[/TR]
[TR]
[TD]Sam Winchester, Dean Winchester, Castiel
[/TD]
[TD]The Winchesters, memory-loss Castiel
[/TD]
[/TR]
[TR]
[TD]Kevin Tran, the Winchesters
[/TD]
[TD]Kevin, Sam, Dean
[/TD]
[/TR]
[TR]
[TD]Chuck Shurley, Becky Rosen, Sam Winchester
[/TD]
[TD]Shurley, Chuck; Rosen, Becky; Winchester, Sam
[/TD]
[/TR]
[TR]
[TD]Castiel, Kevin Tran, Chuck Shurley
[/TD]
[TD]Tran, Shurley, Castiel
[/TD]
[/TR]
</tbody>[/TABLE]