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

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

228 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
bafflers	16	35	659	(None)
baffler	15	41	811	1	baffler_
baffles	15	37	1068	1	baffle_s
rafflers	14	31	736	1	rafflers
wafflers	17	30	632	1	wafflers
babblers	11	35	1035	2	babblers
baffies	15	36	1294	2	baffie_s
baffle	14	39	987	2	baffle__
baffled	16	41	806	2	baffle_d
bailers	9	42	2135	2	ba_ilers
balers	8	56	2693	2	ba__lers
ballers	9	44	2101	2	ba_llers
battlers	10	41	1097	2	battlers
bawlers	12	44	1273	2	ba_wlers
buffers	15	33	1079	2	buff_ers
gaffers	14	42	871	2	gaff_ers
mufflers	16	31	600	2	mufflers
raffler	13	33	922	2	raffler_
raffles	13	36	1184	2	raffle_s
rifflers	14	33	644	2	rifflers
rufflers	14	34	719	2	rufflers
waffler	16	37	778	2	waffler_
waffles	16	32	998	2	waffle_s
zaffers	22	38	677	2	zaff_ers
affairs	13	3	416	3	_affairs
affixers	21	4	329	3	_affixers
afters	9	47	1707	3	_a_fters
amblers	11	52	1356	3	_amblers
anglers	8	40	1482	3	_anglers
antlers	7	40	1474	3	_antlers
ashlers	10	31	958	3	_ashlers
babbler	10	40	1282	3	babbler_
babbles	10	44	1632	3	babble_s
backers	15	38	2189	3	ba_ckers
backless	16	29	1063	3	backless
badgers	11	48	1265	3	ba_dgers
baffed	15	48	1217	3	baff_e_d
bafflegab	20	8	79	3	bafflegab
bafflegabs	21	8	63	3	bafflegabs
baffling	17	5	605	3	baffling
baffs	13	47	1805	3	baff___s
baggers	11	39	1569	3	ba_ggers
bailees	9	39	1438	3	ba_ilees
bailer	8	54	2525	3	ba_iler_
baileys	12	38	893	3	ba_ileys
bailors	9	32	1241	3	ba_ilors
baiters	9	46	1931	3	ba_iters
bakers	12	53	2345	3	ba__kers
baler	7	56	3527	3	ba__ler_
bales	7	62	5008	3	ba__le_s
balkers	13	49	1572	3	ba_lkers
baller	8	38	2520	3	ba_ller_
ballets	9	37	1951	3	ba_llets
banders	10	43	2456	3	ba_nders
bangers	10	40	2035	3	ba_ngers
bangles	10	36	1741	3	bangle_s
bankers	13	39	1909	3	ba_nkers
banners	9	40	1871	3	ba_nners
banters	9	46	2312	3	ba_nters
barbers	11	43	1750	3	ba_rbers
barbless	12	31	871	3	barbless
barflies	13	3	830	3	barflies
barkers	13	43	1851	3	ba_rkers
barkless	14	31	802	3	barkless
barless	9	43	1700	3	ba_rless
barleys	12	50	1184	3	ba_rleys
barriers	10	43	1189	3	barriers
barters	9	42	2304	3	ba_rters
baseless	10	9	956	3	baseless
bashers	12	48	2083	3	ba_shers
basifiers	14	4	520	3	basifiers
basters	9	49	3031	3	ba_sters
batchers	15	36	1327	3	batchers
batfowlers	18	5	190	3	batfowlers
bathers	12	47	2036	3	ba_thers
bathless	13	12	738	3	bathless
batters	9	46	2602	3	ba_tters
battler	9	41	1338	3	battler_
battles	9	45	1768	3	battle_s
baubles	11	36	1186	3	bauble_s
bawler	11	43	1505	3	ba_wler_
beefless	13	3	549	3	beefless
beetlers	10	3	740	3	beetlers
befleas	12	3	697	3	b_efleas
befoulers	14	4	312	3	befoulers
bevelers	13	38	946	3	bevelers
biffies	15	27	1085	3	biffie_s
billers	9	47	2083	3	b_illers
birlers	9	38	1300	3	b_irlers
bluffers	16	40	570	3	bluffers
bogglers	12	34	760	3	bogglers
boilers	9	34	1706	3	b_oilers
boodlers	11	37	1074	3	boodlers
bottlers	10	38	1001	3	bottlers
bowlers	12	37	1578	3	b_owlers
brabblers	12	33	556	3	brabblers
braillers	11	3	555	3	braillers
brawlers	13	40	864	3	brawlers
bridlers	11	35	918	3	bridlers
broilers	10	32	1009	3	broilers
bubblers	11	44	894	3	bubblers
bucklers	16	34	950	3	bucklers
buffer	14	45	1268	3	buff_er_
buffeters	17	8	314	3	buffeters
buffets	15	31	759	3	buff_ets
buffier	15	6	840	3	buffier_
buglers	10	51	1532	3	b_uglers
bumblers	14	37	1073	3	bumblers
bundlers	11	39	918	3	bundlers
bunglers	11	39	848	3	bunglers
burblers	12	39	926	3	burblers
burlers	9	41	2027	3	b_urlers
bustlers	10	42	1062	3	bustlers
butlers	9	45	1805	3	b_utlers
cablers	11	44	1671	3	ca_blers
cacklers	16	37	1070	3	cacklers
cajolers	17	26	713	3	cajolers
callers	9	42	2196	3	ca_llers
candlers	11	42	1410	3	candlers
carolers	10	33	1417	3	carolers
cavilers	13	4	811	3	cavilers
chaffers	19	37	800	3	chaff_ers
coffers	15	41	1269	3	coff_ers
coffles	15	26	1000	3	coffle_s
cuffless	16	3	429	3	cuffless
dabblers	13	37	936	3	dabblers
daffier	14	5	783	3	daffier_
dandlers	10	39	1205	3	dandlers
danglers	10	36	1059	3	danglers
dawdlers	13	37	567	3	dawdlers
dazzlers	17	3	323	3	dazzlers
defilers	12	43	947	3	defilers
differs	14	33	997	3	diff_ers
doffers	14	35	985	3	doff_ers
duffers	14	34	1009	3	duff_ers
duffles	14	30	892	3	duffle_s
fablers	12	48	1261	3	fa_blers
fallers	10	39	1799	3	fa_llers
filers	9	46	2372	3	__filers
gabblers	13	41	1008	3	gabblers
gaffer	13	43	1013	3	gaff_er_
gaffes	13	48	1110	3	gaff_e_s
gamblers	13	36	973	3	gamblers
gaolers	8	35	1156	3	ga_olers
garblers	11	38	1028	3	garblers
garglers	10	41	826	3	garglers
gauffers	15	6	383	3	gauffers
goffers	14	40	921	3	goff_ers
hacklers	17	37	1030	3	hacklers
haffets	16	3	605	3	haff_ets
hafters	13	46	1433	3	ha_fters
hagglers	13	32	662	3	hagglers
hailers	10	40	1726	3	ha_ilers
halers	9	49	2691	3	ha__lers
handlers	12	40	1414	3	handlers
haulers	10	40	1244	3	ha_ulers
jailers	14	41	1404	3	ja_ilers
janglers	16	31	937	3	janglers
kaffirs	17	32	555	3	kaff_irs
labelers	10	24	941	3	labelers
ladlers	8	46	1357	3	la_dlers
landlers	9	43	1283	3	landlers
mailers	9	44	2033	3	ma_ilers
manglers	11	33	1190	3	manglers
marblers	12	31	923	3	marblers
maulers	9	42	1330	3	ma_ulers
muffler	15	39	834	3	muffler_
muffles	15	39	1045	3	muffle_s
nailers	7	32	1589	3	na_ilers
niffers	13	28	736	3	niff_ers
offers	12	34	996	3	_off_ers
paddlers	12	32	915	3	paddlers
piaffers	16	11	420	3	piaff_ers
piffles	15	36	876	3	piffle_s
puffers	15	34	920	3	puff_ers
purflers	13	21	696	3	purflers
quaffers	23	3	396	3	quaff_ers
rabblers	12	38	1085	3	rabblers
raffle	12	39	1070	3	raffle__
raffled	14	42	908	3	raffle_d
rafters	10	37	1563	3	ra_fters
railers	7	44	2066	3	ra_ilers
ramblers	12	40	1037	3	ramblers
rattlers	8	35	1029	3	rattlers
ravelers	11	33	1086	3	ravelers
riffler	13	32	835	3	riffler_
riffles	13	39	1116	3	riffle_s
riflers	10	35	1219	3	_riflers
ruffler	13	36	972	3	ruffler_
ruffles	13	35	1227	3	ruffle_s
saddlers	10	28	975	3	saddlers
safflowers	19	4	280	3	safflowers
sailers	7	38	2232	3	sa_ilers
samplers	12	29	940	3	samplers
scufflers	17	28	503	3	scufflers
shufflers	18	26	515	3	shufflers
siffleurs	15	4	164	3	siffleurs
snaffles	14	24	604	3	snaffle_s
snifflers	15	27	505	3	snifflers
snufflers	15	28	522	3	snufflers
staffers	14	24	708	3	staff_ers
stiflers	11	23	883	3	stiflers
suffers	13	31	1354	3	suff_ers
tacklers	14	30	1077	3	tacklers
taffies	13	30	1269	3	taffie_s
tailers	7	37	2018	3	ta_ilers
talers	6	46	2814	3	ta__lers
tanglers	9	29	1197	3	tanglers
tattlers	8	36	969	3	tattlers
triflers	11	31	1021	3	triflers
wabblers	15	39	899	3	wabblers
waddlers	13	29	833	3	waddlers
wafers	12	43	1614	3	wa_f_ers
waffies	16	36	1144	3	waffie_s
waffle	15	36	918	3	waffle__
waffled	17	35	752	3	waffle_d
wafflier	17	3	395	3	wafflier_
wafters	13	41	1281	3	wa_fters
wailers	10	39	1680	3	wa_ilers
walers	9	48	2446	3	wa__lers
wanglers	12	33	1003	3	wanglers
warblers	13	31	910	3	warblers
warslers	11	32	807	3	warslers
whifflers	21	4	277	3	whifflers
zaffars	22	32	523	3	zaff_ars
zaffer	21	39	715	3	zaff_er_
zaffirs	22	37	566	3	zaff_irs
zaffres	22	32	499	3	zaffre_s

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	146162	0.436	409841.7
2	DLD Change Limit	146162	228	7.720	18932.9
3	Display Results	228	228	0.093	2451.6
	(SQL Overall)	178691	228	8.249	21662.1