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

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

37 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
channel	12	39	1048	(None)
cannel	8	42	1640	1	c_annel
chancel	14	40	1177	1	chancel
channels	13	38	849	1	channels
charnel	12	40	1005	1	charnel
chunnel	12	39	530	1	chunnel
cancel	10	53	1668	2	c_ancel
canned	9	50	2206	2	c_anned
cannels	9	34	1336	2	c_annels
canner	8	46	2598	2	c_anner
chaine	11	51	1922	2	chaine_
chained	13	38	1269	2	chained
chaines	12	45	1873	2	chaines
chance	13	46	1709	2	chance_
chanced	15	41	1321	2	chanced
chancels	15	43	908	2	chancels
chancer	14	42	1563	2	chancer
chances	14	52	1809	2	chances
change	12	41	1675	2	change_
changed	14	42	1414	2	changed
changer	13	42	1554	2	changer
changes	13	45	1758	2	changes
channeled	15	4	491	2	channeled
channeler	14	4	460	2	channeler
chanted	13	40	1595	2	chanted
chanter	12	39	1973	2	chanter
chantey	15	41	1254	2	chantey
chapel	13	49	1137	2	cha_pel
charnels	13	32	817	2	charnels
chattel	12	38	889	2	chattel
chinned	13	48	1049	2	chinned
chunnels	13	30	455	2	chunnels
coannex	16	3	551	2	coannex
flannel	10	3	542	2	flannel
hansel	9	52	1437	2	_hansel
rechannel	14	4	432	2	rechannel
scrannel	10	4	403	2	scrannel

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	107671	0.423	422437.4
2	DLD Change Limit	107671	37	3.106	34665.5
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	3.545	50406.5