I just posted a new UDF in the library. This one is a modification of the split string UDF previously posted, but takes a pattern for the delimiter instead of a single character. This was written to handle requests such as, "how do I find all the distinct words in a text column?"
The UDF can be found here.