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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

113 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
death	9	48	2252	(None)
dearth	10	42	1251	1	dearth
deash	9	56	1724	1	deash
deaths	10	59	1444	1	deaths
deathy	13	42	1023	1	deathy
depth	11	43	1185	1	depth
eath	7	57	3566	1	_eath
heath	11	57	2428	1	heath
neath	8	60	2028	1	neath
bath	9	59	4008	2	_bath
beach	12	46	2389	2	beach
beat	6	61	6830	2	beat_
beats	7	60	4224	2	beats
berth	10	49	1788	2	berth
beth	9	66	2923	2	be_th
breath	11	39	1626	2	breath
dah	7	81	4898	2	d_a_h
dash	8	70	3163	2	d_ash
data	5	60	2665	2	d_ata
date	5	64	4332	2	d_ate
dato	5	61	2994	2	d_ato
dead	6	54	3424	2	dea_d
deads	7	57	2691	2	deads
deaf	8	58	3840	2	dea_f
deair	6	58	1719	2	deair
deal	5	63	4741	2	dea_l
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dea_n
deans	6	61	3139	2	deans
dear	5	53	4360	2	dea_r
dears	6	57	3688	2	dears
dearths	11	49	884	2	dearths
deary	9	58	2684	2	deary
deathly	14	33	686	2	deathly
deave	9	50	2233	2	deave
debate	9	44	1919	2	debate
debt	7	71	3902	2	debt_
debts	8	64	1837	2	debts
deet	5	73	5658	2	deet_
deets	6	53	3024	2	deets
defat	9	54	2669	2	defat_
defats	10	51	1455	2	defats
deft	8	55	4022	2	deft_
deity	9	43	1677	2	deity
delate	7	38	2775	2	delate
delt	5	78	5527	2	delt_
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
dent	5	71	5841	2	dent_
dents	6	50	3180	2	dents
depths	12	42	857	2	depths
derat	6	50	4408	2	derat_
derate	7	45	3123	2	derate
derats	7	46	2506	2	derats
detach	12	3	1041	2	detach
doat	5	69	4767	2	doat_
doats	6	52	2488	2	doats
doeth	9	4	1198	2	doeth
doth	8	62	2571	2	d_oth
drat	5	62	4783	2	drat_
drats	6	66	2837	2	drats
each	9	55	3058	2	_each
earth	8	50	2305	2	_earth
eat	3	69	8905	2	_eat_
eats	4	70	5487	2	_eats
eth	6	66	3098	2	_e_th
feat	7	64	5822	2	feat_
feats	8	64	3275	2	feats
hath	10	59	3391	2	_hath
health	12	47	1214	2	health
hearth	12	53	1521	2	hearth
heat	7	70	6142	2	heat_
heaths	12	63	1638	2	heaths
heathy	15	61	1121	2	heathy
heats	8	58	3840	2	heats
heth	10	70	2802	2	he_th
ideate	7	3	1368	2	ideate
lath	7	66	4038	2	_lath
leach	10	54	2252	2	leach
leash	8	55	1921	2	leash
loath	8	49	1860	2	loath
math	9	54	3745	2	_math
meat	6	63	5960	2	meat_
meats	7	50	3405	2	meats
meaty	10	70	2131	2	meaty
meth	9	58	2784	2	me_th
neat	4	63	5678	2	neat_
neats	5	59	3190	2	neats
oath	7	61	3215	2	_oath
path	9	91	3491	2	_path
peach	12	54	2249	2	peach
peat	6	59	6793	2	peat_
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
rath	7	60	3766	2	_rath
reach	10	51	2388	2	reach
reata	5	42	2539	2	reata
seat	4	75	7556	2	seat_
seats	5	48	4434	2	seats
sheath	12	4	1289	2	sheath
snath	8	64	1980	2	snath
swath	11	59	2038	2	swath
teach	10	52	2112	2	teach
teat	4	59	6363	2	teat_
teats	5	56	3681	2	teats
teeth	8	73	1585	2	teeth
tenth	8	54	2183	2	tenth
teth	7	63	2789	2	te_th
wealth	12	37	922	2	wealth
wrath	11	57	1587	2	wrath
wreath	12	41	1119	2	wreath
yeah	10	67	2541	2	yea_h

Search took 6 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	53800	0.890	200776.4
2	DLD Change Limit	53800	113	3.483	15446.5
3	Display Results	113	113	0.030	3766.7
	(SQL Overall)	178691	113	4.403	40583.9