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

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

330 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
duffle	13	36	853	(None)
duffel	13	40	775	1	duffel
duffles	14	30	891	1	duffles
muffle	14	33	964	1	muffle
ruffle	12	41	1167	1	ruffle
baffle	14	39	987	2	baffle
coffle	14	35	904	2	coffle
defile	10	52	1666	2	defile
duff	11	43	2664	2	duff__
duffels	14	29	645	2	duffels
duffer	13	47	1166	2	duffer
duffs	12	52	1662	2	duff_s
duple	8	53	1586	2	du_ple
muffled	16	37	778	2	muffled
muffler	15	39	834	2	muffler
muffles	15	39	1044	2	muffles
piffle	14	41	823	2	piffle
purfle	11	25	1118	2	purfle
raffle	12	39	1070	2	raffle
riffle	12	42	1023	2	riffle
ruffe	11	47	1381	2	ruff_e
ruffled	14	36	915	2	ruffled
ruffler	13	36	972	2	ruffler
ruffles	13	35	1226	2	ruffles
ruffly	15	33	667	2	ruffly
scuffle	15	26	688	2	scuffle
shuffle	16	27	691	2	shuffle
snuffle	13	26	782	2	snuffle
souffle	13	30	679	2	souffle
truffle	13	8	489	2	truffle
waffle	15	36	918	2	waffle
audile	7	33	1530	3	audile
baffled	16	41	806	3	baffled
baffler	15	41	811	3	baffler
baffles	15	37	1068	3	baffles
bluffly	18	3	343	3	bluffly
bouffe	14	43	831	3	bouff_e
bubale	10	40	1462	3	bubale
bubble	9	40	1659	3	bubble
buckle	14	48	1519	3	buckle
buddle	10	43	1308	3	buddle
buff	12	52	2985	3	buff__
buffable	18	4	439	3	buffable
buffalo	15	5	372	3	buffalo
buffed	15	43	1314	3	buffed
buffer	14	45	1268	3	buffer
buffet	14	31	1378	3	buffet
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
bugle	8	47	2194	3	bu_gle
bumble	12	42	1689	3	bumble
bundle	9	43	1557	3	bundle
bungle	9	71	1611	3	bungle
burble	10	46	1770	3	burble
burgle	9	48	1586	3	burgle
bustle	8	40	1548	3	bustle
butle	7	50	2310	3	bu_tle
coffee	14	41	1374	3	coffee
coffled	16	29	736	3	coffled
coffles	15	26	1000	3	coffles
cuddle	10	44	1453	3	cuddle
cuff	12	53	2799	3	cuff__
cuffed	15	43	1121	3	cuffed
cuffless	16	3	428	3	cuffless
cuffs	13	50	1749	3	cuff_s
cupule	10	34	1072	3	cupule
curdle	9	55	1431	3	curdle
curule	8	36	1412	3	curule
cuttle	8	41	1389	3	cuttle
dabble	11	45	1519	3	dabble
daddle	9	42	1428	3	daddle
daff	11	52	2968	3	daff__
daffed	14	42	949	3	daffed
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
daftly	13	3	544	3	daftly
daggle	9	37	1190	3	daggle
dale	5	56	4398	3	d__ale
dandle	8	42	1809	3	dandle
dangle	8	41	1930	3	dangle
dapple	11	3	885	3	dapple
darkle	11	38	1394	3	darkle
dartle	7	37	1483	3	dartle
dawdle	11	39	950	3	dawdle
dayfly	16	3	381	3	dayfly
dazzle	15	3	685	3	dazzle
deafly	13	38	912	3	deafly
decile	9	46	1921	3	decile
deckle	13	120	1245	3	deckle
deface	12	31	1386	3	deface
defame	12	32	1243	3	defame
deffer	13	44	1130	3	deffer
defiled	12	40	1310	3	defiled
defiler	11	39	1188	3	defiler
defiles	11	40	1684	3	defiles
define	10	47	1814	3	define
deflea	10	3	744	3	d_eflea
deftly	13	3	653	3	deftly
defuel	10	34	893	3	defuel
defuse	10	57	1272	3	defuse
defuze	19	48	784	3	defuze
dele	5	68	4308	3	d__ele
dhole	9	52	1536	3	d_hole
dibble	11	40	1384	3	dibble
diddle	9	49	1521	3	diddle
diff	11	62	2883	3	diff__
differ	13	39	1084	3	differ
diffs	12	63	1548	3	diff_s
diffuse	14	4	437	3	diffuse
dimple	11	35	1279	3	dimple
dindle	8	44	1722	3	dindle
dingle	8	43	1707	3	dingle
dipole	9	11	1285	3	dipole
doable	9	31	1524	3	doable
docile	9	42	1312	3	docile
doff	11	62	2578	3	doff__
doffed	14	42	850	3	doffed
doffer	13	39	1135	3	doffer
doffs	12	56	1433	3	doff_s
dole	5	65	5000	3	d__ole
dongle	8	36	1249	3	dongle
doodle	8	32	1285	3	doodle
dottle	7	42	1250	3	dottle
double	9	40	1399	3	double
drumble	12	33	789	3	drumble
dual	5	59	2817	3	du_al_
dually	10	32	1006	3	dually
duals	6	56	2008	3	du_als
ducal	8	48	1642	3	ducal_
duce	7	69	3350	3	du__ce
duckie	13	35	1166	3	duckie
ductile	10	4	847	3	ductile
ductule	10	6	550	3	ductule
duddie	9	34	886	3	duddie
dude	6	56	2966	3	du__de
due	4	52	4986	3	du___e
duel	5	67	2970	3	du_el_
dueled	8	48	1366	3	du_eled
dueler	7	42	1368	3	du_eler
duelled	9	35	975	3	duelled
dueller	8	32	983	3	dueller
duelli	7	6	700	3	duelli
duello	7	5	678	3	duello
duels	6	56	1923	3	du_els
duende	8	3	692	3	duende
duffers	14	34	1009	3	duffers
dufus	9	40	1081	3	du_fus
dufuses	11	43	659	3	dufuses
duke	9	56	2810	3	du__ke
dull	5	64	3044	3	du__ll
dulled	8	47	1942	3	du_lled
duller	7	40	1770	3	du_ller
dulls	6	45	2374	3	du_lls
dully	9	49	2163	3	du_lly
dulse	6	54	1504	3	du_lse
duly	8	53	2303	3	du__ly
dumbly	14	39	960	3	dumbly
dunce	8	63	1926	3	du_nce
dune	5	61	3758	3	du__ne
dunite	7	3	1501	3	dunite
dupable	12	23	838	3	dupable
dupe	7	66	3060	3	du__pe
duplex	16	38	697	3	du_plex
durable	10	23	1272	3	durable
dural	6	49	2389	3	dural_
dure	5	63	4181	3	du__re
durrie	7	37	1325	3	durrie
dyable	12	30	898	3	dyable
file	7	54	4664	3	__file
fuddle	11	33	1210	3	fuddle
fugle	9	49	1554	3	fu_gle
fumble	13	32	1426	3	fumble
fusile	9	43	1349	3	fusile
futile	9	39	1495	3	futile
gaffe	12	41	1165	3	gaff_e
gruffly	17	41	389	3	gruffly
guff	11	46	2493	3	guff__
guffaw	16	4	279	3	guffaw
guffs	12	44	1482	3	guff_s
guggle	9	41	1043	3	guggle
guile	6	45	2113	3	gu_ile
gurgle	8	39	1247	3	gurgle
guttle	7	41	1197	3	guttle
guzzle	15	29	791	3	guzzle
huckle	15	39	1307	3	huckle
huddle	11	37	1299	3	huddle
huff	13	56	2384	3	huff__
huffed	16	37	1015	3	huffed
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
humble	13	36	1505	3	humble
hurdle	10	37	1279	3	hurdle
hurtle	9	35	1294	3	hurtle
hustle	9	31	1399	3	hustle
jubile	15	29	1025	3	jubile
juggle	15	43	1028	3	juggle
jumble	17	40	1265	3	jumble
jungle	14	40	1265	3	jungle
justle	13	32	1158	3	justle
luff	10	44	2670	3	luff__
luffa	11	40	902	3	luff_a
luffas	12	33	748	3	luffas
luffed	13	38	1082	3	luffed
luffs	11	45	1628	3	luff_s
lunule	6	3	843	3	lunule
muckle	14	34	1358	3	muckle
muddle	10	34	1463	3	muddle
muff	12	47	2385	3	muff__
muffed	15	42	1059	3	muffed
muffin	14	29	887	3	muffin
mufflers	16	31	600	3	mufflers
muffs	13	41	1421	3	muff_s
mule	6	52	3697	3	mu__le
mumble	12	36	1434	3	mumble
muscle	10	3	1097	3	muscle
mutule	8	3	1142	3	mutule
muzzle	16	31	939	3	muzzle
nubble	10	38	1371	3	nubble
nubile	8	32	1270	3	nubile
nuncle	8	3	936	3	nuncle
nuzzle	14	29	808	3	nuzzle
outflew	13	3	642	3	outflew
outfly	12	3	827	3	outfly
piffled	16	36	640	3	piffled
piffles	15	36	876	3	piffles
pouffe	14	44	826	3	pouff_e
puddle	10	39	1415	3	puddle
puff	12	55	2543	3	puff__
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
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
pule	6	50	4095	3	pu__le
pungle	9	44	1357	3	pungle
purfled	13	24	872	3	purfled
purfler	12	24	873	3	purfler
purfles	12	25	1184	3	purfles
purple	10	27	1267	3	purple
puzzle	16	31	860	3	puzzle
quale	14	36	1785	3	qu_ale
raffled	14	42	908	3	raffled
raffler	13	33	922	3	raffler
raffles	13	36	1184	3	raffles
refile	9	51	2237	3	refile
riffled	14	33	860	3	riffled
riffler	13	32	835	3	riffler
riffles	13	39	1116	3	riffles
rifle	8	55	1833	3	_rifle
rubble	10	43	1567	3	rubble
ruble	7	45	2125	3	ru_ble
ruckle	12	44	1458	3	ruckle
ruddle	8	34	1420	3	ruddle
ruff	10	51	2765	3	ruff__
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
rufflers	14	34	719	3	rufflers
rufflier	14	3	400	3	rufflier
rufflike	18	4	325	3	rufflike
ruffs	11	45	1674	3	ruff_s
rule	4	99	3842	3	ru__le
rumble	10	37	1881	3	rumble
rumple	10	39	1301	3	rumple
rundle	7	32	1423	3	rundle
runkle	10	36	1154	3	runkle
rustle	6	36	1541	3	rustle
rutile	6	52	1768	3	rutile
scuffled	17	25	619	3	scuffled
scuffler	16	28	669	3	scuffler
scuffles	16	28	785	3	scuffles
shuffled	18	29	623	3	shuffled
shuffler	17	30	679	3	shuffler
shuffles	17	29	777	3	shuffles
skiffle	17	22	520	3	skiffle
snaffle	13	21	624	3	snaffle
sniffle	13	28	764	3	sniffle
snuffled	15	27	702	3	snuffled
snuffler	14	31	740	3	snuffler
snuffles	14	31	840	3	snuffles
snuffly	16	30	519	3	snuffly
souffled	15	27	618	3	souffled
souffles	14	29	811	3	souffles
stifle	9	36	1190	3	stifle
suable	8	39	2055	3	suable
subfile	12	20	1050	3	subfile
subtle	8	21	1343	3	subtle
suckle	12	40	1596	3	suckle
suffer	12	43	1451	3	suffer
suffice	15	19	757	3	suffice
suffix	19	3	523	3	suffix
sufflate	14	5	618	3	sufflate
suffuse	13	3	544	3	suffuse
supple	10	4	1020	3	supple
toffee	12	33	1101	3	toffee
trifle	9	40	1288	3	trifle
truffe	12	7	623	3	truff_e
truffled	15	6	399	3	truffled
truffles	14	8	558	3	truffles
tubule	8	3	985	3	tubule
tuff	10	45	2852	3	tuff__
tuffet	12	26	1208	3	tuffet
tuffs	11	51	1826	3	tuff_s
tufoli	9	3	397	3	tufoli
tuille	6	30	1264	3	tuille
tule	4	57	3587	3	tu__le
tulle	5	40	1993	3	tu_lle
tumble	10	32	1564	3	tumble
turtle	6	32	1357	3	turtle
tussle	6	3	714	3	tussle
uncle	7	3	1705	3	_uncle
unmuffle	16	6	234	3	unmuffle
utile	5	47	1893	3	_utile
waffie	15	33	856	3	waffie
waffled	17	35	752	3	waffled
waffler	16	37	778	3	waffler
waffles	16	32	998	3	waffles
waffly	18	30	543	3	waffly
whiffle	19	3	353	3	whiffle
yule	7	57	2514	3	yu__le
zaffre	21	35	466	3	zaffre

Search took 9 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.140	1276364.3
2	DLD Change Limit	112716	330	7.783	14482.3
3	Display Results	330	330	0.250	1320.0
	(SQL Overall)	178691	330	8.173	21863.6