Help with finding a select column of keywords in another column of keywords

Hi, I'm trying to see if any keywords in column B match any of the keywords in column A. I need a formula that will return any value so that I can filter out and save the list of keywords in column A into another workbook. It can't be an exact match. I just need to see if any of the keywords in any way are present in column A.

Example:

Column A
womens shoes size 4
womens shoes size 6
blue shoes
red shoes
purple shoes


Column B
size 4
6
purple socks



In this case the formula should return a value for these keywords in column A:

womens shoes size 4
womens shoes size 6
purple shoes

Thanks,

I think the easiest solution would be to take the values in Column B and transpose them across the top row: Highlight all values in column B, Right Click Copy, Left Click in cell B1, Right Click Paste Special Transpose. Your keywords are now the headers across row 1 of your sheet. In cell B2 type the formula:

=IF(ISNUMBER(SEARCH(B$1,$A2)),"Match","")

Copy this formula down and across for each keyword column. You can then filter the keyword column for cells that contain the term "Match".