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

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

88 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
suffer	12	43	1451	(None)
buffer	14	45	1268	1	buffer
duffer	13	47	1166	1	duffer
puffer	14	46	1073	1	puffer
scuffer	15	32	888	1	scuffer
snuffer	13	31	885	1	snuffer
stuffer	13	34	979	1	stuffer
suffers	13	31	1354	1	suffers
surfer	9	35	1588	1	surfer
bluffer	15	39	688	2	bluffer
buffed	15	43	1314	2	buffed
buffers	15	33	1079	2	buffers
buffet	14	31	1378	2	buffet
buffier	15	6	840	2	buffier
chuffer	18	33	714	2	chuffer
coffer	14	41	1286	2	coffer
cuffed	15	43	1121	2	cuffed
deffer	13	44	1130	2	deffer
differ	13	39	1084	2	differ
doffer	13	39	1135	2	doffer
duffel	13	40	775	2	duffel
duffers	14	34	1009	2	duffers
fluffer	12	33	650	2	fluffer
gaffer	13	43	1013	2	gaffer
gauffer	14	7	442	2	gauffer
goffer	13	40	951	2	goffer
gruffer	14	7	579	2	gruffer
huffed	16	37	1015	2	huffed
huffier	16	3	749	2	huffier
luffed	13	38	1082	2	luffed
muffed	15	42	1059	2	muffed
muffler	15	39	834	2	muffler
niffer	12	37	844	2	niffer
offer	11	43	1138	2	_offer
puffed	15	35	1060	2	puffed
puffers	15	34	920	2	puffers
puffery	18	23	511	2	puffery
puffier	15	4	797	2	puffier
quaffer	22	3	513	2	quaffer
ruffe	11	47	1381	2	ruffe_
ruffed	13	43	1274	2	ruffed
ruffes	12	41	1242	2	ruffes
ruffler	13	36	972	2	ruffler
safer	8	47	2181	2	s_afer
scoffer	15	31	702	2	scoffer
scuffed	16	29	824	2	scuffed
scuffers	16	30	749	2	scuffers
scuffler	16	28	670	2	scuffler
shuffler	17	30	680	2	shuffler
sifter	9	45	1623	2	sifter
sluffed	14	30	830	2	sluffed
sniffer	13	31	890	2	sniffer
snuffed	14	30	807	2	snuffed
snuffers	14	32	692	2	snuffers
snuffier	14	27	694	2	snuffier
snuffler	14	31	741	2	snuffler
softer	9	40	1531	2	softer
staffer	13	29	909	2	staffer
stiffer	13	31	939	2	stiffer
stuffed	14	32	897	2	stuffed
stuffers	14	27	738	2	stuffers
stuffier	14	33	662	2	stuffier
suaver	9	30	1423	2	suaver
suber	7	49	2450	2	su_ber
sucker	12	41	2066	2	sucker
sudser	7	35	1128	2	sudser
suer	4	53	3403	2	su__er
suffari	13	4	550	2	suffari
suffered	15	3	673	2	suffered
sufferer	14	3	606	2	sufferer
sufficer	16	22	582	2	sufficer
suffix	19	3	523	2	suffix
suiter	6	41	2181	2	suiter
sulfur	9	3	791	2	sulfur
sulker	10	40	1592	2	sulker
summer	10	40	1771	2	summer
sunder	7	40	1982	2	sunder
super	7	49	2448	2	su_per
supper	10	41	1543	2	supper
surer	5	48	3310	2	su_rer
surfed	10	38	1446	2	surfed
surfers	10	36	1413	2	surfers
surfier	10	26	1354	2	surfier
surger	7	43	2009	2	surger
sutler	6	37	1839	2	sutler
tuffet	12	26	1208	2	tuffet
tufter	9	31	993	2	tufter
zaffer	21	39	715	2	zaffer

Search took 6 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.766	233278.1
2	DLD Change Limit	82551	88	5.076	16263.0
3	Display Results	88	88	0.063	1396.8
	(SQL Overall)	178691	88	5.905	30261.0