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

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

410 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
buffo	13	51	1218	(None)
boffo	13	60	1037	1	boffo
buff	12	52	2986	1	buff_
buffi	13	61	1220	1	buffi
buffos	14	44	785	1	buffos
buffs	13	55	1951	1	buffs
buffy	16	50	1337	1	buffy
baff	12	46	3227	2	baff_
baffs	13	47	1805	2	baffs
baffy	16	55	1192	2	baffy
biff	12	50	2689	2	biff_
biffs	13	48	1441	2	biffs
biffy	16	47	1113	2	biffy
bluff	13	44	1383	2	bluff_
bluffs	14	38	837	2	bluffs
boff	12	47	2733	2	boff_
boffos	14	56	819	2	boffos
boffs	13	49	1550	2	boffs
bouffe	14	43	831	2	bouffe
bubo	8	56	2191	2	bu_bo
bucko	13	46	1402	2	bucko
buffalo	15	5	372	2	buffalo
buffed	15	43	1314	2	buffed
buffer	14	45	1268	2	buffer
buffet	14	31	1378	2	buffet
buffoon	15	4	371	2	buffoon
bumf	11	61	2651	2	bumf_
bumfs	12	54	1405	2	bumfs
bunco	9	46	1608	2	bunco
bunko	11	55	1451	2	bunko
burro	7	50	1849	2	burro
buteo	7	54	1989	2	buteo
cuff	12	53	2799	2	cuff_
cuffs	13	50	1749	2	cuffs
duff	11	43	2664	2	duff_
duffs	12	52	1662	2	duffs
guff	11	46	2493	2	guff_
guffs	12	44	1482	2	guffs
huff	13	56	2384	2	huff_
huffs	14	45	1474	2	huffs
huffy	17	48	1023	2	huffy
luff	10	44	2670	2	luff_
luffa	11	40	902	2	luffa
luffs	11	45	1628	2	luffs
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
sulfo	8	3	1336	2	sulfo
tuff	10	45	2852	2	tuff_
tuffs	11	51	1826	2	tuffs
aff	9	55	3761	3	_aff_
audio	6	29	1710	3	audio
auto	4	74	3208	3	au_to
baboo	9	43	1950	3	baboo
baffed	15	48	1217	3	baffed
baffle	14	39	987	3	baffle
banco	9	40	1939	3	banco
banjo	14	38	1244	3	banjo
barf	9	58	4441	3	barf_
barfs	10	48	2600	3	barfs
basso	7	60	1728	3	basso
bazoo	16	38	1567	3	bazoo
beano	7	54	2155	3	beano
beef	9	62	3368	3	beef_
beefs	10	56	1856	3	beefs
beefy	13	53	1383	3	beefy
befit	10	52	2266	3	befit
befog	11	5	901	3	befog
befool	11	3	771	3	befool
bento	7	59	2295	3	bento
biffed	15	44	988	3	biffed
biffin	14	36	910	3	biffin
bifid	11	9	1070	3	bifid
bilbo	9	55	1361	3	bilbo
bimbo	11	48	1187	3	bimbo
bingo	8	60	2009	3	bingo
bio	5	78	4608	3	b__io
biro	6	61	3121	3	b_iro
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
bo	4	109	5757	3	b___o
boffed	15	36	948	3	boffed
boffin	14	35	905	3	boffin
boffola	15	4	346	3	boffola
boho	9	69	2332	3	b_oho
bolo	6	55	3595	3	b_olo
bongo	8	57	2094	3	bongo
boo	5	81	6366	3	b__oo
bouffes	15	38	863	3	bouffes
boyo	9	69	2384	3	b_oyo
bozo	15	68	2141	3	b_ozo
bravo	10	52	1434	3	bravo
brio	6	54	3249	3	b_rio
bro	5	62	3660	3	b__ro
bromo	9	52	1720	3	bromo
broo	6	51	2982	3	b_roo
bub	7	63	4398	3	bu__b
bubal	9	42	1821	3	bubal
bubba	8	43	1180	3	bubba
bubby	11	50	1393	3	bubby
bubs	8	62	3550	3	bu_bs
bubu	8	50	2267	3	bu_bu
bubus	9	51	1545	3	bubus
buck	12	51	2990	3	bu_ck
buckos	14	37	1089	3	buckos
bucks	13	48	2429	3	bucks
bud	6	70	4127	3	bu__d
buddy	12	48	1263	3	buddy
budge	9	46	1988	3	budge
buds	7	52	3517	3	bu_ds
buffalos	16	4	286	3	buffalos
buffers	15	33	1079	3	buffers
buffest	15	29	864	3	buffest
buffets	15	31	759	3	buffets
buffier	15	6	840	3	buffier
buffing	16	34	1139	3	buffing
buffoons	16	4	309	3	buffoons
bug	6	53	4074	3	bu__g
buggy	12	46	1348	3	buggy
bugle	8	47	2194	3	bugle
bugs	7	60	3591	3	bu_gs
buhl	9	55	1822	3	bu_hl
buhls	10	51	1180	3	buhls
buhr	9	53	1538	3	bu_hr
buhrs	10	48	1124	3	buhrs
build	8	44	1335	3	build
built	7	43	2592	3	built
bulb	8	56	2669	3	bu_lb
bulbs	9	60	1693	3	bulbs
bulge	8	64	1987	3	bulge
bulgy	11	52	1410	3	bulgy
bulk	10	54	2615	3	bu_lk
bulks	11	59	2061	3	bulks
bulky	14	62	1557	3	bulky
bull	6	56	3487	3	bu_ll
bulla	7	46	2056	3	bulla
bulls	7	56	2957	3	bulls
bully	10	51	2481	3	bully
bum	7	53	4269	3	bu__m
bump	10	62	2824	3	bu_mp
bumph	14	49	1198	3	bumph
bumps	11	59	2114	3	bumps
bumpy	14	47	1505	3	bumpy
bums	8	59	3459	3	bu_ms
bun	5	63	4814	3	bu__n
buna	6	47	3072	3	bu_na
bunas	7	51	2657	3	bunas
bunch	12	51	1860	3	bunch
buncos	10	40	1159	3	buncos
bund	7	55	3066	3	bu_nd
bunds	8	55	2354	3	bunds
bundt	8	58	2485	3	bundt
bung	7	57	3063	3	bu_ng
bungs	8	53	2386	3	bungs
bunion	8	31	1131	3	bunion
bunk	10	57	3135	3	bu_nk
bunkos	12	42	1032	3	bunkos
bunks	11	51	2508	3	bunks
bunn	6	50	2365	3	bu_nn
bunns	7	47	1829	3	bunns
bunny	10	47	1580	3	bunny
buns	6	62	4372	3	bu_ns
bunt	6	58	5085	3	bu_nt
bunts	7	57	2980	3	bunts
bunya	10	38	1009	3	bunya
buoy	9	59	2178	3	bu_oy
buoys	10	48	1063	3	buoys
buppy	14	48	1007	3	buppy
bur	5	57	4469	3	bu__r
bura	6	61	3953	3	bu_ra
buran	7	52	2530	3	buran
buras	7	47	3630	3	buras
burb	8	53	3467	3	bu_rb
burbot	10	8	1565	3	burbot
burbs	9	54	2349	3	burbs
burd	7	55	3426	3	bu_rd
burds	8	46	2606	3	burds
buret	7	74	4401	3	buret
burg	7	49	3036	3	bu_rg
burgh	11	52	1603	3	burgh
burgoo	9	3	893	3	burgoo
burgs	8	49	2409	3	burgs
burin	7	56	2606	3	burin
burka	11	46	1769	3	burka
burke	11	51	2276	3	burke
burl	6	49	3718	3	bu_rl
burls	7	42	2885	3	burls
burly	10	49	2283	3	burly
burn	6	56	3642	3	bu_rn
burns	7	49	2677	3	burns
burnt	7	52	3032	3	burnt
burp	8	50	2888	3	bu_rp
burps	9	42	2017	3	burps
burqa	16	50	1309	3	burqa
burr	6	56	3123	3	bu_rr
burros	8	51	1499	3	burros
burrow	11	46	1080	3	burrow
burrs	7	49	2565	3	burrs
burry	10	52	2156	3	burry
burs	6	58	4742	3	bu_rs
bursa	7	49	2152	3	bursa
burse	7	55	2725	3	burse
burst	7	53	3224	3	burst
burton	8	3	1127	3	burton
bury	9	56	3359	3	bu_ry
bus	5	69	5097	3	bu__s
busboy	13	30	744	3	busboy
busby	12	61	1329	3	busby
bused	8	56	2449	3	bused
buses	7	59	3601	3	buses
bush	9	66	3071	3	bu_sh
bushy	13	54	1668	3	bushy
busk	10	54	2922	3	bu_sk
busks	11	55	2137	3	busks
buss	6	51	3491	3	bu_ss
bust	6	59	4778	3	bu_st
busts	7	52	2769	3	busts
busty	10	56	2101	3	busty
busy	9	47	2717	3	bu_sy
but	5	59	6302	3	bu__t
butch	12	54	1654	3	butch
bute	6	67	3967	3	bu_te
buteos	8	49	1341	3	buteos
butes	7	145	3587	3	butes
butle	7	50	2310	3	butle
buts	6	72	4769	3	bu_ts
butt	6	51	4374	3	bu_tt
butte	7	49	2429	3	butte
button	8	3	1027	3	button
butts	7	58	2425	3	butts
butty	10	40	2011	3	butty
butut	7	55	2291	3	butut
butyl	10	8	910	3	butyl
buxom	16	4	715	3	buxom
buy	8	64	3654	3	bu__y
buyer	10	50	1309	3	buyer
buyoff	17	5	423	3	buyoff
buyoffs	18	4	243	3	buyoffs
buys	9	57	2679	3	bu_ys
buzz	14	66	1780	3	bu_zz
caff	12	56	3167	3	caff_
caffs	13	54	1737	3	caffs
chuff	16	48	1249	3	chuff_
chuffs	17	42	778	3	chuffs
chuffy	20	44	586	3	chuffy
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
curf	9	75	3878	3	curf_
curfs	10	51	2214	3	curfs
curio	7	42	2121	3	curio
cusso	7	49	1229	3	cusso
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
dumbo	10	56	1406	3	dumbo
duo	4	85	3614	3	du__o
duomo	8	3	975	3	duomo
duro	5	62	2802	3	du_ro
eff	9	61	2862	3	_eff_
effs	10	51	1403	3	_effs
euro	4	53	2527	3	eu_ro
fluff	10	39	1361	3	fluff_
fluffs	11	34	778	3	fluffs
fluffy	14	31	578	3	fluffy
fro	6	55	3064	3	__fro
fugio	9	3	1092	3	fugio
fungo	9	44	1313	3	fungo
gaff	11	48	2815	3	gaff_
gaffe	12	41	1165	3	gaffe
gaffs	12	49	1465	3	gaffs
gruff	12	47	1214	3	gruff_
gruffs	13	33	745	3	gruffs
gruffy	16	39	601	3	gruffy
guaco	8	50	1216	3	guaco
guano	6	92	1398	3	guano
guffaw	16	4	279	3	guffaw
guiro	6	37	1209	3	guiro
gulf	8	49	2942	3	gulf_
gulfs	9	49	1530	3	gulfs
gulfy	12	46	1200	3	gulfy
gumbo	10	44	1358	3	gumbo
gusto	6	54	1464	3	gusto
huffed	16	37	1015	3	huffed
hullo	8	44	1745	3	hullo
iff	9	67	3039	3	_iff_
iffy	13	53	1228	3	_iffy
info	7	56	1735	3	_info
jiff	17	53	2141	3	jiff_
jiffs	18	57	1031	3	jiffs
jiffy	21	45	831	3	jiffy
juco	13	47	1620	3	ju_co
judo	12	53	1530	3	ju_do
jumbo	16	43	1107	3	jumbo
junco	14	46	1220	3	junco
junto	12	51	1456	3	junto
kudo	9	61	1510	3	ku_do
kufi	11	9	1065	3	ku_fi
kufis	12	4	925	3	kufis
kusso	9	39	803	3	kusso
luffas	12	33	748	3	luffas
luffed	13	38	1082	3	luffed
miff	12	56	2506	3	miff_
miffs	13	45	1288	3	miffs
miffy	16	39	1020	3	miffy
mucho	12	50	1344	3	mucho
mucro	9	45	1372	3	mucro
muffed	15	42	1059	3	muffed
muffin	14	29	887	3	muffin
muffle	14	33	964	3	muffle
mufti	10	6	1054	3	mufti
mungo	8	49	1605	3	mungo
naff	10	51	2893	3	naff_
naffs	11	62	1396	3	naffs
off	9	63	3163	3	_off_
offs	10	71	1701	3	_offs
outdo	6	3	1270	3	outdo
outfox	16	3	614	3	outfox
outgo	6	3	1209	3	outgo
ouzo	13	35	1693	3	ou_zo
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
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
puffin	14	114	900	3	puffin
punto	7	51	2132	3	punto
putto	7	56	1766	3	putto
quaff	20	13	1135	3	quaff
quaffs	21	12	569	3	quaffs
quiff	20	11	1156	3	quiff
quiffs	21	13	543	3	quiffs
raff	10	49	3304	3	raff_
raffs	11	50	1752	3	raffs
rebuff	14	3	702	3	rebuff_
rebuffs	15	3	340	3	rebuffs
riff	10	44	3010	3	riff_
riffs	11	51	1461	3	riffs
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
ruffle	12	41	1167	3	ruffle
ruffly	15	33	667	3	ruffly
scuff	13	39	1489	3	scuff_
scuffs	14	41	905	3	scuffs
sluff	11	40	1681	3	sluff_
sluffs	12	34	958	3	sluffs
snuff	11	35	1404	3	snuff_
snuffs	12	35	853	3	snuffs
snuffy	15	35	624	3	snuffy
stuff	11	38	1705	3	stuff_
stuffs	12	38	1022	3	stuffs
stuffy	15	31	708	3	stuffy
suffer	12	43	1451	3	suffer
suffix	19	3	523	3	suffix
sulfa	8	3	1392	3	sulfa
sumo	6	73	2631	3	su_mo
surf	7	60	3931	3	surf_
surfs	8	50	2254	3	surfs
surfy	11	53	1947	3	surfy
taffy	14	51	1082	3	taffy
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
tufa	7	50	1661	3	tu_fa
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
turbo	7	10	1504	3	turbo
turf	7	53	3405	3	turf_
turfs	8	46	2044	3	turfs
turfy	11	43	1540	3	turfy
udo	4	90	2730	3	_u_do
umbo	8	55	1666	3	_umbo
unco	6	60	2140	3	_unco
undo	5	56	2015	3	_undo
unto	4	58	2428	3	_unto
updo	7	67	1288	3	_updo
upo	5	89	2586	3	_u_po
vulgo	9	3	695	3	vulgo
waff	13	42	2804	3	waff_
waffs	14	63	1547	3	waffs
yaff	13	53	2426	3	yaff_
yaffs	14	53	1112	3	yaffs

Search took 4 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.343	520965.0
2	DLD Change Limit	83667	410	3.236	25855.1
3	Display Results	410	410	0.110	3727.3
	(SQL Overall)	178691	410	3.689	48438.9