You don't indicate what the results should be. Your sample data does not appear to include any matches, either.
If you were to put this formula in C2 and copy down, the LAST word from column A that existed in the text string in column B will appear in C. Only one result per cell.
=LOOKUP(2, 1/(ISNUMBER(SEARCH($A$1:$A$16, B1))), $A$1:$A$16)
Bookmarks