计算表列中的单词出现次数

I have a table with a varchar(255) field. I want to get (via a query, function, or SP) the number of occurences of each word in a group of rows from this table.I have a table with a varchar(255) field. I wan