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

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

324 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
milady	12	3	661	(None)
malady	12	3	786	1	malady
miladi	9	3	888	1	miladi
belady	12	48	993	2	belady
glady	10	54	1394	2	_glady
lady	8	65	2715	2	__lady
melody	12	3	720	2	melody
midday	13	32	750	2	midday
middy	12	48	1259	2	mi_ddy
mikado	13	4	451	2	mikado
miladis	10	4	982	2	miladis
milage	9	34	1412	2	milage
mild	7	53	3085	2	mil_d_
mildly	12	31	824	2	mildly
milds	8	64	2205	2	mil_ds
miliary	12	4	946	2	miliary
milky	14	40	1444	2	mil_ky
milty	10	47	2007	2	mil_ty
misadd	10	3	716	2	misadd
mislay	11	35	1068	2	misla_y
moldy	11	50	1465	2	mol_dy
ailed	6	62	4028	3	ailed_
alary	8	61	2344	3	_alary
allay	8	56	2039	3	alla_y
baldy	11	55	1893	3	bal_dy
beady	11	47	1992	3	_beady
belay	10	50	2152	3	bela_y
bialy	10	51	1932	3	bi_aly
biddy	12	46	1269	3	bi_ddy
bigamy	14	3	634	3	bigamy
bilby	12	49	1235	3	bil_by
bilgy	11	47	1371	3	bil_gy
biliary	12	3	821	3	biliary
billy	10	55	2536	3	bil_ly
binary	11	3	1222	3	binary
blade	8	59	2333	3	_blade
bready	12	45	1118	3	bready
cicada	11	3	641	3	cicada
ciliary	12	4	792	3	ciliary
clad	7	62	2582	3	_clad_
clade	8	58	2101	3	_clade
clads	8	57	2273	3	_clads
clary	10	57	1961	3	_clary
clay	9	59	2741	3	_cla_y
delay	9	48	2063	3	dela_y
diary	9	50	1697	3	di_ary
didy	9	91	2151	3	di__dy
digamy	13	3	589	3	digamy
dilate	7	32	2069	3	dilate
dildo	7	19	1177	3	dil_do
dilly	9	49	2378	3	dil_ly
dipody	13	3	636	3	dipody
fila	7	47	2913	3	fila__
filar	8	48	1929	3	fila_r
filed	9	53	3190	3	filed_
filly	11	44	2490	3	fil_ly
filmy	13	61	1404	3	fil_my
filthy	15	35	642	3	filthy
flaky	15	57	1558	3	_flaky
flamy	13	52	1747	3	_flamy
flawy	14	59	1338	3	_flawy
flaxy	18	90	1229	3	_flaxy
flay	10	63	3280	3	_fla_y
galaxy	17	47	631	3	galaxy
gelada	8	3	762	3	gelada
giddy	11	58	1020	3	gi_ddy
gild	6	55	2651	3	gil_d_
gilds	7	54	1752	3	gil_ds
gilly	9	43	2163	3	gil_ly
glad	6	56	2401	3	_glad_
glade	7	51	2196	3	_glade
gladly	11	49	793	3	_gladly
glads	7	56	2061	3	_glads
glary	9	60	1854	3	_glary
glazy	18	74	1098	3	_glazy
heady	12	51	1726	3	_heady
hila	7	62	2835	3	hila__
hilar	8	54	1814	3	hila_r
hilly	11	44	2216	3	hil_ly
iliad	6	46	1346	3	_iliad_
iliads	7	44	867	3	_iliads
illy	7	69	2533	3	_il_ly
imbody	14	3	411	3	imbody
inlay	8	52	1432	3	inla_y
irade	6	56	1815	3	_irade
jihad	16	3	591	3	jihad_
jihads	17	3	448	3	jihads
kiddy	14	49	1028	3	ki_ddy
kilty	12	52	1389	3	kil_ty
lacy	9	58	2963	3	__lacy
lad	4	81	6570	3	__lad_
lade	5	63	4598	3	__lade
lads	5	65	4913	3	__lads
laky	11	67	2582	3	__laky
lardy	9	61	1927	3	__lardy
lay	6	88	6535	3	__la_y
lazy	16	64	2307	3	__lazy
leady	9	56	1860	3	_leady
lilac	7	3	1107	3	lila_c
lilacs	8	3	748	3	lilacs
lily	7	67	3018	3	lil__y
lindy	9	69	1831	3	li_ndy
litany	9	3	905	3	litany
mad	6	89	5871	3	m__ad_
made	7	54	4024	3	m__ade
madly	11	52	1813	3	m__adly
mads	7	68	4537	3	m__ads
mailed	9	53	2675	3	mailed_
malar	7	64	2444	3	mala_r
malarky	16	4	543	3	malarky
malars	8	50	2068	3	malars
malate	8	46	2456	3	malate
malmy	12	48	1634	3	mal_my
malty	10	67	2170	3	mal_ty
many	9	57	3186	3	m__any
maundy	12	50	678	3	maundy
may	8	87	5763	3	m__a_y
mayday	15	3	588	3	mayday
mazy	18	64	1970	3	m__azy
mead	7	55	3160	3	m_ead_
meads	8	54	2532	3	m_eads
mealy	10	44	2218	3	m_ealy
meany	10	46	2048	3	m_eany
meaty	10	70	2131	3	m_eaty
meld	7	58	3047	3	mel_d_
melds	8	48	2238	3	mel_ds
melty	10	49	1836	3	mel_ty
menad	8	59	1898	3	menad_
menads	9	55	1438	3	menads
miaou	7	5	1308	3	mi_aou
miaow	10	5	835	3	mi_aow
miasm	9	12	1109	3	mi_asm
miaul	7	16	1212	3	mi_aul
mica	8	64	2825	3	mica__
micas	9	68	2305	3	mica_s
mickey	17	42	1185	3	mickey
mid	6	73	5447	3	mi__d_
midair	9	3	799	3	midair
middays	14	33	566	3	middays
midi	7	56	2848	3	mi__di
midland	11	3	661	3	midland
midlands	12	4	554	3	midlands
mids	7	65	4179	3	mi__ds
midway	15	32	715	3	midway
miffy	16	39	1020	3	mi_ffy
mighty	15	43	1021	3	mighty
mikados	14	4	468	3	mikados
miked	12	50	2045	3	miked_
mil	5	57	5211	3	mil___
miladies	11	3	992	3	miladies
milages	10	31	1440	3	milages
milch	12	44	1337	3	mil_ch
milded	10	44	1615	3	milded
milden	9	41	1315	3	milden
milder	9	38	1845	3	milder
mildew	12	31	904	3	mildew
mildewy	16	35	353	3	mildewy
mile	6	63	5257	3	mil__e
mileage	10	29	931	3	mileage
miler	7	57	3306	3	mil_er
milers	8	46	2516	3	milers
miles	7	46	4507	3	mil_es
milia	7	27	1957	3	mil_ia
milieu	8	3	1411	3	milieu
military	13	4	723	3	military
milium	10	47	1268	3	milium
milk	10	50	2847	3	mil__k
milked	13	46	1257	3	milked
milker	12	48	1432	3	milker
milkily	16	21	655	3	milkily
milks	11	50	2058	3	mil_ks
mill	6	65	4148	3	mil__l
millage	10	31	1275	3	millage
milldam	12	4	547	3	milldam
mille	7	50	2913	3	mil_le
milled	9	43	2617	3	milled
miller	8	46	2541	3	miller
milles	8	45	2656	3	milles
millet	8	40	3074	3	millet
milliary	13	4	685	3	milliary
mills	7	54	3505	3	mil_ls
milneb	10	9	595	3	milneb
milo	6	55	3610	3	mil__o
milord	9	9	957	3	milord
milords	10	11	785	3	milords
milos	7	54	2801	3	mil_os
milpa	9	21	1140	3	mil_pa
milpas	10	17	1027	3	milpas
mils	6	60	4533	3	mil__s
milt	6	54	5581	3	mil__t
milted	9	39	1994	3	milted
milter	8	49	2123	3	milter
milts	7	54	3071	3	mil_ts
mimed	10	56	2273	3	mimed_
mina	6	51	3692	3	mina__
minae	7	56	2772	3	mina_e
minas	7	54	3411	3	mina_s
mincy	12	58	1741	3	mi_ncy
mind	7	54	3438	3	mi_nd_
minds	8	54	2712	3	mi_nds
mined	8	53	3335	3	mined_
mingy	11	55	2018	3	mi_ngy
minify	14	3	925	3	minify
minny	10	45	1866	3	mi_nny
minty	10	63	2390	3	mi_nty
mirador	10	4	650	3	mirador
mirage	9	23	1365	3	mirage
mired	8	57	2922	3	mired_
mirky	14	63	1552	3	mi_rky
miry	9	63	2675	3	mi__ry
misact	10	3	1669	3	misact
misadds	11	3	630	3	misadds
misaim	10	3	1185	3	misaim
misally	12	11	1106	3	misally
misandry	14	4	386	3	misandry
misate	8	12	2269	3	misate
misdo	8	54	1318	3	mi_sdo
misery	11	41	1354	3	misery
mislaid	10	3	930	3	mislaid
mislain	9	3	1124	3	mislain
mislays	12	34	924	3	mislays
mislead	10	41	997	3	mislead_
misleads	11	35	854	3	misleads
misled	9	47	1931	3	misled_
mismade	12	12	935	3	mismade
misplay	14	3	638	3	mispla_y
missay	11	41	1214	3	missay
missy	10	56	1756	3	mi_ssy
misty	10	61	2045	3	mi_sty
mity	9	55	2821	3	mi__ty
mixed	15	57	1725	3	mixed_
mixedly	20	3	398	3	mixedly
mizzly	19	25	610	3	mizzly
moiled	9	43	1886	3	moiled_
mola	6	60	3563	3	mola__
molal	7	51	2034	3	mola_l
molar	7	52	2309	3	mola_r
molars	8	55	1732	3	molars
molas	7	51	3209	3	mola_s
mold	7	60	3433	3	mol_d_
molds	8	53	2483	3	mol_ds
molly	10	52	2249	3	mol_ly
moly	9	60	3191	3	mol__y
monad	8	55	1947	3	monad_
monads	9	45	1530	3	monads
monody	12	3	824	3	monody
moody	11	50	1749	3	m_oody
moray	10	54	2379	3	mora_y
mouldy	12	43	741	3	mouldy
muddy	12	38	1223	3	m_uddy
muled	8	58	2443	3	muled_
muley	10	48	1928	3	mul_ey
mulley	11	40	1345	3	mulley
mylar	10	53	1153	3	myla_r
mylars	11	43	1044	3	mylars
nicad	8	3	1261	3	nicad_
nicads	9	3	833	3	nicads
oiled	6	44	2947	3	oiled_
oilily	9	31	1172	3	oilily
oilway	12	3	574	3	oilway
oily	7	79	3225	3	oil__y
oldy	8	53	1684	3	_ol_dy
onlay	8	42	1294	3	onla_y
pilaf	10	39	2348	3	pila_f
pilaff	14	39	1036	3	pilaff
pilafs	11	35	1102	3	pilafs
pilar	7	52	2150	3	pila_r
pilau	7	36	1852	3	pila_u
pilaus	8	41	1413	3	pilaus
pilaw	10	39	1374	3	pila_w
pilaws	11	39	943	3	pilaws
piled	8	52	3299	3	piled_
pily	9	61	3273	3	pil__y
piracy	13	3	947	3	piracy
platy	10	50	2166	3	_platy
play	9	59	2898	3	_pla_y
ready	9	48	2150	3	_ready
relay	8	44	2467	3	rela_y
riled	6	58	3325	3	riled_
riley	8	44	2058	3	ril_ey
rindy	9	57	1739	3	ri_ndy
salad	6	53	2183	3	salad_
salads	7	53	1696	3	salads
salary	9	5	1521	3	salary
shady	12	54	1651	3	_shady
silage	7	27	1530	3	silage
silane	6	27	1805	3	silane
sild	5	50	3058	3	sil_d_
silds	6	55	2052	3	sil_ds
silky	12	53	1582	3	sil_ky
silly	8	45	2762	3	sil_ly
silty	8	47	2163	3	sil_ty
slaty	8	65	2315	3	_slaty
slay	7	64	3638	3	_sla_y
smilax	15	3	539	3	smila_x
smiled	9	37	1643	3	smiled_
smiley	11	40	1230	3	smil_ey
splay	10	58	1604	3	spla_y
steady	10	35	1020	3	steady
tidy	8	68	2242	3	ti__dy
tilak	9	10	1155	3	tila_k
tilaks	10	9	735	3	tilaks
tilde	6	50	1734	3	til_de
tiled	6	48	3294	3	tiled_
tirade	7	3	1169	3	tirade
toady	9	68	1434	3	_toady
tuladi	7	6	572	3	tuladi
unlade	7	27	1415	3	unlade
unlay	8	46	1370	3	unla_y
vilely	12	3	944	3	vilely
vilify	15	3	677	3	vilify
vivary	15	3	698	3	vivary
wady	11	53	2499	3	__wady
widdy	13	61	1218	3	wi_ddy
wieldy	13	47	618	3	wieldy
wild	8	51	2651	3	wil_d_
wildly	13	32	812	3	wildly
wilds	9	48	1820	3	wil_ds
wiled	9	52	3155	3	wiled_
wilily	12	33	1076	3	wilily
willy	11	53	2191	3	wil_ly
wily	10	64	2881	3	wil__y
windy	12	61	1810	3	wi_ndy
yclad	11	24	638	3	yclad_

Search took 8 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.373	479064.3
2	DLD Change Limit	112716	324	6.780	16624.8
3	Display Results	324	324	0.096	3375.0
	(SQL Overall)	178691	324	7.249	24650.4