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

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

407 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
luffa	11	40	902	(None)
luff	10	44	2670	1	luff_
luffas	12	33	748	1	luffas
luffs	11	45	1628	1	luffs
bluff	13	44	1383	2	bluff_
bluffs	14	38	837	2	bluffs
buff	12	52	2986	2	buff_
buffi	13	61	1220	2	buffi
buffo	13	51	1218	2	buffo
buffs	13	55	1951	2	buffs
buffy	16	50	1337	2	buffy
cuff	12	53	2799	2	cuff_
cuffs	13	50	1749	2	cuffs
duff	11	43	2664	2	duff_
duffs	12	52	1662	2	duffs
fluff	10	39	1361	2	fluff_
fluffs	11	34	778	2	fluffs
fluffy	14	31	578	2	fluffy
guff	11	46	2493	2	guff_
guffaw	16	4	279	2	guffaw
guffs	12	44	1482	2	guffs
huff	13	56	2384	2	huff_
huffs	14	45	1474	2	huffs
huffy	17	48	1023	2	huffy
loofa	8	59	1281	2	loofa
luffed	13	38	1082	2	luffed
luma	6	55	2752	2	lu_ma
luna	4	62	2985	2	lu_na
lutea	5	48	1907	2	lutea
muff	12	47	2386	2	muff_
muffs	13	41	1421	2	muffs
puff	12	55	2543	2	puff_
puffs	13	41	1493	2	puffs
puffy	16	44	1075	2	puffy
ruff	10	51	2765	2	ruff_
ruffe	11	47	1381	2	ruffe
ruffs	11	45	1674	2	ruffs
sluff	11	40	1681	2	sluff_
sluffs	12	34	958	2	sluffs
sulfa	8	3	1392	2	sulfa
tufa	7	50	1661	2	tu_fa
tuff	10	45	2852	2	tuff_
tuffs	11	51	1826	2	tuffs
aff	9	55	3761	3	_aff_
alfa	7	76	2427	3	_alfa
alula	5	3	1709	3	alu_la
alumna	8	5	734	3	alumna
aura	4	58	3625	3	au_ra
baff	12	46	3227	3	baff_
baffs	13	47	1805	3	baffs
baffy	16	55	1192	3	baffy
biff	12	50	2689	3	biff_
biffs	13	48	1441	3	biffs
biffy	16	47	1113	3	biffy
blaff	13	52	1648	3	blaff_
blaffs	14	42	662	3	blaffs
bluffed	16	32	643	3	bluffed
bluffer	15	39	688	3	bluffer
bluffly	18	3	343	3	bluffly
boff	12	47	2733	3	boff_
boffo	13	60	1037	3	boffo
boffs	13	49	1550	3	boffs
bouffe	14	43	831	3	bouffe
bubba	8	43	1180	3	bubba
buffalo	15	5	372	3	buffalo
buffed	15	43	1314	3	buffed
buffer	14	45	1268	3	buffer
buffet	14	31	1378	3	buffet
buffos	14	44	785	3	buffos
bulla	7	46	2056	3	bulla
bumf	11	61	2651	3	bumf_
bumfs	12	54	1405	3	bumfs
buna	6	47	3072	3	bu_na
bunya	10	38	1009	3	bunya
bura	6	61	3953	3	bu_ra
burka	11	46	1769	3	burka
burqa	16	50	1309	3	burqa
bursa	7	49	2152	3	bursa
caff	12	56	3167	3	caff_
caffs	13	54	1737	3	caffs
chufa	13	48	911	3	chufa
chuff	16	48	1249	3	chuff_
chuffs	17	42	778	3	chuffs
chuffy	20	44	586	3	chuffy
cliff	13	59	1713	3	cliff_
cliffs	14	47	759	3	cliffs
cliffy	17	43	524	3	cliffy
coff	12	69	3078	3	coff_
coffs	13	49	1630	3	coffs
cuffed	15	43	1121	3	cuffed
cuif	9	65	2914	3	cuif_
cuifs	10	48	1469	3	cuifs
culpa	9	36	1096	3	culpa
cuppa	11	39	852	3	cuppa
curf	9	75	3878	3	curf_
curfs	10	51	2214	3	curfs
curia	7	45	2376	3	curia
daff	11	52	2968	3	daff_
daffs	12	51	1642	3	daffs
daffy	15	55	1028	3	daffy
diff	11	62	2884	3	diff_
diffs	12	63	1548	3	diffs
doff	11	62	2578	3	doff_
doffs	12	56	1433	3	doffs
duffel	13	40	775	3	duffel
duffer	13	47	1166	3	duffer
duffle	13	36	853	3	duffle
dufus	9	40	1081	3	dufus
dulia	6	10	1498	3	dulia
duma	7	55	2445	3	du_ma
dumka	12	43	883	3	dumka
dura	5	52	3211	3	du_ra
durra	6	53	1579	3	durra
eff	9	61	2862	3	_eff_
effs	10	51	1403	3	_effs
eluvia	9	3	613	3	eluvia
fa	5	101	4845	3	___fa
fluffed	13	29	590	3	fluffed
fluffer	12	33	650	3	fluffer
gaff	11	48	2815	3	gaff_
gaffe	12	41	1165	3	gaffe
gaffs	12	49	1465	3	gaffs
gliff	12	49	1566	3	gliff_
gliffs	13	43	632	3	gliffs
gruff	12	47	1214	3	gruff_
gruffs	13	33	745	3	gruffs
gruffy	16	39	601	3	gruffy
guava	9	3	858	3	guava
guffaws	17	6	227	3	guffaws
gulf	8	49	2942	3	gulf_
gulfs	9	49	1530	3	gulfs
gulfy	12	46	1200	3	gulfy
gumma	10	53	1310	3	gumma
gutta	6	46	1338	3	gutta
huffed	16	37	1015	3	huffed
hula	7	49	2375	3	hu_la
huzza	16	4	609	3	huzza
iff	9	67	3039	3	_iff_
iffy	13	53	1228	3	_iffy
infra	8	3	864	3	infra
jiff	17	53	2141	3	jiff_
jiffs	18	57	1031	3	jiffs
jiffy	21	45	831	3	jiffy
juba	13	49	1698	3	ju_ba
juga	12	64	1732	3	ju_ga
junta	12	37	1367	3	junta
jura	11	60	2489	3	ju_ra
kufi	11	9	1065	3	ku_fi
kufis	12	4	925	3	kufis
kuna	8	51	2070	3	ku_na
kurta	9	51	1391	3	kurta
la	2	192	6163	3	l___a
labia	7	52	1901	3	labia
labra	7	54	1546	3	labra
lama	6	66	3529	3	l_ama
lamia	7	53	2432	3	lamia
larva	8	3	1248	3	larva
laura	5	41	1620	3	laura
lava	7	67	2542	3	l_ava
lea	3	76	6018	3	l__ea
leaf	7	64	4103	3	leaf_
leafs	8	57	2118	3	leafs
leafy	11	63	1621	3	leafy
left	7	63	4048	3	l_eft
lefts	8	65	1781	3	lefts
lefty	11	56	1356	3	lefty
lehua	8	3	795	3	lehua
lemma	9	48	1103	3	lemma
lepta	7	57	1439	3	lepta
leva	7	70	2071	3	l_eva
liana	5	39	1589	3	liana
libra	7	47	1242	3	libra
lief	7	60	3699	3	lief_
life	7	54	3373	3	l_ife
lifer	8	58	2215	3	lifer
lift	7	69	4272	3	l_ift
lifts	8	57	1906	3	lifts
lima	6	57	3413	3	l_ima
limba	9	54	1498	3	limba
limpa	9	70	1446	3	limpa
linga	6	68	2081	3	linga
lipa	6	84	2592	3	l_ipa
lira	4	69	2868	3	l_ira
llama	7	9	989	3	llama
loaf	7	67	3490	3	loaf_
loafs	8	56	1699	3	loafs
loca	6	55	2768	3	l_oca
loft	7	65	3914	3	l_oft
lofts	8	55	1836	3	lofts
lofty	11	58	1330	3	lofty
logia	6	81	1660	3	logia
loof	7	81	4105	3	loof_
loofah	12	37	581	3	loofah
loofas	9	42	983	3	loofas
loofs	8	56	2378	3	loofs
lota	4	72	3350	3	l_ota
louma	7	62	1363	3	louma
luau	4	48	2416	3	lu_au
luaus	5	45	1490	3	luaus
lube	6	47	3156	3	lu_be
lubed	8	53	1989	3	lubed
lubes	7	47	2799	3	lubes
luce	6	51	3257	3	lu_ce
luces	7	55	2843	3	luces
lucid	8	43	1457	3	lucid
luck	10	53	2982	3	lu_ck
lucks	11	57	2356	3	lucks
lucky	14	55	1501	3	lucky
lucre	7	64	1552	3	lucre
lude	5	53	3164	3	lu_de
ludes	6	57	2885	3	ludes
ludic	8	29	1280	3	ludic
lues	4	59	4355	3	lu_es
luffing	14	33	1010	3	luffing
lug	4	61	3806	3	lu__g
luge	5	55	3164	3	lu_ge
luged	7	40	1909	3	luged
luger	6	53	2208	3	luger
luges	6	59	2875	3	luges
lugs	5	52	3352	3	lu_gs
lull	4	42	2576	3	lu_ll
lulls	5	41	1965	3	lulls
lulu	4	41	2288	3	lu_lu
lulus	5	43	1516	3	lulus
lum	5	55	4293	3	lu__m
lumas	7	56	2291	3	lumas
lumbar	10	36	1059	3	lumbar
lumen	7	52	2090	3	lumen
lumina	8	46	1354	3	lumina
lump	8	65	3170	3	lu_mp
lumps	9	56	2498	3	lumps
lumpy	12	66	1591	3	lumpy
lums	6	57	3424	3	lu_ms
lunar	5	70	1731	3	lunar
lunas	5	50	2501	3	lunas
lunch	10	49	1724	3	lunch
lune	4	71	4049	3	lu_ne
lunes	5	53	3777	3	lunes
lunet	5	68	3542	3	lunet
lung	5	57	3249	3	lu_ng
lungan	7	47	1021	3	lungan
lunge	6	53	2380	3	lunge
lungi	6	55	1605	3	lungi
lungs	6	52	2388	3	lungs
lunk	8	60	3072	3	lu_nk
lunks	9	48	2245	3	lunks
lunt	4	61	4884	3	lu_nt
lunts	5	58	2690	3	lunts
lunula	6	3	617	3	lunula
luny	7	73	2413	3	lu_ny
lupin	7	52	1584	3	lupin
lupus	7	45	1252	3	lupus
lurch	10	48	1463	3	lurch
lurdan	7	3	836	3	lurdan
lure	4	51	4246	3	lu_re
lured	6	54	2749	3	lured
lurer	5	46	2531	3	lurer
lures	5	61	3853	3	lures
lurex	12	48	1673	3	lurex
lurid	6	46	1897	3	lurid
lurk	8	66	2416	3	lu_rk
lurks	9	52	1874	3	lurks
lush	7	53	2769	3	lu_sh
lust	4	74	4260	3	lu_st
lustra	6	35	889	3	lustra
lusts	5	50	2280	3	lusts
lusty	8	54	1757	3	lusty
lusus	5	48	1387	3	lusus
lute	4	63	4101	3	lu_te
luteal	6	44	1148	3	luteal
luted	6	48	2614	3	luted
lutes	5	58	3666	3	lutes
lutz	13	68	2632	3	lu_tz
luv	6	71	2577	3	lu__v
luvs	7	58	1850	3	lu_vs
lux	10	65	2877	3	lu__x
luxe	11	52	2269	3	lu_xe
luxes	12	49	2150	3	luxes
lycea	10	41	894	3	lycea
lycra	10	31	797	3	lycra
lyssa	8	3	571	3	lyssa
lytta	8	8	806	3	lytta
maffia	14	32	720	3	maffia
mafia	10	44	1803	3	mafia
miff	12	56	2506	3	miff_
miffs	13	45	1288	3	miffs
miffy	16	39	1020	3	miffy
mudra	8	39	1243	3	mudra
muffed	15	42	1059	3	muffed
muffin	14	29	887	3	muffin
muffle	14	33	964	3	muffle
mufti	10	6	1054	3	mufti
mulla	7	43	1711	3	mulla
mura	6	56	3329	3	mu_ra
murra	7	45	1908	3	murra
musca	9	3	1176	3	musca
naff	10	51	2893	3	naff_
naffs	11	62	1396	3	naffs
nakfa	12	3	609	3	nakfa
nubia	7	3	1123	3	nubia
nucha	10	22	979	3	nucha
off	9	63	3163	3	_off_
offal	11	3	624	3	_offal
offs	10	71	1701	3	_offs
pfft	12	3	1188	3	_pfft
pouff	13	52	1542	3	pouff_
pouffe	14	44	826	3	pouffe
pouffs	14	41	812	3	pouffs
pouffy	17	39	588	3	pouffy
pucka	13	34	1280	3	pucka
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
puffin	14	114	900	3	puffin
puja	13	57	1492	3	pu_ja
pukka	10	45	713	3	pukka
pula	6	51	2937	3	pu_la
puma	8	54	2412	3	pu_ma
puna	6	53	3165	3	pu_na
punka	11	45	1548	3	punka
pupa	8	54	2281	3	pu_pa
purda	8	29	1469	3	purda
qua	12	48	2197	3	qu__a
quaff	20	13	1135	3	quaff
quaffs	21	12	569	3	quaffs
quiff	20	11	1156	3	quiff
quiffs	21	13	543	3	quiffs
quota	14	51	1196	3	quota
raff	10	49	3304	3	raff_
raffia	12	28	770	3	raffia
raffs	11	50	1752	3	raffs
riff	10	44	3010	3	riff_
riffs	11	51	1461	3	riffs
ruana	5	3	1242	3	ruana
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
ruffian	13	4	413	3	ruffian
ruffle	12	41	1167	3	ruffle
ruffly	15	33	667	3	ruffly
ruga	5	61	2123	3	ru_ga
rumba	9	36	1251	3	rumba
scuff	13	39	1489	3	scuff_
scuffs	14	41	905	3	scuffs
sluffed	14	30	830	3	sluffed
snuff	11	35	1404	3	snuff_
snuffs	12	35	852	3	snuffs
snuffy	15	35	624	3	snuffy
sofa	7	56	2560	3	_sofa
softa	8	64	1518	3	softa
stuff	11	38	1705	3	stuff_
stuffs	12	38	1022	3	stuffs
stuffy	15	31	708	3	stuffy
suba	6	49	2660	3	su_ba
suffari	13	4	550	3	suffari
suffer	12	43	1451	3	suffer
suffix	19	3	523	3	suffix
sulfas	9	3	1156	3	sulfas
sulfo	8	3	1336	3	sulfo
summa	9	47	1331	3	summa
sunna	5	50	1606	3	sunna
supra	7	36	1425	3	supra
sura	4	57	4029	3	su_ra
surf	7	60	3931	3	surf_
surfs	8	50	2254	3	surfs
surfy	11	53	1947	3	surfy
surra	5	55	2134	3	surra
sutra	5	42	1793	3	sutra
sutta	5	40	1533	3	sutta
taffia	12	28	690	3	taffia
taffy	14	51	1082	3	taffy
tafia	8	42	1549	3	tafia
teff	10	60	2376	3	teff_
teffs	11	51	1173	3	teffs
tiff	10	47	2772	3	tiff_
tiffs	11	44	1488	3	tiffs
toff	10	59	2990	3	toff_
toffs	11	60	1672	3	toffs
toffy	14	53	1028	3	toffy
truffe	12	7	623	3	truffe
tuba	6	54	2236	3	tu_ba
tufas	8	53	1438	3	tufas
tuffet	12	26	1208	3	tuffet
tuft	7	69	2951	3	tu_ft
tufts	8	57	1327	3	tufts
tufty	11	48	1041	3	tufty
tuna	4	51	2784	3	tu_na
turf	7	53	3405	3	turf_
turfs	8	46	2044	3	turfs
turfy	11	43	1540	3	turfy
ulama	7	7	1147	3	ulama
ulema	7	10	971	3	ulema
ulna	4	63	1732	3	_ulna
ultra	5	3	936	3	ultra
ulva	7	54	1269	3	_ulva
urea	4	65	2805	3	_urea
ursa	4	41	1690	3	_ursa
uta	3	74	2558	3	_u_ta
uvea	7	47	1265	3	_uvea
vulva	11	44	880	3	vulva
waff	13	42	2804	3	waff_
waffs	14	63	1547	3	waffs
yaff	13	53	2426	3	yaff_
yaffs	14	53	1112	3	yaffs
yuca	9	57	1672	3	yu_ca
yucca	12	46	744	3	yucca
yuga	8	56	1542	3	yu_ga
yurta	8	60	1425	3	yurta
zaffar	21	38	504	3	zaffar

Search took 5 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	83667	0.110	1624463.6
2	DLD Change Limit	83667	407	4.080	20506.6
3	Display Results	407	407	0.123	3308.9
	(SQL Overall)	178691	407	4.313	41430.8