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

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

74 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
delvers	11	34	1199	(None)
delivers	12	33	1075	1	delivers
delver	10	49	1349	1	delver_
delves	10	49	1708	1	delve_s
elvers	9	38	1498	1	_elvers
beavers	12	44	1732	2	beavers
beliers	9	46	1738	2	beliers
belters	9	38	1941	2	belters
culvers	12	32	983	2	culvers
dealers	8	41	1861	2	dealers
deaves	10	53	1953	2	deave_s
deckers	14	44	1383	2	deckers
deers	6	49	3052	2	de__ers
defers	10	51	1694	2	de_fers
defiers	11	39	1399	2	defiers
deicers	10	36	1273	2	deicers
delayers	12	26	866	2	delayers
deles	6	51	3925	2	del_e_s
deliver	11	33	1224	2	deliver_
delivery	15	28	655	2	delivery
deluders	10	15	643	2	deluders
delve	9	60	1826	2	delve__
delved	11	41	1275	2	delve_d
deniers	8	45	1518	2	deniers
derivers	12	38	1136	2	derivers
desilvers	13	30	608	2	desilvers
deters	7	47	2468	2	de_ters
devels	10	43	1390	2	de_vels
divers	10	50	2496	2	d_ivers
drivers	11	44	1279	2	drivers
drovers	11	52	1264	2	drovers
duelers	8	34	1205	2	duel_ers
duellers	9	26	822	2	duellers
dwellers	12	35	608	2	dwellers
elders	7	48	1730	2	_elders
elver	8	52	1624	2	_elver_
elves	8	51	1874	2	_elve_s
fellers	10	41	1754	2	fellers
fevers	12	54	1489	2	fe_vers
gelders	9	38	1257	2	gelders
halvers	13	33	1142	2	halvers
heavers	13	37	1719	2	heavers
hellers	10	36	1983	2	hellers
helpers	12	33	1185	2	helpers
helves	12	43	1606	2	helve_s
kelters	11	38	1375	2	kelters
leavers	10	37	1778	2	leavers
levers	9	46	2132	2	le_vers
melders	10	32	1391	2	melders
melters	9	39	1831	2	melters
pelters	9	37	2031	2	pelters
pelves	11	45	1466	2	pelve_s
reavers	10	83	2074	2	reavers
reivers	10	51	1708	2	reivers
reliers	7	55	1921	2	reliers
revers	9	45	2963	2	re_vers
salvers	10	39	1600	2	salvers
sellers	7	37	2131	2	sellers
selves	9	41	1961	2	selve_s
servers	10	32	1483	2	servers
severs	9	41	2112	2	se_vers
shelvers	14	38	881	2	shelvers
silvers	10	47	1404	2	silvers
solvers	10	44	1425	2	solvers
telfers	10	29	907	2	telfers
tellers	7	37	1759	2	tellers
velvets	13	32	669	2	velvets
weavers	13	37	1446	2	weavers
weevers	13	37	999	2	weevers
welders	11	33	1341	2	welders
welters	10	35	1606	2	welters
wolvers	13	34	931	2	wolvers
yellers	10	39	1295	2	yellers
yelpers	12	34	820	2	yelpers

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.423	422437.4
2	DLD Change Limit	107671	74	3.203	33615.7
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	3.656	48876.1