(2 row(s) affected) Table 'Worktable'. Scan count 4, logical reads 36, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'TC71_Dictionary'. Scan count 1, logical reads 1, physical reads 0, read

(2 row(s) affected) Table 'Worktable'. Scan count 1, logical reads 109, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'tsqlc_Tally'. Scan count 10, logical reads 40, physical reads 0, read-

Forgot to include 40 Scans 247 Logical Reads

The first few CTEs split out the MangledWords into multiple rows preseving ID; and then for both DictionaryWords and MangledWords, create tables for the letters with a counter column - using ROW_NUMBER. Then the essence of the solution is to INNER JOIN