I would SPLIT the
[Sentences] column into one-word-per-row and then JOIN that result to your
[Words exist] column
Slight snag may be that a word may not be separated by spaces - e.g. hyphen, comma, etc., so you will have to take care of that.
I suggest you use Jeff Moden’s Splitter Function as its probably the most efficient one out there.
yeah, that would be deadly I’m afraid …
P.S. On tables where we want to do this (typically free-word search on names and Address, and product Descriptions etc.) we maintain a permanent table of split-words (i.e. change that any time the source Description is changed). We also have a dictionary of word-stems and alias words, so that we can “tune” the things that an end user might search for against the actual descriptions.
So for example Mice might be set up as an alias for Mouse - maybe Rat/Rats too? - ditto for plural-alias for Dogs and Cats