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

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

71 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
deaths	10	59	1444	(None)
dearths	11	49	884	1	dearths
death	9	48	2252	1	death_
deathy	13	42	1023	1	deathy
depths	12	42	857	1	depths
heaths	12	63	1638	1	heaths
baths	10	59	2292	2	_baths
beats	7	60	4224	2	beat_s
berths	11	47	1242	2	berths
beths	10	55	1922	2	be_ths
breaths	12	44	1118	2	breaths
dahs	8	82	3181	2	d_a_hs
dates	6	56	3915	2	d_ates
datos	6	52	2278	2	d_atos
deads	7	57	2691	2	dea_ds
deairs	7	40	1378	2	deairs
deals	6	54	3534	2	dea_ls
deans	6	61	3139	2	dea_ns
dears	6	57	3688	2	dea_rs
dearth	10	42	1251	2	dearth_
deash	9	56	1724	2	deash_
deashes	11	33	1390	2	deashes
deathly	14	33	686	2	deathly
deaves	10	53	1953	2	deaves
debates	10	37	1853	2	debates
debts	8	64	1837	2	debt_s
deets	6	53	3024	2	deet_s
defats	10	51	1455	2	defat_s
delates	8	35	2628	2	delates
deltas	7	44	1482	2	deltas
delts	6	57	3179	2	delt_s
dents	6	50	3180	2	dent_s
depth	11	43	1185	2	depth_
derates	8	40	2889	2	derates
derats	7	46	2506	2	derat_s
doats	6	52	2488	2	doat_s
drats	6	66	2837	2	drat_s
earths	9	50	1459	2	_earths
eath	7	57	3566	2	_eath_
eats	4	70	5487	2	_eat_s
eths	7	66	1952	2	_e_ths
feats	8	64	3275	2	feat_s
healths	13	47	875	2	healths
hearths	13	53	1107	2	hearths
heath	11	57	2428	2	heath_
heathy	15	61	1121	2	heathy
heats	8	58	3840	2	heat_s
heths	11	63	1778	2	he_ths
ideates	8	3	1373	2	ideates
laths	8	60	2240	2	_laths
maths	10	56	2402	2	_maths
meats	7	50	3405	2	meat_s
meatus	8	51	1292	2	meatus
meths	10	53	2023	2	me_ths
neath	8	60	2028	2	neath_
neats	5	59	3190	2	neat_s
oaths	8	61	1731	2	_oaths
paths	10	55	2138	2	_paths
peats	7	61	4019	2	peat_s
reatas	6	40	2101	2	reatas
seats	5	48	4434	2	seat_s
sheaths	13	5	875	2	sheaths
snaths	9	51	1291	2	snaths
swaths	12	53	1264	2	swaths
teats	5	56	3681	2	teat_s
tenths	9	44	1266	2	tenths
teths	8	54	1851	2	te_ths
wealths	13	36	581	2	wealths
wraths	12	38	1008	2	wraths
wreaths	13	33	837	2	wreaths
yeahs	11	52	1455	2	yea_hs

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.373	479064.3
2	DLD Change Limit	82551	71	2.470	33421.5
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	2.873	62196.7