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

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

61 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
doffers	14	35	985	(None)
coffers	15	41	1269	1	coffers
differs	14	33	997	1	differs
doffer	13	39	1135	1	doffer_
duffers	14	34	1009	1	duffers
goffers	14	40	921	1	goffers
offers	12	34	996	1	_offers
buffers	15	33	1079	2	buffers
coffees	15	32	957	2	coffees
coffer	14	41	1286	2	coffer_
confers	12	41	2009	2	confers
defers	10	51	1694	2	d_efers
deffer	13	44	1130	2	deffer_
defiers	11	39	1399	2	defiers
differ	13	39	1084	2	differ_
dobbers	12	35	1325	2	dobbers
dockers	14	37	1500	2	dockers
dodders	10	55	1179	2	dodders
dodgers	10	52	1382	2	dodgers
doers	6	52	2571	2	do__ers
doffed	14	42	850	2	doffe_d
doffs	12	56	1433	2	doff__s
doggers	10	44	1343	2	doggers
doozers	17	41	929	2	doozers
dopers	9	55	2248	2	do_pers
dormers	10	43	1392	2	dormers
dorpers	10	41	1317	2	dorpers
dorsers	8	35	1630	2	dorsers
dosers	7	57	2363	2	do_sers
dossers	8	45	1623	2	dossers
doters	7	44	2391	2	do_ters
dotters	8	37	1597	2	dotters
dousers	8	48	1727	2	dousers
dowers	10	45	2329	2	do_wers
downers	11	39	1277	2	downers
dowsers	11	50	1353	2	dowsers
dozers	16	48	1542	2	do_zers
duffels	14	29	645	2	duffels
duffer	13	47	1166	2	duffer_
feoffers	13	3	313	2	feoffers
gaffers	14	42	871	2	gaffers
gofers	10	47	1151	2	go_fers
goffer	13	40	951	2	goffer_
golfers	11	44	1008	2	golfers
hoofers	13	45	1332	2	hoofers
loafers	10	34	946	2	loafers
lofters	10	39	1290	2	lofters
niffers	13	28	736	2	niffers
offer	11	43	1138	2	_offer_
proffers	16	12	659	2	proffers
puffers	15	34	920	2	puffers
reoffers	14	3	469	2	reoffers
rolfers	10	40	1181	2	rolfers
roofers	10	50	1390	2	roofers
scoffers	16	28	613	2	scoffers
suffers	13	31	1354	2	suffers
toffees	13	32	708	2	toffees
troffers	14	12	543	2	troffers
wolfers	13	40	963	2	wolfers
woofers	13	38	1058	2	woofers
zaffers	22	38	677	2	zaffers

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.373	479064.3
2	DLD Change Limit	107671	61	3.516	30623.2
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	3.905	45759.5