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

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

224 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
buffest	15	29	863	(None)
bluffest	16	6	463	1	bluffest
buffet	14	31	1378	1	buffe_t
buffets	15	31	759	1	buffets
buffiest	16	5	755	1	buffiest
bouffes	15	38	863	2	bouffes_
buffed	15	43	1314	2	buffe_d
buffer	14	45	1268	2	buffe_r
buffers	15	33	1079	2	buffers
buffos	14	44	785	2	buffos_
buffs	13	55	1951	2	buff_s_
bummest	13	29	862	2	bummest
busiest	9	37	1630	2	busiest
chuffest	19	4	418	2	chuffest
deffest	14	30	880	2	deffest
funfest	13	34	808	2	funfest
gruffest	15	4	458	2	gruffest
huffiest	17	5	719	2	huffiest
puffiest	16	4	731	2	puffiest
ruffes	12	41	1242	2	ruffes_
tuffet	12	26	1208	2	tuffe_t
tuffets	13	26	652	2	tuffets
affect	14	4	890	3	_affect
auldest	8	3	989	3	auldest
babiest	11	44	1475	3	babiest
baddest	11	26	1114	3	baddest
baffed	15	48	1217	3	baffe_d
baffies	15	36	1294	3	baffies_
baffles	15	37	1068	3	baffles_
baffs	13	47	1805	3	baff_s_
baldest	10	23	1353	3	baldest
barest	8	53	2769	3	b_arest
basest	8	47	2049	3	b_asest
bedfast	13	4	641	3	bedfast
beefiest	13	26	901	3	beefiest
befret	11	3	1596	3	befre_t
befrets	12	3	761	3	befrets
behest	11	3	1461	3	b_ehest
bequest	18	3	782	3	bequest
best	6	63	5532	3	b___est
biffed	15	44	988	3	biffe_d
biffies	15	27	1085	3	biffies_
biffs	13	48	1440	3	biff_s_
bigfeet	13	7	615	3	bigfeet
biggest	11	3	814	3	biggest
blest	7	64	3172	3	b__lest
bluest	8	40	1648	3	b_luest
bluffed	16	32	643	3	bluffe_d
bluffer	15	39	688	3	bluffe_r
bluffers	16	40	570	3	bluffers
bluffness	17	4	250	3	bluffness
bluffs	14	38	837	3	bluff_s_
bluntest	10	3	655	3	bluntest
boffed	15	36	948	3	boffe_d
boffos	14	56	819	3	boffos_
boffs	13	49	1550	3	boff_s_
boldest	10	26	1306	3	boldest
boniest	9	33	1899	3	boniest
bouffant	16	4	368	3	bouffant
bouffe	14	43	831	3	bouffe__
boxiest	16	37	1198	3	boxiest
bravest	12	42	1175	3	bravest
brawest	12	38	1048	3	brawest
briefest	13	3	589	3	briefest
bruskest	14	31	590	3	bruskest
bubkes	14	46	1262	3	bubkes_
buboes	10	45	1399	3	buboes_
bucket	14	46	2073	3	bucke_t
buckets	15	38	1169	3	buckets
budges	10	48	2012	3	budges_
budget	10	46	1811	3	budge_t
budgets	11	48	986	3	budgets
budless	10	3	887	3	budless
buff	12	52	2985	3	buff___
buffalo	15	5	372	3	buffalo
buffered	17	6	499	3	buffered
buffeted	17	5	373	3	buffeted
buffeter	16	8	359	3	buffeter
buffi	13	61	1220	3	buff__i
buffier	15	6	840	3	buffier
buffing	16	34	1139	3	buffing
buffo	13	51	1218	3	buff__o
buffoon	15	4	371	3	buffoon
buffy	16	50	1337	3	buff__y
buggiest	12	34	1036	3	buggiest
bugles	9	48	2244	3	bugles_
bulges	9	59	1932	3	bulges_
bulgiest	11	29	1094	3	bulgiest
bulkiest	14	35	1126	3	bulkiest
bullet	8	45	2861	3	bulle_t
bullets	9	35	1639	3	bullets
bulliest	10	43	1449	3	bulliest
bumfs	12	54	1405	3	bumf_s_
bumpiest	14	3	787	3	bumpiest
bundist	10	3	1019	3	bundist
bupkes	14	48	1148	3	bupkes_
buret	7	74	4401	3	bu_re_t
burets	8	43	2126	3	bu_rets
burgess	10	40	934	3	burgess
buries	8	46	3327	3	buries_
burkes	12	44	2131	3	burkes_
burlesk	13	3	546	3	burlesk
burliest	10	31	1305	3	burliest
burnet	8	43	2617	3	burne_t
burnets	9	38	1326	3	burnets
burriest	10	29	1121	3	burriest
burses	8	44	2551	3	burses_
burst	7	53	3224	3	bu__rst
buses	7	59	3601	3	bu_ses_
bushes	11	52	2611	3	bushes_
bushiest	13	35	1252	3	bushiest
busies	8	55	2526	3	busies_
busses	8	50	2338	3	busses_
bust	6	59	4778	3	bu___st
bustiest	10	28	1505	3	bustiest
butes	7	145	3587	3	bu_tes_
butles	8	44	2391	3	butles_
buttes	8	48	2256	3	buttes_
buxomest	19	4	218	3	buxomest
buzzes	16	50	1117	3	buzzes_
chuffiest	20	4	439	3	chuffiest
cuffed	15	43	1121	3	cuffe_d
cuffless	16	3	428	3	cuffless
cuffs	13	50	1749	3	cuff_s_
curtest	9	7	1396	3	curtest
cutest	8	58	2014	3	cu_test
daffiest	15	3	783	3	daffiest
daftest	11	24	894	3	daftest
deafest	11	29	1151	3	deafest
deftest	11	26	1171	3	deftest
duffel	13	40	775	3	duffe_l
duffels	14	29	645	3	duffels
duffer	13	47	1166	3	duffe_r
duffers	14	34	1009	3	duffers
duffles	14	30	891	3	duffles_
duffs	12	52	1662	3	duff_s_
dullest	8	3	1263	3	dullest
dumbest	12	3	874	3	dumbest
dunnest	8	33	1226	3	dunnest
effect	14	3	744	3	_effect
fest	7	49	4944	3	___fest
fluffiest	14	3	408	3	fluffiest
fullest	10	3	1334	3	fullest
fumiest	12	3	1219	3	fumiest
funest	9	43	1686	3	fu_nest
funfests	14	25	356	3	funfests
funnest	10	29	1200	3	funnest
gabfest	13	3	645	3	gabfest
gaffes	13	48	1110	3	gaffes_
gruffiest	16	3	452	3	gruffiest
guest	6	52	2592	3	gu__est
guffs	12	44	1482	3	guff_s_
gulfiest	12	4	794	3	gulfiest
haffet	15	3	1170	3	haffe_t
haffets	16	3	605	3	haffets
huffed	16	37	1015	3	huffe_d
huffish	19	3	571	3	huffish
huffs	14	45	1474	3	huff_s_
hugest	10	3	1176	3	hu_gest
iffiest	13	3	795	3	iffiest
infest	9	33	1543	3	_infest
justest	14	4	989	3	justest
leftest	10	26	946	3	leftest
liefest	10	3	844	3	liefest
luffas	12	33	748	3	luffas_
luffed	13	38	1082	3	luffe_d
luffs	11	45	1628	3	luff_s_
luniest	7	35	1699	3	luniest
lushest	10	33	1228	3	lushest
miffiest	16	3	712	3	miffiest
muffed	15	42	1059	3	muffe_d
muffles	15	39	1044	3	muffles_
muffs	13	41	1421	3	muff_s_
murkest	13	31	1020	3	murkest
mutest	8	42	1805	3	mu_test
nudest	7	41	1383	3	nu_dest
numbest	11	3	879	3	numbest
offset	12	3	837	3	_offset
oftest	9	12	1200	3	_oftest
outfast	10	14	1212	3	outfast
outfeast	11	10	750	3	outfeast
outfelt	10	3	1060	3	outfelt
pouffes	15	40	812	3	pouffes_
puffed	15	35	1060	3	puffe_d
puffer	14	46	1073	3	puffe_r
puffers	15	34	920	3	puffers
puffery	18	23	511	3	puffery
puffs	13	41	1493	3	puff_s_
puniest	9	29	1809	3	puniest
punkest	13	26	1169	3	punkest
purest	8	40	2193	3	pu_rest
quest	14	41	2132	3	qu__est
rifest	9	31	1458	3	_rifest
rubiest	9	29	1442	3	rubiest
rudest	7	40	1631	3	ru_dest
ruffe	11	47	1381	3	ruffe__
ruffed	13	43	1274	3	ruffe_d
ruffles	13	35	1226	3	ruffles_
ruffliest	15	5	448	3	ruffliest
ruffs	11	45	1674	3	ruff_s_
ruliest	7	28	1642	3	ruliest
rummest	11	27	983	3	rummest
safest	9	50	1660	3	_safest
slugfest	12	4	491	3	slugfest
snuffiest	15	24	604	3	snuffiest
softest	10	3	1060	3	softest
stiffest	14	3	567	3	stiffest
stuffiest	15	23	594	3	stuffiest
suavest	10	3	1062	3	suavest
subtest	9	5	1396	3	subtest
suffer	12	43	1451	3	suffe_r
suffers	13	31	1354	3	suffers
suffuse	13	3	544	3	suffuse
suggest	9	3	1086	3	suggest
sunfast	10	3	850	3	sunfast
surest	6	50	2676	3	su_rest
surfeit	10	3	1034	3	surfeit
surfiest	11	24	1442	3	surfiest
truffes	13	5	677	3	truffes_
tuffs	11	51	1826	3	tuff_s_
tuftiest	11	3	827	3	tuftiest
turfiest	11	24	1012	3	turfiest
unfelt	9	24	1346	3	_unfelt
unrest	6	29	1885	3	_unrest

Search took 10 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	224	8.796	15237.3
3	Display Results	224	224	0.080	2800.0
	(SQL Overall)	178691	224	9.032	19784.2