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

Here are the results of your fuzzy-string dictionary search for “chickens” 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.

23 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
chickens	19	26	743	(None)
chickees	19	25	851	1	chickees
chicken	18	27	898	1	chicken_
thickens	17	26	641	1	thickens
checkers	19	31	784	2	checkers
chicanes	15	5	937	2	chicanes
chickee	18	31	1155	2	chicke_e
chickened	21	4	462	2	chickened
chickpeas	22	4	295	2	chickpeas
chicks	17	53	1759	2	chick__s
chicles	14	35	1250	2	chicle_s
chicness	15	3	559	2	chicness
clickers	16	39	1020	2	clickers
crickets	16	41	812	2	crickets
dickens	14	44	1013	2	_dickens
hickeys	19	50	822	2	_hickeys
quickens	23	3	425	2	quickens
shickers	17	30	1282	2	shickers
sickens	13	44	1148	2	_sickens
slickens	14	31	726	2	slickens
thicken	16	31	787	2	thicken_
thickets	17	28	708	2	thickets
whickers	20	29	798	2	whickers

Search took 4 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	121059	0.376	475242.0
2	DLD Change Limit	121059	23	3.466	34927.6
3	Display Results	23	23	0.016	1437.5
	(SQL Overall)	178691	23	3.858	46317.0