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

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

360 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
waffle	15	36	918	(None)
baffle	14	39	987	1	baffle
raffle	12	39	1070	1	raffle
waffie	15	33	856	1	waffie
waffled	17	35	752	1	waffled
waffler	16	37	778	1	waffler
waffles	16	32	998	1	waffles
waffly	18	30	543	1	waffly
baffled	16	41	806	2	baffled
baffler	15	41	811	2	baffler
baffles	15	37	1068	2	baffles
coffle	14	35	904	2	coffle
duffle	13	36	853	2	duffle
gaffe	12	41	1165	2	gaff_e
muffle	14	33	964	2	muffle
piffle	14	41	823	2	piffle
raffled	14	42	908	2	raffled
raffler	13	33	922	2	raffler
raffles	13	36	1184	2	raffles
riffle	12	42	1023	2	riffle
ruffle	12	41	1167	2	ruffle
snaffle	13	21	625	2	snaffle
wabble	13	37	1484	2	wabble
waddle	11	47	1530	2	waddle
waff	13	42	2804	2	waff__
waffed	16	45	979	2	waffed
waffies	16	36	1144	2	waffies
wafflers	17	30	632	2	wafflers
wafflier	17	3	395	2	wafflier
waffs	14	63	1547	2	waff_s
waggle	11	36	1230	2	waggle
wale	7	45	4643	2	wa__le
wamble	13	44	1575	2	wamble
wandle	10	53	1666	2	wandle
wangle	10	38	1751	2	wangle
warble	11	35	1660	2	warble
warsle	9	31	1292	2	warsle
wattle	9	43	1421	2	wattle
whiffle	19	3	353	2	whiffle
zaffre	21	35	466	2	zaffre
abele	7	63	2325	3	_abele
able	6	63	4053	3	_a_ble
addle	7	43	1835	3	_addle
aff	9	55	3761	3	_aff__
affable	15	11	740	3	_affable
affine	12	3	1050	3	_affine
affix	18	3	600	3	_affix
afflux	19	4	279	3	_afflux
afire	8	62	1591	3	_afire
afore	8	58	1860	3	_afore
agile	6	51	2226	3	_agile
aisle	5	52	2319	3	_aisle
ale	3	65	7234	3	_a__le
amble	9	59	2464	3	_amble
amole	7	57	2459	3	_amole
ample	9	47	2030	3	_ample
anele	5	56	2883	3	_anele
angle	6	45	2888	3	_angle
anile	5	46	3446	3	_anile
ankle	9	52	2025	3	_ankle
anole	5	53	3038	3	_anole
apple	9	45	1767	3	_apple
argle	6	54	2156	3	_argle
awful	11	7	814	3	awful_
awhile	12	5	779	3	awhile
axile	12	60	2051	3	_axile
axle	11	64	2460	3	_a_xle
azole	14	51	1803	3	_azole
babble	9	40	1711	3	babble
baff	12	46	3227	3	baff__
baffed	15	48	1217	3	baffed
baffies	15	36	1294	3	baffies
bafflers	16	35	659	3	bafflers
baffs	13	47	1805	3	baff_s
baffy	16	55	1192	3	baff_y
bale	6	63	5384	3	ba__le
bangle	9	40	1896	3	bangle
barfly	14	33	965	3	barfly
battle	8	52	1786	3	battle
bauble	10	38	1321	3	bauble
cable	9	53	2991	3	ca_ble
cackle	14	34	1692	3	cackle
cafe	9	52	3032	3	ca_f_e
caff	12	56	3167	3	caff__
caffs	13	54	1737	3	caff_s
cajole	15	40	1118	3	cajole
candle	9	43	2148	3	candle
cantle	8	45	2215	3	cantle
carle	7	45	3570	3	ca_rle
castle	8	49	1896	3	castle
cattle	8	51	1890	3	cattle
caudle	9	39	1291	3	caudle
coffee	14	41	1374	3	coffee
coffled	16	29	736	3	coffled
coffles	15	26	1000	3	coffles
dabble	11	45	1519	3	dabble
daddle	9	42	1428	3	daddle
daff	11	52	2968	3	daff__
daffed	14	42	949	3	daffed
daffier	14	5	783	3	daffier
daffily	17	3	514	3	daffily
daffs	12	51	1642	3	daff_s
daffy	15	55	1028	3	daff_y
daftly	13	3	544	3	daftly
daggle	9	37	1190	3	daggle
dale	5	56	4398	3	da__le
dandle	8	42	1809	3	dandle
dangle	8	41	1931	3	dangle
dapple	11	3	885	3	dapple
darkle	11	38	1394	3	darkle
dartle	7	37	1483	3	dartle
dawdle	11	39	950	3	dawdle
dayfly	16	3	381	3	dayfly
dazzle	15	3	685	3	dazzle
defile	10	52	1666	3	defile
duffel	13	40	775	3	duffel
duffles	14	30	892	3	duffles
eagle	6	42	1948	3	ea_gle
fable	10	58	2475	3	fa_ble
facile	11	25	1488	3	facile
faille	9	34	1474	3	faille
farfel	12	43	1043	3	farfel
farle	8	69	2924	3	fa_rle
file	7	54	4664	3	__file
gabble	11	38	1572	3	gabble
gable	8	53	2552	3	ga_ble
gadfly	14	3	466	3	gadfly
gaff	11	48	2815	3	gaff__
gaffed	14	42	1020	3	gaffed
gaffer	13	43	1013	3	gaffer
gaffes	13	48	1110	3	gaffes
gaffs	12	49	1465	3	gaff_s
gaggle	9	34	1262	3	gaggle
gale	5	63	4732	3	ga__le
gamble	11	54	1718	3	gamble
garble	9	41	1845	3	garble
gargle	8	42	1546	3	gargle
habile	11	5	1521	3	habile
hackle	15	49	1681	3	hackle
haffet	15	3	1170	3	haffet
haffit	15	3	853	3	haffit
haggle	11	35	1198	3	haggle
hale	7	60	5283	3	ha__le
handle	10	42	1929	3	handle
hantle	9	43	1820	3	hantle
haole	8	48	2008	3	ha_ole
hassle	9	37	1159	3	hassle
jangle	14	44	1630	3	jangle
kaffir	16	34	530	3	kaffir
kale	8	65	3375	3	ka__le
labile	8	3	1522	3	labile
ladle	6	63	2044	3	la_dle
mackle	14	37	1643	3	mackle
macle	9	61	2700	3	ma_cle
macule	10	41	1527	3	macule
maffia	14	32	720	3	maffia
maile	7	52	3222	3	ma_ile
male	6	60	5230	3	ma__le
mangle	9	39	2133	3	mangle
mantle	8	44	2092	3	mantle
maple	9	55	2114	3	ma_ple
marble	10	42	1910	3	marble
mayfly	17	3	440	3	mayfly
muffled	16	37	778	3	muffled
muffler	15	39	834	3	muffler
muffles	15	39	1045	3	muffles
naff	10	51	2893	3	naff__
naffed	13	40	833	3	naffed
naffs	11	62	1396	3	naff_s
paddle	10	46	1514	3	paddle
padle	8	45	2234	3	pa_dle
pale	6	60	5501	3	pa__le
papule	10	22	1213	3	papule
parle	7	58	3616	3	pa_rle
parole	8	44	2525	3	parole
piaffe	14	9	491	3	piaff_e
piffled	16	36	640	3	piffled
piffles	15	36	876	3	piffles
purfle	11	25	1118	3	purfle
rabble	10	38	1824	3	rabble
rackle	12	39	1729	3	rackle
raddle	8	48	1617	3	raddle
raff	10	49	3304	3	raff__
raffia	12	28	770	3	raffia
rafflers	14	31	736	3	rafflers
raffs	11	50	1752	3	raff_s
raggle	8	37	1288	3	raggle
rale	4	50	5056	3	ra__le
ramble	10	45	1997	3	ramble
rankle	10	34	1488	3	rankle
rassle	6	38	1320	3	rassle
rattle	6	47	1761	3	rattle
refile	9	51	2237	3	refile
riffled	14	33	860	3	riffled
riffler	13	32	835	3	riffler
riffles	13	39	1116	3	riffles
rifle	8	55	1833	3	_rifle
ruffe	11	47	1381	3	ruff_e
ruffled	14	36	915	3	ruffled
ruffler	13	36	972	3	ruffler
ruffles	13	35	1227	3	ruffles
ruffly	15	33	667	3	ruffly
sable	7	47	3216	3	sa_ble
saddle	8	39	1549	3	saddle
safe	7	59	3095	3	sa_f_e
safely	12	24	939	3	safely
safrole	10	3	725	3	safrole
sale	4	49	5970	3	sa__le
sample	10	42	1501	3	sample
sawfly	15	3	513	3	sawfly
scuffle	15	26	689	3	scuffle
shuffle	16	27	692	3	shuffle
skiffle	17	22	520	3	skiffle
snaffled	15	28	521	3	snaffled
snaffles	14	24	604	3	snaffles
sniffle	13	28	765	3	sniffle
snuffle	13	26	783	3	snuffle
souffle	13	30	680	3	souffle
stifle	9	36	1190	3	stifle
swaddle	12	27	674	3	swaddle
swale	8	52	2159	3	swa__le
table	7	54	2960	3	ta_ble
tackle	12	38	1573	3	tackle
taffia	12	28	690	3	taffia
taffies	13	30	1269	3	taffies
taffy	14	51	1082	3	taff_y
taille	6	31	1692	3	taille
tale	4	61	5416	3	ta__le
tamale	8	37	1740	3	tamale
tangle	7	40	1997	3	tangle
tattle	6	41	1565	3	tattle
toffee	12	33	1101	3	toffee
trifle	9	40	1288	3	trifle
truffle	13	8	489	3	truffle
twaddle	12	24	571	3	twaddle
twangle	11	4	581	3	twangle
twattle	10	6	427	3	twattle
vagile	10	3	1054	3	vagile
vale	7	49	3734	3	va__le
wabbled	15	33	1144	3	wabbled
wabbler	14	35	1192	3	wabbler
wabbles	14	40	1399	3	wabbles
wabbly	16	34	836	3	wabbly
wacke	14	59	1862	3	wa_cke
wadable	13	3	1023	3	wadable
waddie	11	40	1332	3	waddie
waddled	13	36	1164	3	waddled
waddler	12	40	1079	3	waddler
waddles	12	43	1484	3	waddles
waddly	14	47	872	3	waddly
wade	8	52	3706	3	wa__de
wadmel	12	3	552	3	wadmel
wae	6	75	5695	3	wa___e
waeful	12	3	812	3	waeful
wafer	11	44	1764	3	wa_fer
wafered	14	28	843	3	wafered
wafers	12	43	1614	3	wafers
wafery	15	39	869	3	wafery
waffing	17	37	1024	3	waffing
waffliest	18	4	423	3	waffliest
waffling	18	4	542	3	waffling
waft	10	61	3900	3	wa_f_t
waftage	14	11	532	3	waftage
wafted	13	40	1214	3	wafted
wafter	12	41	1461	3	wafter
wafts	11	69	2055	3	wa_fts
wafture	13	3	485	3	wafture
wage	8	48	3408	3	wa__ge
waggled	13	38	936	3	waggled
waggles	12	38	1200	3	waggles
waggly	14	34	729	3	waggly
wahine	12	38	1301	3	wahine
waif	10	58	3675	3	waif__
waifed	13	40	1103	3	waifed
waiflike	18	3	457	3	waiflike
waifs	11	57	1987	3	waif_s
wail	7	52	3882	3	wa_il_
wailed	10	48	2359	3	wa_iled
wailer	9	37	2032	3	wa_iler
wails	8	66	3148	3	wa_ils
waive	11	42	1460	3	wa_ive
wakame	15	3	543	3	wakame
wake	11	49	3570	3	wa__ke
waled	9	43	3099	3	wa__led
waler	8	42	2926	3	wa__ler
wales	8	61	4283	3	wa__les
walk	11	56	2561	3	wa__lk
wall	7	62	3610	3	wa__ll
walla	8	53	2103	3	wa_lla
walled	10	40	2129	3	wa_lled
wallet	9	33	2709	3	wa_llet
wallie	9	32	1680	3	wallie
walls	8	55	2938	3	wa_lls
wally	11	46	2509	3	wa_lly
waly	10	58	3090	3	wa__ly
wambled	15	36	1075	3	wambled
wambles	14	37	1402	3	wambles
wambly	16	38	866	3	wambly
wame	9	50	3548	3	wa__me
wane	7	63	4472	3	wa__ne
wangled	12	33	1241	3	wangled
wangler	11	33	1265	3	wangler
wangles	11	34	1693	3	wangles
wanly	11	51	1802	3	wa_nly
warbled	13	32	1216	3	warbled
warbler	12	32	1146	3	warbler
warbles	12	32	1556	3	warbles
ware	7	62	5472	3	wa__re
warfare	13	3	673	3	warfare
warily	12	29	1509	3	warily
warmly	14	22	806	3	warmly
warsled	11	29	1044	3	warsled
warsler	10	28	989	3	warsler
warsles	10	34	1364	3	warsles
warstle	10	32	801	3	warstle
waste	8	61	2505	3	wa_ste
watape	11	20	848	3	watape
wattled	11	36	1050	3	wattled
wattles	10	38	1407	3	wattles
waul	7	69	2731	3	wa_ul_
wauled	10	47	1396	3	wa_uled
wauls	8	61	2055	3	wa_uls
wave	10	52	3473	3	wa__ve
wavelet	13	3	1094	3	wavelet
wavicle	15	3	406	3	wavicle
wavily	15	21	948	3	wavily
wawl	10	53	2194	3	wa_wl_
wawled	13	38	1170	3	wa_wled
wawls	11	54	1647	3	wa_wls
waxable	19	3	767	3	waxable
waxily	19	21	841	3	waxily
whale	11	55	1743	3	w_hale
whiffled	21	3	304	3	whiffled
whiffler	20	3	348	3	whiffler
whiffles	20	3	426	3	whiffles
while	11	54	1869	3	w_hile
whole	11	44	1809	3	w_hole
widdle	11	38	1484	3	widdle
wife	10	52	2802	3	w_if_e
wifely	15	42	942	3	wifely
wiggle	11	37	1301	3	wiggle
wile	7	59	4437	3	w__ile
wimble	13	32	1192	3	wimble
wimple	13	36	1136	3	wimple
windle	10	46	1795	3	windle
winkle	13	38	1283	3	winkle
wintle	9	40	1460	3	wintle
wobble	13	32	1231	3	wobble
woful	11	5	817	3	woful_
wrangle	11	3	738	3	wrangle
wrassle	10	35	717	3	wrassle
wrastle	10	36	899	3	wrastle
wyle	10	55	1938	3	w__yle
yaff	13	53	2426	3	yaff__
yaffed	16	45	732	3	yaffed
yaffs	14	53	1112	3	yaff_s
zaffar	21	38	504	3	zaffar
zaffer	21	39	715	3	zaffer
zaffir	21	39	551	3	zaffir
zaffres	22	32	499	3	zaffres

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	360	5.123	22002.0
3	Display Results	360	360	0.110	3272.7
	(SQL Overall)	178691	360	5.609	31857.9