Originally posted by kris123
Just want to add some info about the simple function pattern example:

Table1:
=======
name1
----------------
TOM WELLING
TOM CRUISE
TOM PANGIT
PANGIT

Table2:
=======
name2
-------------------
WELLING CRUISE TOM POGI
IKAW AY PANGIT

Only table2 will serve as the source table to match with, while
table one is the transaction table.

Rows that matched in table1 are TOM WELLING, TOM CRUISE, and PANGIT coz all words are contained in rows in table2.

Thanks honieluv
Maybe you have more info to add?
In this case take it from Jeff's word:
Can you say "full table scan baby"? Also, this method has tons of potential for error... As pando says, make your data clean.