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

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

303 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
waffler	16	37	778	(None)
baffler	15	41	811	1	baffler
raffler	13	33	922	1	raffler
waffle	15	36	918	1	waffle_
waffled	17	35	752	1	waffled
wafflers	17	30	632	1	wafflers
waffles	16	32	998	1	waffles
wafflier	17	3	395	1	wafflier
baffle	14	39	987	2	baffle_
baffled	16	41	806	2	baffled
bafflers	16	35	659	2	bafflers
baffles	15	37	1068	2	baffles
daffier	14	5	783	2	daffier
gaffer	13	43	1013	2	gaff_er
muffler	15	39	834	2	muffler
raffle	12	39	1070	2	raffle_
raffled	14	42	908	2	raffled
rafflers	14	31	736	2	rafflers
raffles	13	36	1184	2	raffles
riffler	13	32	835	2	riffler
ruffler	13	36	972	2	ruffler
wabbler	14	35	1192	2	wabbler
waddler	12	40	1079	2	waddler
wafer	11	44	1764	2	wa_f_er
waffed	16	45	979	2	waff_ed
waffie	15	33	856	2	waffie_
waffies	16	36	1144	2	waffies
waffly	18	30	543	2	waffl_y
wafter	12	41	1461	2	wa_fter
wailer	9	37	2032	2	wa_iler
waler	8	42	2926	2	wa__ler
wangler	11	33	1265	2	wangler
warbler	12	32	1146	2	warbler
warsler	10	28	989	2	warsler
whiffler	20	3	348	2	whiffler
zaffer	21	39	715	2	zaff_er
abler	7	56	2431	3	_a_bler
affair	12	3	435	3	_affair
affixer	20	3	391	3	_affixer
afflux	19	4	279	3	_afflux
after	8	57	1979	3	_a_fter
ambler	10	49	1645	3	_ambler
ampler	10	43	1330	3	_ampler
angler	7	40	1786	3	_angler
antler	6	46	1555	3	_antler
ashler	9	45	997	3	_ashler
awfuller	14	4	242	3	awfuller
babbler	10	40	1282	3	babbler
baffed	15	48	1217	3	baff_ed
baffies	15	36	1294	3	baffies
bailer	8	54	2525	3	ba_iler
baler	7	56	3527	3	ba__ler
baller	8	38	2520	3	ba_ller
battler	9	41	1338	3	battler
bawler	11	43	1505	3	ba_wler
buffer	14	45	1268	3	buff_er
buffier	15	6	840	3	buffier
cabler	10	45	1917	3	ca_bler
cackler	15	38	1257	3	cackler
cajoler	16	39	839	3	cajoler
caller	8	51	2548	3	ca_ller
candler	10	35	1659	3	candler
caroler	9	38	1675	3	caroler
caviler	12	4	906	3	caviler
chaffer	18	38	947	3	chaff_er
chaffier	19	3	547	3	chaffier
coffer	14	41	1286	3	coff_er
coffle	14	35	904	3	coffle_
coffled	16	29	736	3	coffled
coffles	15	26	1000	3	coffles
dabbler	12	40	1215	3	dabbler
daffed	14	42	949	3	daff_ed
dafter	10	48	1334	3	da_fter
dandler	9	44	1427	3	dandler
dangler	9	69	1281	3	dangler
dawdler	12	35	679	3	dawdler
dazzler	16	3	471	3	dazzler
deffer	13	44	1130	3	deff_er
defiler	11	39	1188	3	defiler
differ	13	39	1084	3	diff_er
doffer	13	39	1135	3	doff_er
draffier	15	7	432	3	draffier
duffer	13	47	1166	3	duff_er
duffle	13	36	853	3	duffle_
duffles	14	30	892	3	duffles
dwarfer	14	3	368	3	dwarf_er
fabler	11	61	1581	3	fa_bler
faller	9	46	2123	3	fa_ller
filer	8	54	3300	3	__filer
gabbler	12	40	1330	3	gabbler
gaffe	12	41	1165	3	gaff_e_
gaffed	14	42	1020	3	gaff_ed
gaffers	14	42	871	3	gaff_ers
gaffes	13	48	1110	3	gaff_es
gambler	12	36	1268	3	gambler
gaoler	7	39	1357	3	ga_oler
garbler	10	40	1256	3	garbler
gargler	9	37	1026	3	gargler
gauffer	14	7	442	3	gauffer
goffer	13	40	951	3	goff_er
hackler	16	35	1235	3	hackler
haffet	15	3	1170	3	haff_et
hafter	12	48	1588	3	ha_fter
haggler	12	32	893	3	haggler
hailer	9	47	2034	3	ha_iler
haler	8	50	3352	3	ha__ler
handler	11	35	1616	3	handler
hauler	9	50	1512	3	ha_uler
huffier	16	3	749	3	huffier
iffier	12	3	676	3	_iffier
jailer	13	43	1668	3	ja_iler
jangler	15	38	1183	3	jangler
kaffir	16	34	530	3	kaff_ir
labeler	9	23	1018	3	labeler
ladler	7	43	1493	3	la_dler
landler	8	41	1320	3	landler
mailer	8	47	2418	3	ma_iler
mangler	10	32	1564	3	mangler
marbler	11	35	1167	3	marbler
mauler	8	44	1671	3	ma_uler
miffier	15	3	702	3	miffier
muffle	14	33	964	3	muffle_
muffled	16	37	778	3	muffled
mufflers	16	31	600	3	mufflers
muffles	15	39	1045	3	muffles
naffed	13	40	833	3	naff_ed
nailer	6	41	1936	3	na_iler
niffer	12	37	844	3	niff_er
offer	11	43	1138	3	_off_er
paddler	11	37	1155	3	paddler
paler	7	54	3693	3	pa__ler
piaffer	15	10	444	3	piaff_er
piffle	14	41	823	3	piffle_
piffled	16	36	640	3	piffled
piffles	15	36	876	3	piffles
puffer	14	46	1073	3	puff_er
puffier	15	4	797	3	puffier
purfler	12	24	873	3	purfler
quaffer	22	3	513	3	quaff_er
rabbler	11	35	1409	3	rabbler
rafter	9	45	1758	3	ra_fter
railer	6	45	2493	3	ra_iler
rambler	11	33	1326	3	rambler
rattler	7	40	1274	3	rattler
raveler	10	42	1246	3	raveler
riffle	12	42	1023	3	riffle_
riffled	14	33	860	3	riffled
rifflers	14	33	644	3	rifflers
riffles	13	39	1116	3	riffles
rifler	9	40	1426	3	_rifler
ruffle	12	41	1167	3	ruffle_
ruffled	14	36	915	3	ruffled
rufflers	14	34	719	3	rufflers
ruffles	13	35	1227	3	ruffles
rufflier	14	3	401	3	rufflier
saddler	9	38	1196	3	saddler
safer	8	47	2181	3	sa_f_er
safflower	18	4	299	3	safflower
sailer	6	35	2610	3	sa_iler
sampler	11	32	1201	3	sampler
scuffler	16	28	670	3	scuffler
shuffler	17	30	680	3	shuffler
siffleur	14	4	183	3	siffleur
snaffle	13	21	625	3	snaffle_
snaffled	15	28	521	3	snaffled
snaffles	14	24	604	3	snaffles
sniffler	14	29	683	3	sniffler
snuffler	14	31	741	3	snuffler
staffer	13	29	909	3	staff_er
stifler	10	29	1147	3	stifler
suffer	12	43	1451	3	suff_er
tackler	13	40	1332	3	tackler
taffies	13	30	1269	3	taffies
tailer	6	38	2373	3	ta_iler
taler	5	60	3486	3	ta__ler
taller	6	37	2196	3	ta_ller
tangler	8	35	1508	3	tangler
tattler	7	31	1221	3	tattler
trifler	10	39	1215	3	trifler
twaddler	13	31	464	3	twaddler
twangler	12	4	411	3	twangler
wabble	13	37	1484	3	wabble_
wabbled	15	33	1144	3	wabbled
wabblers	15	39	899	3	wabblers
wabbles	14	40	1399	3	wabbles
wabblier	15	37	549	3	wabblier
wacker	15	49	2012	3	wa_cker
wackier	16	36	973	3	wackier
wadder	11	42	1548	3	wa_dder
waddle	11	47	1530	3	waddle_
waddled	13	36	1164	3	waddled
waddlers	13	29	833	3	waddlers
waddles	12	43	1484	3	waddles
wader	9	53	2536	3	wa__der
wafered	14	28	843	3	wafered
wafers	12	43	1614	3	wa_f_ers
wafery	15	39	869	3	wa_f_ery
waff	13	42	2804	3	waff___
waffing	17	37	1024	3	waffing
waffliest	18	4	423	3	waffliest
waffling	18	4	542	3	waffling
waffs	14	63	1547	3	waff__s
wafted	13	40	1214	3	wa_fted
wafters	13	41	1281	3	wa_fters
wafture	13	3	485	3	wafture
wager	9	59	2505	3	wa__ger
wagerer	11	32	849	3	wagerer
wagger	11	36	1601	3	wa_gger
waggle	11	36	1230	3	waggle_
waggled	13	38	936	3	waggled
waggles	12	38	1200	3	waggles
wagglier	13	4	432	3	wagglier
wagoner	11	3	609	3	wagoner
waifed	13	40	1103	3	waif_ed
wailed	10	48	2359	3	wa_iled
wailers	10	39	1680	3	wa_ilers
waister	10	38	1238	3	waister
waiter	9	43	2125	3	wa_iter
waiver	12	42	1271	3	wa_iver
wakener	14	4	691	3	wakener
waker	12	55	2659	3	wa__ker
wale	7	45	4643	3	wa__le_
waled	9	43	3099	3	wa__led
walers	9	48	2446	3	wa__lers
wales	8	61	4283	3	wa__les
walker	13	39	1399	3	wa_lker
walled	10	40	2129	3	wa_lled
wallet	9	33	2709	3	wa_llet
waltzer	19	3	438	3	waltzer
wamble	13	44	1575	3	wamble_
wambled	15	36	1075	3	wambled
wambles	14	37	1402	3	wambles
wamblier	15	27	573	3	wamblier
wander	10	44	2371	3	wa_nder
wandle	10	53	1666	3	wandle_
wangle	10	38	1751	3	wangle_
wangled	12	33	1241	3	wangled
wanglers	12	33	1003	3	wanglers
wangles	11	34	1693	3	wangles
wanier	9	39	2068	3	wa_nier
wanker	13	42	1997	3	wa_nker
wanner	9	40	1962	3	wa_nner
wanter	9	44	2305	3	wa_nter
warble	11	35	1660	3	warble_
warbled	13	32	1216	3	warbled
warblers	13	31	910	3	warblers
warbles	12	32	1556	3	warbles
warder	10	40	2027	3	wa_rder
warfare	13	3	673	3	warfare
warier	9	37	2289	3	wa_rier
warmer	11	38	1673	3	wa_rmer
warner	9	37	1722	3	wa_rner
warper	11	40	1558	3	wa_rper
warsle	9	31	1292	3	warsle_
warsled	11	29	1044	3	warsled
warslers	11	32	807	3	warslers
warsles	10	34	1364	3	warsles
warstler	11	27	593	3	warstler
wartier	10	34	1391	3	wartier
washer	12	47	2039	3	wa_sher
washier	13	36	1115	3	washier
waspier	12	25	905	3	waspier
waster	9	52	2894	3	wa_ster
watcher	15	31	1340	3	watcher
water	8	47	3331	3	wa__ter
waterer	10	33	1408	3	waterer
watter	9	32	2198	3	wa_tter
wattle	9	43	1421	3	wattle_
wattled	11	36	1050	3	wattled
wattles	10	38	1407	3	wattles
wauled	10	47	1396	3	wa_uled
wavelet	13	3	1094	3	wavelet
waver	11	50	2570	3	wa__ver
waverer	13	31	952	3	waverer
wavier	12	46	1308	3	wa_vier
wawled	13	38	1170	3	wa_wled
waxer	15	43	1748	3	wa__xer
waxier	16	43	990	3	wa_xier
wayfarer	17	4	292	3	wayfarer
whaler	12	46	1197	3	w_haler
wheeler	13	29	878	3	wheeler
whiffer	19	10	532	3	whiffer
whiffle	19	3	353	3	whiffle_
whiffled	21	3	304	3	whiffled
whifflers	21	4	277	3	whifflers
whiffles	20	3	426	3	whiffles
whirler	13	30	760	3	whirler
wifelier	14	3	485	3	wifelier
wiftier	13	29	773	3	wiftier
wiggler	12	31	1076	3	wiggler
willer	9	40	2106	3	w_iller
wobbler	14	32	982	3	wobbler
wofuller	14	4	240	3	wofuller
wolfer	12	42	998	3	wolf_er
woofer	12	44	1136	3	woof_er
wooler	9	36	1587	3	w_ooler
wrangler	12	4	547	3	wrangler
yaffed	16	45	732	3	yaff_ed
zaffar	21	38	504	3	zaff_ar
zaffers	22	38	677	3	zaff_ers
zaffir	21	39	551	3	zaff_ir
zaffre	21	35	466	3	zaffre_
zaffres	22	32	499	3	zaffres

Search took 7 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.406	440125.6
2	DLD Change Limit	134027	303	5.703	23501.1
3	Display Results	303	303	0.110	2754.5
	(SQL Overall)	178691	303	6.219	28733.1