Need to modify formula that checks if word in phrase appears in list of single words

Hi All - I hope you can help me with this. I know enough to break things and be dangerous.

I have a list of phrases in one column and I want to see if any word in a phase appears in another column of single words. This is the formula I am using and it mostly works...

=SUMPRODUCT(--ISNUMBER(SEARCH(BroadWords,A2)))>0 (Note: BroadWords is the Named Range of single words)

The problem I have is this. For example, in the phrase column I have Trash Box. In the Named Range, I have neither trash nor box, however I do have trashy. The result is Trash Box gets flagged as True.

Is there a way to modify the formula to only match whole words?

Thanks,
Bill

=SUMPRODUCT(--ISNUMBER(SEARCH(BroadWords&" ",A2&" ")))>0

I believe that worked! My ability to break things and be dangerous also enables me to partially understand what you did (I think). In my formula it looks for a string. In your modification, It looks a space before and/or after the string. Is that correct? If it is and then this won't catch a first word in the phrase, if it is or than it will.

thank you very much for your reply.