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

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

76 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
wormers	12	40	1257	(None)
dormers	10	43	1392	1	dormers
formers	12	82	1795	1	formers
ormers	8	43	1614	1	_ormers
warmers	12	45	1429	1	warmers
workers	14	46	1269	1	workers
wormer	11	45	1491	1	wormer_
armers	8	55	2027	2	_armers
boomers	11	41	1591	2	boomers
borders	10	43	1753	2	borders
borers	8	51	2268	2	bor_ers
comers	10	53	2808	2	co_mers
corders	10	45	2088	2	corders
corers	8	52	3107	2	cor_ers
corkers	13	41	1885	2	corkers
cormels	11	38	1337	2	cormels
corners	9	47	2331	2	corners
dewormers	15	25	519	2	dewormers
dormer	9	44	1590	2	dormer_
dorpers	10	41	1317	2	dorpers
dorsers	8	35	1630	2	dorsers
farmers	12	43	1526	2	farmers
firmers	12	47	1144	2	firmers
foamers	12	38	1210	2	foamers
forcers	12	42	1571	2	forcers
forgers	11	52	1818	2	forgers
forkers	14	46	1578	2	forkers
former	11	42	2140	2	former_
formes	11	46	2371	2	forme_s
gomers	9	41	1688	2	go_mers
gorgers	9	48	1364	2	gorgers
harmers	12	41	1659	2	harmers
homers	11	48	2197	2	ho_mers
lorimers	10	3	661	2	lorimers
omers	7	69	2319	2	_o_mers
orders	7	43	1599	2	_orders
ormer	7	52	1837	2	_ormer_
porkers	13	43	1493	2	porkers
porters	9	37	2270	2	porters
roamers	9	37	1346	2	roamers
roomers	9	54	1641	2	roomers
sorners	7	34	1687	2	sorners
sorters	7	42	2113	2	sorters
swarmers	13	4	632	2	swarmers
termers	9	54	1450	2	termers
vomers	11	56	1494	2	vo_mers
warders	11	34	1681	2	warders
warmer	11	38	1673	2	warmer_
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
wirers	9	46	1789	2	wir_ers
wolfers	13	40	963	2	wolfers
wolvers	13	34	931	2	wolvers
womera	11	13	759	2	wo_mera
womeras	12	8	759	2	wo_meras
wommera	14	14	406	2	wommera
wommeras	15	13	377	2	wommeras
wonders	11	33	1599	2	wonders
wonners	10	43	1281	2	wonners
wooers	9	37	1244	2	wo_oers
woofers	13	38	1058	2	woofers
woolers	10	42	1402	2	woolers
woomera	12	13	577	2	woomera
woomeras	13	13	511	2	woomeras
worker	13	47	1511	2	worker_
wormed	12	43	1430	2	worme_d
wormgears	15	4	192	2	wormgears
wormier	12	27	876	2	wormier_
wormils	12	3	673	2	wormils
worms	10	53	2076	2	worm__s
worriers	11	25	781	2	worriers
worsens	10	46	1026	2	worsens
worser	9	51	1752	2	worser_
worses	9	55	2295	2	worse_s
worsets	10	55	1284	2	worsets
wowsers	13	48	876	2	wowsers

Search took 4 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.376	475242.0
2	DLD Change Limit	107671	76	2.826	38100.1
3	Display Results	76	76	0.016	4750.0
	(SQL Overall)	178691	76	3.218	55528.6