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

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

94 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
wormer	11	45	1491	(None)
dormer	9	44	1590	1	dormer
former	11	42	2140	1	former
ormer	7	52	1837	1	_ormer
warmer	11	38	1674	1	warmer
worker	13	47	1511	1	worker
wormed	12	43	1430	1	wormed
wormers	12	40	1257	1	wormers
wormier	12	27	876	1	wormier
worser	9	51	1752	1	worser
armer	7	69	2445	2	_armer
boomer	10	46	1851	2	boomer
border	9	44	1997	2	border
borer	7	51	3127	2	bor_er
comer	9	58	3269	2	co_mer
corder	9	43	2288	2	corder
corer	7	55	3887	2	cor_er
corker	12	47	2085	2	corker
cormel	10	38	1560	2	cormel
corner	8	46	2562	2	corner
dewormer	14	25	632	2	dewormer
dormers	10	43	1392	2	dormers
dorper	9	43	1457	2	dorper
dorser	7	48	1918	2	dorser
farmer	11	50	1738	2	farmer
firmer	11	47	1244	2	firmer
foamer	11	47	1431	2	foamer
forcer	11	49	1734	2	forcer
forger	10	48	2077	2	forger
forker	13	47	1790	2	forker
forme	10	52	2599	2	forme_
formed	12	50	2117	2	formed
formee	11	39	1994	2	formee
formers	12	82	1795	2	formers
formes	11	46	2371	2	formes
gomer	8	52	2065	2	go_mer
gorger	8	61	1698	2	gorger
gorier	7	37	1937	2	gorier
gormed	10	50	1383	2	gormed
harmer	11	47	1956	2	harmer
homer	10	58	2845	2	ho_mer
lorimer	9	3	775	2	lorimer
normed	9	50	1454	2	normed
omer	6	70	2839	2	_o_mer
order	6	50	1936	2	_order
ormers	8	43	1614	2	_ormers
porker	12	49	1754	2	porker
porter	8	42	2441	2	porter
roamer	8	47	1516	2	roamer
roomer	8	47	1863	2	roomer
sorer	5	62	3659	2	sor_er
sorner	6	47	2039	2	sorner
sorter	6	44	2509	2	sorter
swarmer	12	4	780	2	swarmer
termer	8	57	1725	2	termer
vomer	10	55	1738	2	vo_mer
warder	10	40	2027	2	warder
warier	9	37	2289	2	warier
warmed	12	45	1690	2	warmed
warmers	12	45	1429	2	warmers
warner	9	37	1722	2	warner
warper	11	40	1558	2	warper
wirer	8	51	2495	2	wir_er
wirier	9	42	1555	2	wirier
wolfer	12	42	998	2	wolfer
wolver	12	41	971	2	wolver
women	10	46	1925	2	wo_men
womera	11	13	759	2	wo_mera
wommera	14	14	406	2	wommera
wonder	10	36	1781	2	wonder
wonner	9	51	1444	2	wonner
wooer	8	43	1669	2	wo_oer
woofer	12	44	1136	2	woofer
wooler	9	36	1587	2	wooler
woomera	12	13	577	2	woomera
worded	11	43	1662	2	worded
wordier	11	25	1121	2	wordier
wore	7	71	4467	2	wor_e_
worked	14	53	1470	2	worked
workers	14	46	1269	2	workers
workmen	16	3	593	2	workmen
worm	9	61	2949	2	worm__
wormgear	14	4	188	2	wormgear
wormil	11	3	804	2	wormil
worms	10	53	2076	2	worm_s
wormy	13	75	1425	2	worm_y
worrier	10	23	1168	2	worrier
worse	8	65	2526	2	worse_
worsen	9	55	1387	2	worsen
worses	9	55	2295	2	worses
worset	9	67	2658	2	worset
wowser	12	51	1020	2	wowser
wrier	8	45	2175	2	w_rier
wryer	11	48	930	2	w_ryer

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.360	496363.9
2	DLD Change Limit	82551	94	2.280	36206.6
3	Display Results	94	94	0.033	2848.5
	(SQL Overall)	178691	94	2.673	66850.4