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

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

310 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
memory	13	3	880	(None)
armory	11	42	1147	2	armory
emery	10	48	1433	2	_emery
femora	11	4	958	2	femora
lemony	11	41	955	2	lemony
melody	12	3	720	2	melody
memo	8	59	2479	2	memo__
memoir	10	3	721	2	memoir
memoirs	11	3	680	2	memoirs
memos	9	57	1911	2	memo_s
merry	10	47	2148	2	me_rry
moory	10	51	1579	2	m_oory
remora	8	4	1458	2	remora
aery	7	72	3168	3	ae__ry
almonry	12	10	473	3	almonry
amatory	12	3	862	3	amatory
ambry	12	35	1210	3	_ambry
amort	7	58	3220	3	_amort
armor	7	51	1805	3	armor_
armors	8	50	1781	3	armors
armoury	12	37	623	3	armoury
beery	10	52	2012	3	be_ery
before	11	4	1015	3	before
belfry	14	3	507	3	belfry
bemire	10	33	1280	3	bemire
bemoan	10	3	1025	3	bemoan
bemock	16	3	617	3	bemock
berry	10	45	2177	3	be_rry
betony	11	42	1158	3	betony
bevor	10	15	1081	3	bevor_
bevors	11	16	1034	3	bevors
beworm	13	3	998	3	beworm
beworry	15	4	374	3	beworry
calory	11	3	1284	3	calory
cedary	12	41	960	3	cedary
celery	11	3	962	3	celery
ceorl	7	4	1091	3	ce_orl
cory	9	69	4151	3	__cory
deary	9	58	2684	3	de_ary
decor	8	47	1757	3	decor_
decors	9	40	1777	3	decors
decoy	11	57	1631	3	deco_y
decry	11	55	1435	3	de_cry
decury	12	7	796	3	decury
deform	12	5	961	3	deform
dehorn	10	43	965	3	dehorn
dehort	10	46	1810	3	dehort
demark	13	42	1102	3	demark
demo	7	74	2755	3	demo__
demob	10	49	1350	3	demo_b
demobs	11	42	948	3	demobs
demode	10	40	1346	3	demode
demoed	10	37	1344	3	demoed
demon	8	65	2031	3	demo_n
demons	9	49	1772	3	demons
demos	8	60	2299	3	demo_s
demote	9	48	1780	3	demote
demur	8	3	1116	3	demur_
demure	9	3	1153	3	demure
demurs	9	3	977	3	demurs
demy	10	54	2285	3	dem__y
denary	10	53	1686	3	denary
deoxy	16	4	888	3	de_oxy
deport	9	49	2239	3	deport
derry	9	47	2137	3	de_rry
descry	12	5	618	3	descry
desorb	9	52	1020	3	desorb
desoxy	17	4	462	3	desoxy
deworm	12	4	952	3	deworm
dory	8	58	3623	3	__dory
ebony	10	45	1151	3	_ebony
eery	7	61	2962	3	_e_ery
embay	12	34	1060	3	_embay
embody	14	3	503	3	embody
emboly	13	3	672	3	emboly
embryo	13	6	396	3	_embryo
emir	6	59	1870	3	_emir_
emirs	7	61	1616	3	_emirs
emmer	9	43	1446	3	emmer_
emmers	10	40	1322	3	emmers
emmy	11	60	1324	3	_em_my
emote	7	54	2119	3	_emote
empery	13	4	868	3	empery
empty	12	4	776	3	_empty
enorm	7	44	1563	3	_enorm
entry	8	24	1426	3	_entry
epoxy	17	46	577	3	_epoxy
every	11	52	1545	3	_every
eyry	10	63	1588	3	_e_yry
fedora	10	3	859	3	fedora
felonry	13	29	484	3	felonry
felony	12	37	1032	3	felony
femoral	12	3	872	3	femoral
femur	10	3	868	3	femur_
femurs	11	3	671	3	femurs
ferry	11	60	2080	3	fe_rry
fetor	8	12	1453	3	fetor_
fetors	9	10	1447	3	fetors
gemmy	13	52	1105	3	gem_my
gemot	8	40	2423	3	gemo_t
gemote	9	46	1302	3	gemote
gemots	9	37	1215	3	gemots
gentry	10	34	1044	3	gentry
glory	9	64	1329	3	_glory
gory	8	61	2966	3	__gory
helotry	13	4	565	3	helotry
hemoid	12	3	1351	3	hemoid
hempy	15	49	1276	3	hem_py
henry	11	40	1447	3	he_nry
heronry	13	4	604	3	heronry
herry	11	49	2247	3	he_rry
humor	10	11	1051	3	humor_
humors	11	12	963	3	humors
ivory	11	3	737	3	_ivory
jemmy	19	49	855	3	jem_my
jerry	15	50	1618	3	je_rry
kerry	12	49	1609	3	ke_rry
leary	8	59	2738	3	le_ary
leery	8	59	1913	3	le_ery
lemon	7	56	1818	3	lemo_n
lemons	8	44	1505	3	lemons
lemur	7	3	977	3	lemur_
lemurs	8	3	725	3	lemurs
lory	7	59	3171	3	__lory
major	14	52	1292	3	major_
majorly	19	4	315	3	majorly
majors	15	45	1109	3	majors
mamey	12	54	1883	3	mam_ey
mammary	13	3	599	3	mammary
mammey	12	43	1089	3	mammey
mammy	11	52	1516	3	mam_my
manor	7	80	2393	3	manor_
manors	8	44	2088	3	manors
marry	10	48	2169	3	m_arry
masonry	12	4	412	3	masonry
mayor	10	66	1662	3	mayor_
mayors	11	57	1419	3	mayors
meadowy	16	4	404	3	meadowy
meagre	9	34	932	3	meagre
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
medfly	15	3	522	3	medfly
medley	12	9	833	3	medley
meekly	15	3	519	3	meekly
meetly	11	3	867	3	meetly
megara	9	3	1009	3	megara
megohm	14	12	419	3	megohm
meiny	10	40	1541	3	me_iny
meloid	9	6	1600	3	meloid
melon	7	39	2208	3	melo_n
melons	8	41	1771	3	melons
melty	10	49	1836	3	me_lty
mem	7	79	4347	3	mem___
member	12	25	885	3	member
members	13	25	860	3	members
meme	8	53	3055	3	mem__e
memes	9	49	2770	3	mem_es
memorably	18	4	563	3	memor~~abl~~y
memorial	12	4	952	3	memorial
memories	12	12	1435	3	memories
memorise	12	14	1143	3	memorise
memorize	21	13	1110	3	memorize
mems	8	59	3150	3	mem__s
meno	6	60	3136	3	meno__
menorah	12	4	793	3	menorah
mentor	8	4	1436	3	mentor_
mentors	9	3	1499	3	mentors
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
merc	8	72	2562	3	me__rc
mercery	14	39	762	3	mercery
mercury	14	36	489	3	mercury
mercy	12	59	1618	3	me_rcy
mere	6	72	4444	3	me__re
merely	11	13	1259	3	merely
merer	7	51	2623	3	merer_
merk	10	60	2794	3	me__rk
merl	6	58	3097	3	me__rl
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
meteor	8	49	1007	3	meteor_
meteors	9	46	1001	3	meteors
meter	7	51	3032	3	meter_
meters	8	56	2583	3	meters
methoxy	22	4	394	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
metre	7	48	2130	3	me_tre
metro	7	47	1880	3	me_tro
metros	8	42	1780	3	metros
milord	9	9	957	3	milord
mimer	9	48	2576	3	mimer_
mimers	10	55	2018	3	mimers
mimicry	16	4	349	3	mimicry
mimosa	10	3	636	3	mimosa
minor	7	49	2006	3	minor_
minors	8	51	1710	3	minors
miry	9	63	2675	3	__miry
misery	11	41	1354	3	misery
moly	9	60	3191	3	__moly
mommy	11	40	1075	3	mom_my
monody	12	3	824	3	monody
mony	9	68	3001	3	__mony
moody	11	50	1749	3	m_oody
moony	10	48	1827	3	m_oony
moor	6	66	2855	3	m_oor_
moors	7	49	2314	3	m_oors
mopery	13	52	1097	3	mopery
mopy	11	57	2197	3	__mopy
mor	5	68	5500	3	__mor_
mora	6	66	4127	3	__mora
moray	10	54	2379	3	__moray
more	6	71	5452	3	__more
morn	6	62	3756	3	__morn
mors	6	59	5006	3	__mors
mort	6	67	5883	3	__mort
motor	7	53	1729	3	motor_
motors	8	46	1660	3	motors
mucor	9	40	1194	3	mucor_
mucors	10	44	1085	3	mucors
mumbly	15	31	946	3	mumbly
mummery	13	33	666	3	mummery
mummy	11	49	1362	3	mum_my
murry	10	51	2023	3	m_urry
myopy	15	45	735	3	m_yopy
peery	10	57	1944	3	pe_ery
peltry	11	28	865	3	peltry
penury	11	4	810	3	penury
peony	10	57	1756	3	pe_ony
peroxy	18	3	825	3	peroxy
perry	10	52	2271	3	pe_rry
priory	11	41	1026	3	priory
rebody	12	3	815	3	rebody
rebore	8	66	2564	3	rebore
reborn	8	100	1695	3	reborn
rebury	11	34	921	3	rebury
recopy	13	3	904	3	recopy
record	9	61	1742	3	record
recork	12	63	1548	3	recork
rectory	12	35	1272	3	rectory
redry	9	43	1436	3	re_dry
reform	11	3	1270	3	reform
refry	11	44	1246	3	re_fry
remark	12	35	1237	3	remark
remarry	12	3	519	3	remarry
remedy	12	3	787	3	remedy
remold	9	34	1297	3	remold
remoras	9	3	1407	3	remoras
remorid	10	3	1186	3	remorid
remorse	9	3	1171	3	remorse
remote	8	42	2260	3	remote
remove	11	61	1557	3	remove
report	8	53	2601	3	report
resorb	8	49	1434	3	resorb
resort	6	57	2861	3	resort
retore	6	76	3076	3	retore
retorn	6	109	2342	3	retorn
retort	6	68	3114	3	retort
retry	8	47	1808	3	re_try
revery	12	40	1421	3	revery
reword	10	63	2140	3	reword
rewore	9	380	3015	3	rewore
rework	13	66	1978	3	rework
reworn	9	81	2219	3	reworn
rumor	7	10	1132	3	rumor_
rumors	8	11	1040	3	rumors
savory	12	43	1056	3	savory
semidry	13	4	520	3	semidry
sempre	10	27	1009	3	sempre
senary	9	37	1607	3	senary
senor	5	38	2279	3	senor_
senora	6	32	1615	3	senora
senors	6	36	2078	3	senors
sensory	10	32	908	3	sensory
sentry	9	29	1205	3	sentry
sepoy	10	3	1430	3	sepo_y
serry	8	48	2412	3	se_rry
simony	11	3	790	3	simony
smeary	11	41	1080	3	sme_ary
smoky	14	38	868	3	_smoky
story	8	67	2303	3	_story
teary	8	51	2405	3	te_ary
tenor	5	36	2025	3	tenor_
tenors	6	32	1775	3	tenors
tepoy	10	3	1216	3	tepo_y
termor	8	44	1251	3	termor_
termors	9	47	1277	3	termors
terry	8	47	2187	3	te_rry
theory	12	109	836	3	theory
tory	7	58	4054	3	__tory
tremor	8	42	1039	3	tremor_
tremors	9	37	1122	3	tremors
tumor	7	11	1069	3	tumor_
tumors	8	8	1061	3	tumors
vapory	14	39	876	3	vapory
veery	11	58	1625	3	ve_ery
venery	12	37	1066	3	venery
very	10	80	2564	3	ve__ry
vestry	12	3	862	3	vestry
weary	11	56	2061	3	we_ary
zedoary	20	4	321	3	zedoary

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	310	4.733	23814.9
3	Display Results	310	310	0.093	3333.3
	(SQL Overall)	178691	310	5.202	34350.4