Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “squama” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

17 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
squama	17	3	653	(None)
squamae	18	4	572	1	squamae
squab	16	38	1073	2	squa_b
squabs	17	42	932	2	squabs
squad	15	51	1079	2	squa_d
squads	16	44	1029	2	squads
squall	15	3	800	2	squall
squamate	19	4	578	2	squamate
square	15	45	1336	2	square
squark	19	43	811	2	squark
squash	18	4	683	2	squash
squat	14	37	2014	2	squa_t
squats	15	37	1296	2	squats
squaw	17	36	898	2	squa_w
squawk	22	38	537	2	squawk
squaws	18	43	878	2	squaws
summa	9	47	1331	2	s_umma

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	82551	0.326	548131.9
2	DLD Change Limit	82551	17	2.546	32423.8
3	Display Results	17	17	0.016	1062.5
	(SQL Overall)	178691	17	2.888	61873.6