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

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

75 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
doffer	13	39	1135	(None)
coffer	14	41	1286	1	coffer
deffer	13	44	1130	1	deffer
differ	13	39	1084	1	differ
doffed	14	42	850	1	doffed
doffers	14	35	985	1	doffers
duffer	13	47	1166	1	duffer
goffer	13	40	951	1	goffer
offer	11	43	1138	1	_offer
boffed	15	36	948	2	boffed
buffer	14	45	1268	2	buffer
coffee	14	41	1374	2	coffee
coffers	15	41	1269	2	coffers
confer	11	40	1868	2	confer
daffed	14	42	949	2	daffed
daffier	14	5	783	2	daffier
dafter	10	48	1334	2	dafter
deafer	10	41	1481	2	deafer
defer	9	46	1975	2	d_efer
defier	10	51	1865	2	defier
defter	10	42	1592	2	defter
differs	14	33	997	2	differs
dobber	11	40	1542	2	dobber
docker	13	44	1765	2	docker
dodder	9	47	1291	2	dodder
dodger	9	58	1705	2	dodger
doer	5	77	3470	2	do__er
doff	11	62	2578	2	doff__
doffs	12	56	1433	2	doff_s
dogger	9	52	1678	2	dogger
doozer	16	39	1046	2	doozer
doper	8	61	2839	2	do_per
dopier	9	35	1592	2	dopier
dormer	9	44	1590	2	dormer
dorper	9	43	1457	2	dorper
dorser	7	48	1918	2	dorser
doser	6	62	2856	2	do_ser
dosser	7	44	1797	2	dosser
doter	6	54	2862	2	do_ter
dotier	7	39	1703	2	dotier
dotter	7	44	1934	2	dotter
dourer	7	42	1527	2	dourer
douser	7	56	2163	2	douser
dower	9	50	2770	2	do_wer
downer	10	44	1492	2	downer
dowser	10	47	1608	2	dowser
dozer	15	84	1927	2	do_zer
dozier	16	36	1163	2	dozier
duffel	13	40	775	2	duffel
duffers	14	34	1009	2	duffers
feoffer	12	3	302	2	feoffer
gaffer	13	43	1013	2	gaffer
gofer	9	48	1428	2	go_fer
goffers	14	40	921	2	goffers
golfer	10	44	1118	2	golfer
hoofer	12	40	1495	2	hoofer
loafer	9	36	1094	2	loafer
lofter	9	46	1472	2	lofter
niffer	12	37	844	2	niffer
offed	12	35	916	2	_offed
offers	12	34	996	2	_offers
ofter	8	41	1687	2	_ofter
proffer	15	12	693	2	proffer
puffer	14	46	1073	2	puffer
reoffer	13	3	501	2	reoffer
rolfer	9	44	1227	2	rolfer
roofer	9	44	1528	2	roofer
scoffer	15	31	702	2	scoffer
softer	9	40	1531	2	softer
suffer	12	43	1451	2	suffer
toffee	12	33	1101	2	toffee
troffer	13	12	586	2	troffer
wolfer	12	42	998	2	wolfer
woofer	12	44	1136	2	woofer
zaffer	21	39	715	2	zaffer

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.330	541487.9
2	DLD Change Limit	82551	75	2.563	32208.7
3	Display Results	75	75	0.013	5769.2
	(SQL Overall)	178691	75	2.906	61490.4