Okay, I just posted a UDF to help solve this problem:
http://sqljunkies.com/WebLog/amachanic/articles/PatternSplitString.aspx
... To use it for this problem, you would have to cursor/loop through the table for each row you want, insert the words into a temp table, and then take the final count from there. I'm not aware of a set-based way to handle the problem.
--
Adam Machanic
whoisactive