Looking for keywords in a string of text in a variable from another table

Database

Looking for keywords in a string of text in a variable from another table

hi all,

i have ran out of ideas for this one 

i have a table where there are 4 results that have keywords in them so 

Word 

a

b

c

d

and i have another table where these key words may be in that variable like 

A        B        C                D 

john Daivs london i went to shop in A 

im trying to write a query where i can say if the keyword from table A is in within the sentance of table 2/D then it is a result ?

any help would be great