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

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

315 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
melody	12	3	720	(None)
belady	12	48	993	2	belady
embody	14	3	503	2	embody
felony	12	37	1032	2	felony
malady	12	3	786	2	malady
meld	7	58	3047	2	mel_d_
melds	8	48	2238	2	mel_ds
melodia	10	3	888	2	melodia
melodic	12	3	854	2	melodic
meloid	9	6	1600	2	meloid
meloids	10	9	1145	2	meloids
melon	7	39	2208	2	melo_n
melons	8	41	1771	2	melons
melty	10	49	1836	2	mel_ty
memory	13	3	880	2	memory
milady	12	3	661	2	milady
moldy	11	50	1465	2	mol_dy
monody	12	3	824	2	monody
moody	11	50	1749	2	m_oody
rebody	12	3	815	2	rebody
allod	6	44	1838	3	allod_
allods	7	36	1508	3	allods
alloy	8	55	1997	3	allo_y
baldy	11	55	1893	3	bal_dy
beady	11	47	1992	3	be_ady
belay	10	50	2152	3	bel_ay
belfry	14	3	507	3	belfry
belly	10	46	2549	3	bel_ly
belon	7	39	2411	3	belo_n
belong	9	34	1104	3	belong
belons	8	41	1941	3	belons
below	10	46	1719	3	belo_w
belows	11	46	1418	3	belows
bendy	11	50	1725	3	be_ndy
betony	11	42	1158	3	betony
bloody	12	47	1017	3	bloody
blowy	13	43	1532	3	_blowy
body	10	74	2567	3	__body
boody	11	54	2040	3	_boody
broody	12	45	1008	3	broody
calory	11	3	1284	3	calory
celery	11	3	962	3	celery
celom	9	5	1569	3	celo_m
celoms	10	4	1212	3	celoms
clod	7	61	2461	3	_clod_
cloddy	13	40	523	3	_cloddy
clods	8	53	2086	3	_clods
cloudy	12	51	780	3	_cloudy
cloy	9	66	2383	3	_clo_y
colony	11	54	1727	3	colony
corody	12	14	970	3	corody
decode	10	44	1474	3	decode
decoy	11	57	1631	3	deco_y
deedy	10	43	1589	3	de_edy
delay	9	48	2063	3	del_ay
deled	7	53	2654	3	deled_
delly	9	60	2387	3	del_ly
delude	8	19	1067	3	delude
demode	10	40	1346	3	demode
deoxy	16	4	888	3	de_oxy
deploy	12	3	758	3	deplo_y
desoxy	17	4	462	3	desoxy
dipody	13	3	636	3	dipody
doody	10	55	1791	3	_doody
ebony	10	45	1151	3	_ebony
eddy	9	39	1209	3	_e_ddy
eely	7	77	2521	3	eel__y
eld	4	67	3379	3	_el_d_
elds	5	63	2485	3	_el_ds
elegy	9	3	930	3	_elegy
elide	6	49	2264	3	_elide
elmy	9	56	1679	3	_el_my
elodea	7	3	867	3	_elodea
eloin	5	59	2320	3	_eloin
elope	7	52	1934	3	_elope
elude	6	45	1762	3	_elude
emboly	13	3	672	3	emboly
emerod	9	13	921	3	emerod_
emerods	10	13	765	3	emerods
employ	13	4	649	3	emplo_y
epode	8	51	1409	3	_epode
epoxy	17	46	577	3	_epoxy
erode	6	45	2099	3	_erode
eulogy	10	3	563	3	eulogy
felid	9	47	1717	3	felid_
felids	10	31	1162	3	felids
felly	11	49	2280	3	fel_ly
felon	8	46	1929	3	felo_n
felonry	13	29	484	3	felonry
felons	9	36	1576	3	felons
feod	8	155	2300	3	fe_od_
feods	9	95	1685	3	fe_ods
gelada	8	3	762	3	gelada
geld	6	58	2843	3	gel_d_
gelds	7	51	1834	3	gel_ds
gelid	7	49	1698	3	gelid_
gelidly	12	3	475	3	gelidly
geode	7	4	1259	3	ge_ode
geology	12	25	732	3	geology
glady	10	54	1394	3	_glady
glory	9	64	1329	3	_glory
goody	10	56	2039	3	_goody
grody	10	34	1206	3	_grody
heady	12	51	1726	3	he_ady
held	8	53	3040	3	hel_d_
helo	7	53	3285	3	helo__
helos	8	49	2806	3	helo_s
helot	8	53	3268	3	helo_t
helotry	13	4	565	3	helotry
helots	9	52	1770	3	helots
homebody	19	5	405	3	homebody
hoody	12	49	1972	3	_hoody
imbody	14	3	411	3	imbody
implode	12	15	610	3	implode
jalopy	18	32	586	3	jalopy
jelly	15	42	1825	3	jel_ly
kelly	12	46	1702	3	kel_ly
keloid	11	8	1262	3	keloid
keloids	12	8	866	3	keloids
kelpy	14	51	1068	3	kel_py
lady	8	65	2715	3	__lady
leady	9	56	1860	3	le_ady
lemony	11	41	955	3	lemony
lode	5	62	4011	3	__lode
logy	8	70	2578	3	__logy
lory	7	59	3171	3	__lory
malmy	12	48	1634	3	mal_my
malodor	10	4	456	3	malodor
maloti	8	3	1321	3	maloti
malty	10	67	2170	3	mal_ty
maundy	12	50	678	3	maundy
mead	7	55	3160	3	me_ad_
meadow	12	3	740	3	meadow
meadowy	16	4	404	3	meadowy
meads	8	54	2532	3	me_ads
mealy	10	44	2218	3	me_aly
meanly	11	54	1204	3	meanly
meany	10	46	2048	3	me_any
measly	11	36	1044	3	measly
meaty	10	70	2131	3	me_aty
med	6	61	4674	3	me__d_
medfly	15	3	522	3	medfly
medley	12	9	834	3	medley
meds	7	57	3536	3	me__ds
meed	7	49	3470	3	me_ed_
meeds	8	49	2027	3	me_eds
meekly	15	3	519	3	meekly
meetly	11	3	867	3	meetly
megohm	14	12	419	3	megohm
mehndi	12	3	315	3	mehndi
meiny	10	40	1541	3	me_iny
mel	5	60	4748	3	mel___
melded	10	47	1471	3	melded
melder	9	39	1581	3	melder
melee	7	37	2910	3	mel_ee
melees	8	36	1808	3	melees
melena	8	11	1047	3	melena
melic	9	47	2233	3	mel_ic
mell	6	49	3561	3	mel__l
melled	9	50	2302	3	melled
mellow	11	41	1222	3	mellow
mellowly	16	25	400	3	mellowly
mellows	12	38	1223	3	mellows
mells	7	50	3133	3	mel_ls
melodeon	11	4	344	3	melodeon
melodias	11	4	870	3	melodias
melodica	13	4	498	3	melodica
melodies	11	3	1012	3	melodies
melodise	11	4	759	3	melodise
melodist	11	4	974	3	melodist
melodize	20	4	666	3	melodize
mels	6	59	4153	3	mel__s
melt	6	57	5289	3	mel__t
melted	9	42	1906	3	melted
melter	8	35	2011	3	melter
melton	8	3	1155	3	melton
meltons	9	4	1092	3	meltons
melts	7	49	3010	3	mel_ts
memo	8	59	2479	3	memo__
memoir	10	3	721	3	memoir
memos	9	57	1911	3	memo_s
menad	8	59	1898	3	menad_
menads	9	55	1438	3	menads
mend	7	53	3403	3	me_nd_
mends	8	49	2769	3	me_nds
meno	6	60	3136	3	meno__
menology	14	21	848	3	menology
menudo	9	4	579	3	menudo
meou	6	53	2586	3	me_o_u
meous	7	61	2006	3	me_ous
meow	9	51	1788	3	me_o_w
meows	10	46	1268	3	me_ows
mercy	12	59	1618	3	me_rcy
merde	8	43	2012	3	me_rde
merely	11	13	1259	3	merely
merlon	8	30	1235	3	merlo_n
merlons	9	33	1127	3	merlons
merlot	8	32	1761	3	merlo_t
merlots	9	27	1012	3	merlots
merry	10	47	2149	3	me_rry
meshy	13	56	1278	3	me_shy
meson	7	41	1831	3	meso_n
mesons	8	32	1584	3	mesons
messy	10	49	1383	3	me_ssy
meted	8	54	2443	3	meted_
method	12	3	903	3	method_
methods	13	3	889	3	methods
methoxy	22	4	395	3	methoxy
metol	7	59	1781	3	meto_l
metols	8	41	1577	3	metols
metonym	14	4	557	3	metonym
metope	10	6	1112	3	metope
mewed	11	52	1801	3	mewed_
mewled	12	37	1005	3	mewled_
middy	12	48	1259	3	m_iddy
miladi	9	3	888	3	miladi
mild	7	53	3085	3	mil_d_
mildly	12	31	824	3	mildly
milds	8	64	2205	3	mil_ds
milky	14	40	1444	3	mil_ky
milo	6	55	3610	3	milo__
milord	9	9	957	3	milord
milords	10	11	785	3	milords
milos	7	54	2801	3	milo_s
milty	10	47	2007	3	mil_ty
mod	6	90	5440	3	m__od_
mode	7	58	4030	3	m__ode
modi	7	68	2631	3	m__odi
mods	7	79	4505	3	m__ods
mold	7	60	3433	3	mol_d_
molds	8	53	2483	3	mol_ds
molly	10	52	2249	3	mol_ly
moloch	13	5	648	3	moloch
moly	9	60	3191	3	m__oly
mony	9	68	3001	3	m__ony
mood	7	63	3206	3	m_ood_
moods	8	52	2462	3	m_oods
mooley	11	3	1163	3	mooley
moony	10	48	1827	3	m_oony
moory	10	51	1579	3	m_oory
mopy	11	57	2197	3	m__opy
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
myeloid	13	10	812	3	myeloid
myeloma	14	4	404	3	myeloma
myology	16	3	616	3	myology
myopy	15	45	735	3	m_yopy
neddy	10	47	987	3	ne_ddy
needy	9	46	1469	3	ne_edy
nelly	8	46	1881	3	nel_ly
neology	11	23	829	3	neology
nerdy	9	50	1470	3	ne_rdy
nobody	12	3	574	3	nobody
oldy	8	53	1684	3	_ol_dy
ology	9	41	1311	3	_ology
oology	10	32	1025	3	oology
parody	12	4	1009	3	parody
pelon	7	44	2321	3	pelo_n
pelota	8	6	1283	3	pelota
peltry	11	28	865	3	peltry
peony	10	57	1756	3	pe_ony
perdy	11	54	1733	3	pe_rdy
peroxy	18	3	825	3	peroxy
petalody	14	4	387	3	petalody
plod	7	67	2327	3	_plod_
plods	8	57	1929	3	_plods
ploidy	12	3	748	3	_ploidy
ploy	9	61	2360	3	_plo_y
ready	9	48	2150	3	re_ady
recode	9	36	1871	3	recode
recopy	13	3	904	3	recopy
reedy	9	100	2029	3	re_edy
relay	8	44	2467	3	rel_ay
reload	7	4	1389	3	reload
reloads	8	9	1131	3	reloads
reloan	6	4	1569	3	reloan
relock	12	47	1352	3	relock
relook	10	48	1374	3	relook
rely	7	54	2895	3	rel__y
remedy	12	3	787	3	remedy
resod	6	47	2005	3	resod_
resods	7	41	1630	3	resods
seedy	9	48	2153	3	se_edy
seldom	9	3	941	3	seldom
sepoy	10	3	1430	3	sepo_y
sloyd	9	40	968	3	_sloyd
smelly	11	41	1036	3	smel_ly
somebody	16	4	292	3	somebody
teddy	10	48	949	3	te_ddy
teledu	7	3	730	3	teledu
telly	8	49	2082	3	tel_ly
teloi	5	42	1738	3	telo_i
telome	8	3	1192	3	telome
telos	5	54	2452	3	telo_s
tepoy	10	3	1216	3	tepo_y
tody	8	63	2721	3	__tody
veld	8	53	2320	3	vel_d_
velds	9	56	1558	3	vel_ds
veldt	9	48	1986	3	vel_dt
veloce	11	3	1013	3	veloce
velour	9	32	876	3	velour
weedy	12	51	1500	3	we_edy
weirdy	13	39	546	3	weirdy
weld	8	47	2773	3	wel_d_
weldor	10	31	765	3	weldor
welds	9	47	1916	3	wel_ds
welly	11	46	2001	3	wel_ly
wieldy	13	47	618	3	wiel_dy
woody	12	51	1688	3	_woody
yeld	8	114	2387	3	yel_d_
yellowy	16	25	569	3	yellowy
zloty	17	39	979	3	_zloty

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	315	5.013	22484.7
3	Display Results	315	315	0.093	3387.1
	(SQL Overall)	178691	315	5.482	32596.0