Thanks to all of you my helpful kuya....honestly i have to analyze first what all you have written as it hardly sync into my brain

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