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

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

25 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
deafens	11	31	725	(None)
deadens	9	34	1069	1	deadens
deafen	10	38	967	1	deafen_
bedeafens	15	4	241	2	bedeafens
davens	10	46	1291	2	d_avens
deacons	10	3	1039	2	deacons
deaden	8	37	1432	2	deaden_
deafened	13	3	585	2	deafened
deafer	10	41	1481	2	deafe_r
deafest	11	29	1151	2	deafest
deafness	12	3	621	2	deafness
dealers	8	41	1861	2	dealers
deans	6	61	3139	2	dea__ns
deaves	10	53	1953	2	deave_s
deepens	10	30	781	2	deepens
defend	11	39	1049	2	de_fend
defends	12	35	877	2	de_fends
defense	11	3	750	2	de_fense
defers	10	51	1694	2	de_fers
heavens	13	43	930	2	heavens
leadens	8	36	1098	2	leadens
leavens	10	40	930	2	leavens
neatens	7	33	1040	2	neatens
peahens	12	30	757	2	peahens
weakens	14	36	706	2	weakens

Search took 10 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.703	254183.5
2	DLD Change Limit	107671	25	8.766	12282.8
3	Display Results	25	25	0.000
	(SQL Overall)	178691	25	9.469	18871.2