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

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

77 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
hedges	11	50	1626	(None)
edges	7	57	1874	1	_edges
hedge	10	53	1735	1	hedge_
hedged	12	52	1181	1	hedged
hedger	11	49	1265	1	hedger
hedgers	12	43	1026	1	hedgers
henges	10	45	1646	1	henges
kedges	12	48	1298	1	kedges
ledges	8	49	1801	1	ledges
sedges	8	38	1781	1	sedges
wedges	11	46	1458	1	wedges
aedes	6	46	2515	2	aed_es
badges	10	39	1737	2	badges
beiges	9	10	1441	2	beiges
budges	10	48	2013	2	budges
cadges	10	47	1671	2	cadges
cedes	8	49	2733	2	ced_es
dodges	9	61	1908	2	dodges
dredges	10	37	935	2	dredges
edge	6	57	1968	2	_edge_
edged	8	55	1453	2	_edged
edger	7	52	1595	2	_edger
edgers	8	44	1392	2	_edgers
fadges	11	48	1403	2	fadges
fidges	11	41	1439	2	fidges
fledges	12	40	939	2	fledges
fudges	11	43	1450	2	fudges
hades	9	60	3511	2	had_es
hadjes	17	52	1040	2	hadjes
heaves	12	41	2030	2	heaves
hebes	10	55	2167	2	he_bes
heddles	12	33	1162	2	heddles
heder	9	56	2364	2	hed_er
heders	10	41	1976	2	heders
hedgier	12	36	788	2	hedgier
hedgiest	13	29	813	2	hedgiest
hedgy	13	45	1075	2	hedg_y
heezes	18	42	1164	2	heezes
helves	12	43	1606	2	helves
hemes	10	50	3108	2	he_mes
henge	9	48	1983	2	henge_
heres	8	62	4590	2	he_res
heroes	9	49	2382	2	heroes
herpes	11	55	1732	2	herpes
heughs	13	51	690	2	heughs
hexes	15	51	2304	2	he_xes
hides	9	51	2942	2	hid_es
hinges	10	51	2103	2	hinges
judges	15	37	1346	2	judges
kedge	11	55	1373	2	kedge_
kedged	13	43	975	2	kedged
ledge	7	65	1949	2	ledge_
ledger	8	59	1439	2	ledger
ledgers	9	49	1218	2	ledgers
leges	6	44	2729	2	le_ges
lodges	8	68	2015	2	lodges
merges	9	41	2249	2	merges
midges	10	35	1648	2	midges
nudges	8	41	1474	2	nudges
peages	9	43	2185	2	peages
pedes	8	53	2729	2	ped_es
pledges	11	38	1158	2	pledges
redes	6	51	3913	2	red_es
redoes	7	46	2377	2	redoes
redyes	10	42	1409	2	redyes
reges	6	56	2879	2	re_ges
ridges	8	58	1701	2	ridges
sedge	7	50	1997	2	sedge_
serges	7	42	2597	2	serges
sledges	9	45	1157	2	sledges
veges	9	41	1887	2	ve_ges
venges	10	40	1515	2	venges
verges	10	43	2018	2	verges
wedge	10	52	1566	2	wedge_
wedged	12	51	1030	2	wedged
wedgies	12	39	1021	2	wedgies
wodges	11	74	1368	2	wodges

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.343	520965.0
2	DLD Change Limit	82551	77	2.360	34979.2
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	2.733	65382.7