I have two tables, one with text strings, and one with words.
How do I take each string/row in TABLE A and see how many of the "words" from TABLE B each string in TABLE A contains - and get a result like this:
TABLE A
id: 1 contains 2 words (car, red) from TABLE B
id: 2 contains 2 words (house, hill) from TABLE B
id: 3 contains 0 words from TABLE B
id: 4 contains 2 words (small, shoe) from TABLE B