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

Here are the results of your fuzzy-string dictionary search for “mems” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

371 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
mems	8	59	3150	(None)
ems	5	64	3549	1	_ems
fems	9	64	2870	1	fems
gems	7	53	2911	1	gems
hems	9	55	3494	1	hems
meds	7	57	3536	1	meds
megs	7	55	3063	1	megs
mels	6	59	4153	1	mels
mem	7	79	4347	1	mem_
meme	8	53	3055	1	meme
memes	9	49	2770	1	memes
memo	8	59	2479	1	memo
memos	9	57	1911	1	memos
mess	6	59	3243	1	mess
mews	9	66	2933	1	mews
moms	8	65	3948	1	moms
mums	8	57	3277	1	mums
rems	6	62	3772	1	rems
aims	6	77	3818	2	aims
alms	6	58	3492	2	alms
amens	7	56	2484	2	amens
arms	6	61	3749	2	arms
bams	8	70	4445	2	bams
beams	9	53	2817	2	beams
beds	7	59	3778	2	beds
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bema	8	58	2525	2	bema
bemas	9	64	2428	2	bemas
bens	6	59	4570	2	bens
berms	9	53	2366	2	berms
bes	5	65	5743	2	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bums	8	59	3459	2	bums
cams	8	70	4728	2	cams
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cwms	11	43	957	2	cwms
dams	7	74	4437	2	dams
debs	7	65	3024	2	debs
deems	8	54	2177	2	deems
dees	5	63	5663	2	dees
dels	5	67	4547	2	dels
deme	7	65	3628	2	deme
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demos	8	60	2299	2	demos
demy	10	54	2285	2	demy
dens	5	59	4507	2	dens
derms	8	50	2289	2	derms
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
dims	7	54	3502	2	dims
doms	7	62	3957	2	doms
eds	4	66	3892	2	_eds
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
elms	6	73	2270	2	elms
els	3	76	4572	2	_els
em	4	94	4515	2	_em_
eme	5	58	3718	2	_eme
emes	6	54	3466	2	emes
emeus	7	69	1333	2	emeus
emmy	11	60	1324	2	emmy
emmys	12	44	602	2	emmys
emu	5	59	2998	2	_emu
emus	6	68	2168	2	emus
ens	3	72	4592	2	_ens
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
ess	3	60	3088	2	_ess
feds	8	52	3431	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fem	8	60	4073	2	fem_
feme	9	61	3054	2	feme
femes	10	56	2622	2	femes
fens	7	61	3976	2	fens
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
gams	7	66	4888	2	gams
geds	6	67	3081	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gem	6	68	4022	2	gem_
gens	5	57	4007	2	gens
germs	8	51	1887	2	germs
gets	5	54	4248	2	gets
geums	8	54	1411	2	geums
gums	7	50	3094	2	gums
gyms	10	75	1459	2	gyms
haems	10	55	1701	2	haems
hams	9	64	4613	2	hams
hehs	10	67	2396	2	hehs
helms	10	56	1946	2	helms
hem	8	61	4873	2	hem_
heme	9	50	3441	2	heme
hemes	10	50	3108	2	hemes
hemp	11	57	2562	2	hemp
hemps	12	69	1733	2	hemps
hens	7	56	4257	2	hens
herms	10	56	2643	2	herms
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
hims	9	52	3097	2	hims
hums	9	68	3142	2	hums
imams	9	15	1111	2	imams
isms	6	62	1347	2	isms
items	7	49	961	2	items
jams	13	52	3107	2	jams
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
keas	8	63	3709	2	keas
kefs	11	59	2274	2	kefs
kegs	9	58	2401	2	kegs
kemp	12	64	1876	2	kemp
kemps	13	50	1252	2	kemps
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	2	keys
lams	6	65	5226	2	lams
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	le_s
less	4	56	3510	2	less
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
lums	6	57	3424	2	lums
macs	8	67	4250	2	macs
mads	7	68	4536	2	mads
maes	6	69	4839	2	maes
mags	7	54	4452	2	mags
maims	9	63	2179	2	maims
malms	9	50	2155	2	malms
mama	8	62	3158	2	mama
mamas	9	59	3077	2	mamas
mans	6	63	5453	2	mans
maps	8	61	4104	2	maps
mars	6	62	6186	2	mars
mas	5	81	7581	2	m_as
mass	6	60	4493	2	mass
mats	6	54	6028	2	mats
maws	9	64	3713	2	maws
mays	9	69	4002	2	mays
me	4	77	4833	2	me__
mead	7	55	3160	2	mead
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal
meals	7	59	3337	2	meals
mean	6	55	3808	2	mean
means	7	58	3122	2	means
meat	6	63	5960	2	meat
meats	7	50	3405	2	meats
med	6	61	4674	2	me_d
meed	7	49	3470	2	meed
meeds	8	49	2027	2	meeds
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
meets	7	42	2461	2	meets
meg	6	60	4095	2	me_g
mega	7	76	2087	2	mega
mel	5	60	4748	2	me_l
meld	7	58	3047	2	meld
melds	8	48	2238	2	melds
mell	6	49	3561	2	mell
mells	7	50	3133	2	mells
melt	6	57	5289	2	melt
melts	7	49	3010	2	melts
men	5	92	5284	2	me_n
mend	7	53	3402	2	mend
mends	8	49	2769	2	mends
meno	6	60	3135	2	meno
mensa	7	53	1866	2	mensa
mense	7	50	2563	2	mense
mensh	10	54	1355	2	mensh
menu	6	51	3022	2	menu
menus	7	58	2284	2	menus
meou	6	53	2586	2	meou
meous	7	61	2006	2	meous
meow	9	51	1788	2	meow
meows	10	46	1268	2	meows
merc	8	72	2562	2	merc
mercs	9	60	2045	2	mercs
mere	6	72	4444	2	mere
meres	7	51	4357	2	meres
merk	10	60	2794	2	merk
merks	11	47	2240	2	merks
merl	6	58	3097	2	merl
merls	7	74	2390	2	merls
mesa	6	70	2548	2	mesa
mesas	7	68	2320	2	mesas
mesh	9	68	2300	2	mesh
messy	10	49	1383	2	messy
met	5	60	7243	2	me_t
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
metes	7	47	3621	2	metes
meth	9	58	2784	2	meth
meths	10	53	2023	2	meths
metis	7	50	2590	2	metis
mew	8	61	3773	2	me_w
mewl	9	56	1832	2	mewl
mewls	10	58	1323	2	mewls
meze	15	44	2090	2	meze
mezes	16	77	1926	2	mezes
mhos	9	55	1777	2	mhos
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4178	2	mids
miens	7	61	1830	2	miens
migs	7	69	3532	2	migs
mils	6	60	4533	2	mils
mim	7	60	4842	2	mim_
mime	8	57	3640	2	mime
mimes	9	57	3202	2	mimes
mips	8	55	3408	2	mips
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	m_is
miss	6	53	3942	2	miss
mm	6	78	2681	2	m_m_
moas	6	55	4534	2	moas
mobs	8	57	3737	2	mobs
mocs	8	58	3490	2	mocs
modems	11	46	1076	2	modems
mods	7	79	4505	2	mods
mogs	7	54	3933	2	mogs
mols	6	59	4857	2	mols
mom	7	88	5316	2	mom_
mome	8	52	3935	2	mome
momes	9	51	3447	2	momes
momi	8	75	2448	2	momi
momus	9	61	1611	2	momus
mons	6	81	5225	2	mons
moos	6	60	5130	2	moos
mops	8	59	4013	2	mops
mors	6	59	5006	2	mors
mos	5	70	6712	2	m_os
moss	6	76	4103	2	moss
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
muds	7	55	3065	2	muds
mugs	7	62	3204	2	mugs
mum	7	66	4361	2	mum_
mumm	7	57	1886	2	mumm
mumms	8	55	1315	2	mumms
mump	10	54	2572	2	mump
mumps	11	56	1910	2	mumps
mumu	8	60	2206	2	mumu
mumus	9	55	1728	2	mumus
muns	6	55	3591	2	muns
mus	5	59	4675	2	m_us
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
mycs	11	53	1429	2	mycs
nebs	6	61	2498	2	nebs
neems	7	73	1629	2	neems
negs	5	57	2736	2	negs
nema	6	55	2252	2	nema
nemas	7	53	2157	2	nemas
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
neums	7	54	1425	2	neums
news	7	61	2737	2	news
nims	6	62	2688	2	nims
noms	6	56	3640	2	noms
oes	3	58	6619	2	oe_s
ohms	9	55	1403	2	ohms
omens	7	56	1896	2	omens
omers	7	69	2319	2	omers
oms	5	63	3751	2	_oms
pams	8	56	4176	2	pams
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
perms	9	55	2451	2	perms
pes	5	72	5978	2	pe_s
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
poems	9	57	1555	2	poems
poms	8	70	3774	2	poms
rams	6	59	5077	2	rams
reams	7	57	2962	2	reams
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rem	5	61	5004	2	rem_
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rims	6	59	3630	2	rims
roms	6	70	3896	2	roms
rums	6	48	3347	2	rums
seams	7	57	3166	2	seams
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seems	7	55	2502	2	seems
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
semis	7	46	2353	2	semis
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sims	6	57	3717	2	sims
smews	10	46	1229	2	smews
soms	6	62	3937	2	soms
stems	7	52	1995	2	stems
sums	6	58	3758	2	sums
tams	6	72	4793	2	tams
teams	7	57	2651	2	teams
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
teems	7	60	1978	2	teems
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
temp	8	53	2333	2	temp
temps	9	54	1713	2	temps
tens	4	56	4741	2	tens
terms	7	55	2347	2	terms
tets	4	58	4745	2	tets
tews	7	64	3164	2	tews
toms	6	83	4349	2	toms
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
vims	9	54	2331	2	vims
webs	9	66	2212	2	webs
weds	8	66	2893	2	weds
wees	7	62	4912	2	wees
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
yams	9	53	3073	2	yams
yeas	7	86	3842	2	yeas
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	ye_s
yews	10	53	2396	2	yews
ylems	10	3	926	2	ylems
zeds	14	58	2180	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps

Search took 2 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	29872	0.110	1624463.6
2	DLD Change Limit	29872	371	0.966	30923.4
3	Display Results	371	371	0.093	3989.2
	(SQL Overall)	178691	371	1.169	152858.0