TSQL Challenge 71 - Play mangled words game in TSQL
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table. You might be able to create more than one correct word from some of the input strings. It is also possible that a mangled word is completely incorrect and no valid word can be created from it.
As an example, given "xtet", the valid word that can be formed is "text".
http://beyondrelational.com/puzzles/challenges/105/play-mangled-words-game-in-tsql.aspx