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

Here are the results of your fuzzy-string dictionary search for “duffel” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

290 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
duffel	13	40	775	(None)
duffels	14	29	645	1	duffels
duffer	13	47	1166	1	duffer
duffle	13	36	853	1	duffle
buffed	15	43	1314	2	buffed
buffer	14	45	1268	2	buffer
buffet	14	31	1378	2	buffet
cuffed	15	43	1121	2	cuffed
daffed	14	42	949	2	daffed
deffer	13	44	1130	2	deffer
defuel	10	34	893	2	defuel
differ	13	39	1084	2	differ
doffed	14	42	850	2	doffed
doffer	13	39	1135	2	doffer
duel	5	67	2970	2	du__el
duff	11	43	2664	2	duff__
duffers	14	34	1009	2	duffers
duffles	14	30	892	2	duffles
duffs	12	52	1662	2	duff_s
huffed	16	37	1015	2	huffed
luffed	13	38	1082	2	luffed
muffed	15	42	1059	2	muffed
muffle	14	33	964	2	muffle
puffed	15	35	1060	2	puffed
puffer	14	46	1073	2	puffer
ruffe	11	47	1381	2	ruffe_
ruffed	13	43	1274	2	ruffed
ruffes	12	41	1242	2	ruffes
ruffle	12	41	1167	2	ruffle
suffer	12	43	1451	2	suffer
tuffet	12	26	1208	2	tuffet
baffed	15	48	1217	3	baffed
baffle	14	39	987	3	baffle
biffed	15	44	988	3	biffed
bluffed	16	32	643	3	bluffed
bluffer	15	39	688	3	bluffer
boffed	15	36	948	3	boffed
bouffe	14	43	831	3	bouffe_
bouffes	15	38	863	3	bouffes
buff	12	52	2986	3	buff__
buffalo	15	5	372	3	buffalo
buffers	15	33	1079	3	buffers
buffest	15	29	864	3	buffest
buffets	15	31	759	3	buffets
buffi	13	61	1220	3	buff_i
buffier	15	6	840	3	buffier
buffo	13	51	1218	3	buff_o
buffos	14	44	785	3	buffos
buffs	13	55	1951	3	buff_s
buffy	16	50	1337	3	buff_y
bulbel	10	45	1068	3	bulbel
bushel	11	45	1394	3	bushel
chuffed	19	31	664	3	chuffed
chuffer	18	33	714	3	chuffer
coffee	14	41	1374	3	coffee
coffer	14	41	1286	3	coffer
coffle	14	35	904	3	coffle
cudgel	10	3	670	3	cudgel
cuff	12	53	2799	3	cuff__
cuffs	13	50	1749	3	cuff_s
cupel	9	5	1430	3	cu_pel
cupful	13	5	642	3	cupful
curfew	14	42	674	3	curfew
daff	11	52	2968	3	daff__
daffier	14	5	783	3	daffier
daffily	17	3	513	3	daffily
daffs	12	51	1642	3	daff_s
daffy	15	55	1028	3	daff_y
dafter	10	48	1334	3	dafter
damsel	9	14	803	3	damsel
darnel	7	43	1218	3	darnel
deafen	10	38	967	3	deafen
deafer	10	41	1481	3	deafer
deckel	13	49	1104	3	deckel
defer	9	46	1975	3	d_efer
deffest	14	30	880	3	deffest
defied	11	50	1638	3	defied
defier	10	51	1865	3	defier
defies	10	46	2405	3	defies
defile	10	52	1666	3	defile
deflea	10	3	744	3	deflea
defter	10	42	1592	3	defter
defuels	11	29	698	3	defuels
del	4	67	5275	3	d___el
devel	9	42	1712	3	d_evel
diel	5	90	3460	3	d__iel
diesel	7	44	1040	3	diesel
diff	11	62	2884	3	diff__
differs	14	33	997	3	differs
diffs	12	63	1548	3	diff_s
dispel	9	3	1032	3	dispel
djebel	16	4	345	3	djebel
doff	11	62	2578	3	doff__
doffers	14	35	985	3	doffers
doffs	12	56	1433	3	doff_s
donzel	16	3	631	3	donzel
dorsel	7	53	1550	3	dorsel
dossel	7	48	1364	3	dossel
dottel	7	36	1089	3	dottel
dowel	9	56	1819	3	d_owel
drivel	10	51	1038	3	drivel
dual	5	59	2817	3	du__al
dubbed	12	41	1321	3	dubbed
dubber	11	38	1455	3	dubber
ducal	8	48	1642	3	du_cal
duce	7	69	3350	3	du_ce_
duces	8	63	2747	3	du_ces
ducked	14	47	1801	3	ducked
ducker	13	43	1799	3	ducker
ductal	9	3	899	3	ductal
ducted	10	40	1212	3	ducted
dude	6	56	2966	3	du_de_
duded	8	44	1713	3	du_ded
dudeen	8	5	717	3	dudeen
dudes	7	54	2437	3	du_des
due	4	52	4986	3	du__e_
dueled	8	48	1366	3	dueled
dueler	7	42	1368	3	dueler
duels	6	56	1923	3	du__els
dues	5	60	4550	3	du__es
duet	5	64	4626	3	du__et
dueted	8	41	1359	3	dueted
dufus	9	40	1081	3	du_fus
dufuses	11	43	659	3	dufuses
duiker	11	41	1059	3	duiker
duke	9	56	2810	3	du_ke_
duked	11	52	1846	3	du_ked
dukes	10	50	2347	3	du_kes
dulcet	9	3	1449	3	dulcet
dull	5	64	3044	3	du__ll
dulled	8	47	1942	3	dulled
duller	7	40	1770	3	duller
dulse	6	54	1504	3	dulse_
dulses	7	39	1365	3	dulses
dumbed	12	40	1208	3	dumbed
dumber	11	44	1417	3	dumber
dumped	12	38	1449	3	dumped
dumper	11	46	1521	3	dumper
dunce	8	63	1926	3	dunce_
dunces	9	52	1575	3	dunces
dune	5	61	3758	3	du_ne_
dunes	6	53	3217	3	du_nes
dunged	9	54	1469	3	dunged
dunked	12	43	1528	3	dunked
dunker	11	36	1646	3	dunker
dunned	8	50	1552	3	dunned
dunner	7	39	1382	3	dunner
dunted	8	47	1850	3	dunted
dupe	7	66	3060	3	du_pe_
duped	9	51	1832	3	du_ped
duper	8	55	1900	3	du_per
dupes	8	64	2593	3	du_pes
duple	8	53	1586	3	duple_
duplex	16	38	697	3	duplex
dupped	12	44	1164	3	dupped
dural	6	49	2389	3	du_ral
dure	5	63	4181	3	du_re_
dured	7	50	2540	3	du_red
dures	6	56	3592	3	du_res
durned	8	41	1317	3	durned
dusked	12	41	1251	3	dusked
dusted	8	39	1837	3	dusted
duster	7	49	1972	3	duster
duties	7	49	2190	3	duties
dutiful	11	4	476	3	dutiful
duvet	9	3	2187	3	du_vet
dynel	9	56	985	3	d_ynel
farfel	12	43	1043	3	farfel
feel	7	52	3384	3	__feel
fluffed	13	29	590	3	fluffed
fluffer	12	33	650	3	fluffer
fuel	7	68	2473	3	__fuel
fulfil	12	4	642	3	fulfil
funnel	9	36	1074	3	funnel
fusel	8	52	1849	3	fu_sel
gaffe	12	41	1165	3	gaffe_
gaffed	14	42	1020	3	gaffed
gaffer	13	43	1013	3	gaffer
gaffes	13	48	1110	3	gaffes
gauffer	14	7	442	3	gauffer
goffer	13	40	951	3	goffer
gruffed	15	4	494	3	gruffed
gruffer	14	7	579	3	gruffer
guff	11	46	2493	3	guff__
guffaw	16	4	279	3	guffaw
guffs	12	44	1482	3	guff_s
gulfed	11	48	1001	3	gulfed
gunnel	7	34	1105	3	gunnel
gunsel	7	33	985	3	gunsel
haffet	15	3	1170	3	haffet
huff	13	56	2384	3	huff__
huffier	16	3	749	3	huffier
huffily	19	3	469	3	huffily
huffs	14	45	1474	3	huff_s
huffy	17	48	1023	3	huff_y
jugful	17	3	460	3	jugful
jurel	12	45	1633	3	ju_rel
kugel	10	6	857	3	ku_gel
kummel	14	26	617	3	kummel
luff	10	44	2670	3	luff__
luffa	11	40	902	3	luff_a
luffas	12	33	748	3	luffas
luffs	11	45	1628	3	luff_s
miffed	15	39	871	3	miffed
muff	12	47	2386	3	muff__
muffin	14	29	887	3	muffin
muffled	16	37	778	3	muffled
muffler	15	39	834	3	muffler
muffles	15	39	1045	3	muffles
muffs	13	41	1421	3	muff_s
mugful	12	3	540	3	mugful
mussel	8	34	1290	3	mussel
mutuel	8	3	782	3	mutuel
naffed	13	40	833	3	naffed
niffer	12	37	844	3	niffer
offal	11	3	624	3	_offal
offed	12	35	916	3	_offed
offer	11	43	1138	3	_offer
ousel	5	52	2240	3	ou_sel
outfeel	10	3	754	3	outfeel
outfelt	10	3	1060	3	outfelt
ouzel	14	46	1232	3	ou_zel
piffle	14	41	823	3	piffle
pouffe	14	44	826	3	pouffe_
pouffed	16	36	595	3	pouffed
pouffes	15	40	812	3	pouffes
puff	12	55	2543	3	puff__
puffers	15	34	920	3	puffers
puffery	18	23	511	3	puffery
puffier	15	4	797	3	puffier
puffily	18	3	484	3	puffily
puffin	14	114	900	3	puffin
puffs	13	41	1493	3	puff_s
puffy	16	44	1075	3	puff_y
pummel	12	27	804	3	pummel
purfle	11	25	1118	3	purfle
quaffed	23	3	425	3	quaffed
quaffer	22	3	513	3	quaffer
raffle	12	39	1070	3	raffle
refeel	9	39	1324	3	refeel
refel	8	49	2081	3	_refel
reffed	13	47	1251	3	reffed
refuel	9	39	1262	3	refuel
riffed	13	38	1156	3	riffed
riffle	12	42	1023	3	riffle
rubel	7	54	1683	3	ru_bel
rueful	9	4	820	3	rueful
ruff	10	51	2765	3	ruff__
ruffled	14	36	915	3	ruffled
ruffler	13	36	972	3	ruffler
ruffles	13	35	1227	3	ruffles
ruffly	15	33	667	3	ruffly
ruffs	11	45	1674	3	ruff_s
runnel	6	35	1066	3	runnel
scuffed	16	29	824	3	scuffed
scuffer	15	32	888	3	scuffer
scuffle	15	26	689	3	scuffle
shuffle	16	27	692	3	shuffle
sluffed	14	30	830	3	sluffed
snuffed	14	30	807	3	snuffed
snuffer	13	31	885	3	snuffer
snuffle	13	26	783	3	snuffle
souffle	13	30	680	3	souffle
stuffed	14	32	897	3	stuffed
stuffer	13	34	979	3	stuffer
suffers	13	31	1354	3	suffers
suffix	19	3	523	3	suffix
surfed	10	38	1446	3	surfed
surfer	9	35	1588	3	surfer
tiffed	13	36	839	3	tiffed
toffee	12	33	1101	3	toffee
truffe	12	7	623	3	truffe_
truffes	13	5	677	3	truffes
truffle	13	8	489	3	truffle
tubful	11	3	668	3	tubful
tuff	10	45	2852	3	tuff__
tuffets	13	26	652	3	tuffets
tuffs	11	51	1826	3	tuff_s
tufted	10	35	928	3	tufted
tufter	9	31	993	3	tufter
tunnel	6	43	1063	3	tunnel
turfed	10	31	1096	3	turfed
umbel	9	36	1284	3	_umbel
unfed	9	46	1422	3	_unfed
unfelt	9	24	1346	3	_unfelt
waffed	16	45	979	3	waffed
waffle	15	36	918	3	waffle
wurzel	18	3	499	3	wurzel
yaffed	16	45	732	3	yaffed
zaffer	21	39	715	3	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	112716	0.376	475242.0
2	DLD Change Limit	112716	290	5.296	21283.2
3	Display Results	290	290	0.093	3118.3
	(SQL Overall)	178691	290	5.765	30995.8