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

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

355 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
emes	6	54	3466	(None)
demes	8	60	3269	1	demes
ekes	8	67	2660	1	ekes
eme	5	58	3718	1	eme_
emeu	6	67	2343	1	emeu
emeus	7	69	1333	1	emeus
ems	5	64	3549	1	em_s
emus	6	68	2168	1	emus
eses	4	53	3610	1	eses
eves	7	62	3046	1	eves
ewes	7	63	2870	1	ewes
exes	11	65	3081	1	exes
eyes	7	58	3788	1	eyes
femes	10	56	2622	1	femes
hemes	10	50	3108	1	hemes
memes	9	49	2770	1	memes
semes	7	57	3158	1	semes
aces	6	76	4509	2	aces
acmes	9	60	2065	2	acmes
aedes	6	46	2514	2	aedes
ages	5	58	4459	2	ages
ales	4	70	6710	2	ales
almes	7	51	2654	2	almes
amas	6	77	4629	2	amas
amen	6	67	3315	2	amen
amens	7	56	2484	2	amens
amies	7	68	3768	2	amies
amis	6	64	4531	2	amis
amps	8	62	3034	2	amps
amus	6	55	2961	2	amus
anes	4	52	5593	2	anes
apes	6	60	4743	2	apes
ares	4	58	7102	2	ares
ates	4	50	4792	2	ates
aves	7	61	4260	2	aves
awes	7	60	3755	2	awes
axes	11	73	3785	2	axes
ayes	7	65	4351	2	ayes
bees	6	54	5338	2	bees
bemas	9	64	2428	2	bemas
benes	7	55	3623	2	benes
bermes	10	60	2300	2	bermes
bes	5	65	5743	2	_bes
beses	7	58	3072	2	beses
byes	9	52	3053	2	byes
cames	9	70	4731	2	cames
cedes	8	49	2732	2	cedes
cees	6	59	4159	2	cees
cepes	9	44	2446	2	cepes
ceres	7	55	4001	2	ceres
cetes	7	57	3110	2	cetes
comes	9	72	4699	2	comes
cremes	10	45	1799	2	cremes
cues	6	54	3898	2	cues
cymes	12	101	1892	2	cymes
dames	8	54	3585	2	dames
deems	8	54	2177	2	deems
dees	5	63	5663	2	dees
dekes	10	52	2445	2	dekes
deles	6	51	3925	2	deles
deme	7	65	3628	2	deme_
demies	9	48	2580	2	demies
demos	8	60	2299	2	demos
denes	6	56	3972	2	denes
dexes	13	52	2451	2	dexes
dies	5	56	5352	2	dies
dimes	8	58	3304	2	dimes
does	5	65	5447	2	does
domes	8	57	3556	2	domes
dues	5	60	4550	2	dues
dyes	8	53	3189	2	dyes
ears	4	63	5659	2	ears
ease	4	50	4233	2	ease
eases	5	60	4161	2	eases
eats	4	70	5487	2	eats
eaves	8	52	3199	2	eaves
ebbs	8	24	1198	2	ebbs
eches	10	63	2216	2	eches
ecus	6	54	2146	2	ecus
edges	7	57	1872	2	edges
edhs	8	62	1210	2	edhs
eds	4	66	3892	2	e_ds
eek	7	79	3510	2	e_ek
eel	3	79	4684	2	e_el
eels	4	65	3674	2	eels
effs	10	51	1403	2	effs
efs	6	68	2960	2	e_fs
efts	7	65	1948	2	efts
eger	5	59	2356	2	eger
egers	6	51	2037	2	egers
egest	6	52	2234	2	egest
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
eke	7	56	3009	2	eke_
eked	9	67	1802	2	eked
elds	5	63	2485	2	elds
elks	8	58	2003	2	elks
ells	4	64	3135	2	ells
elms	6	73	2270	2	elms
els	3	76	4572	2	e_ls
else	4	59	2308	2	else
elves	8	51	1874	2	elves
em	4	94	4515	2	em__
embed	10	50	1429	2	embed
embeds	11	37	789	2	embeds
ember	9	55	1679	2	ember
embers	10	41	1617	2	embers
emcee	9	3	1594	2	emcee
emcees	10	3	781	2	emcees
emeer	7	48	1536	2	emeer
emeers	8	33	1418	2	emeers
emend	8	62	1489	2	emend
emends	9	57	1143	2	emends
emery	10	48	1433	2	emery
emeses	8	61	1496	2	emeses
emesis	8	47	1262	2	emesis
emic	8	64	2274	2	emic
emir	6	59	1869	2	emir
emirs	7	61	1615	2	emirs
emit	6	54	3841	2	emit
emits	7	54	2146	2	emits
emmer	9	43	1446	2	emmer
emmers	10	40	1322	2	emmers
emmet	9	42	2138	2	emmet
emmets	10	34	915	2	emmets
emmy	11	60	1324	2	emmy
emmys	12	44	602	2	emmys
emotes	8	46	2028	2	emotes
emu	5	59	2998	2	em_u
emyd	10	4	707	2	emyd
emydes	12	3	617	2	emydes
emyds	11	4	492	2	emyds
ends	5	65	2852	2	ends
engs	5	61	2139	2	engs
enmesh	11	3	489	2	enmesh
ens	3	72	4592	2	e_ns
eons	4	66	3871	2	eons
epee	6	46	2850	2	epee
epees	7	52	1983	2	epees
epos	6	67	2373	2	epos
eras	4	54	4150	2	eras
ere	3	63	5277	2	ere_
ergs	5	55	2381	2	ergs
ernes	5	52	2481	2	ernes
erns	4	54	2822	2	erns
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
ers	3	60	4628	2	e_rs
erses	5	58	2680	2	erses
es	2	90	4822	2	__es
esnes	5	48	1736	2	esnes
ess	3	60	3088	2	e_ss
esses	5	64	2297	2	esses
etas	4	64	3227	2	etas
eths	7	66	1952	2	eths
eve	6	63	3116	2	eve_
even	7	52	2227	2	even
evens	8	48	1710	2	evens
ever	7	70	2769	2	ever
ewe	6	66	3098	2	ewe_
ewer	7	75	2398	2	ewer
ewers	8	60	1882	2	ewers
exec	13	53	1394	2	exec
execs	14	53	972	2	execs
exed	12	54	2059	2	exed
eyas	7	64	2743	2	eyas
eye	6	55	3977	2	eye_
eyed	8	66	2323	2	eyed
eyen	7	62	2366	2	eyen
eyer	7	61	2728	2	eyer
eyers	8	65	2133	2	eyers
eyres	8	49	2177	2	eyres
fames	10	57	3592	2	fames
feces	10	56	2536	2	feces
fees	7	64	5060	2	fees
feme	9	61	3054	2	feme_
femmes	13	54	1021	2	femmes
fems	9	64	2870	2	fem_s
feres	8	60	3818	2	feres
fes	6	65	5167	2	_fes
fetes	8	56	3014	2	fetes
fezes	17	52	2002	2	fezes
foes	7	65	4344	2	foes
fumes	10	52	2470	2	fumes
gaes	5	63	4803	2	gaes
games	8	62	3855	2	games
gees	5	56	4788	2	gees
gems	7	53	2911	2	gem_s
genes	6	51	3309	2	genes
gies	5	56	4142	2	gies
goes	5	56	4409	2	goes
haes	7	76	5102	2	haes
hames	10	61	3870	2	hames
hebes	10	55	2167	2	hebes
heme	9	50	3441	2	heme_
hemps	12	69	1733	2	hemps
hems	9	55	3494	2	hem_s
heres	8	62	4590	2	heres
hes	6	66	5420	2	_hes
hexes	15	51	2304	2	hexes
hies	7	48	4283	2	hies
hoes	7	57	5573	2	hoes
homes	10	69	3881	2	homes
hues	7	52	3523	2	hues
ices	6	61	2964	2	ices
ides	5	77	3423	2	ides
imps	8	62	2111	2	imps
ires	4	56	3928	2	ires
jees	11	59	3854	2	jees
jefes	15	56	1367	2	jefes
jetes	12	49	2284	2	jetes
joes	11	66	3589	2	joes
kaes	8	57	3406	2	kaes
kames	11	50	2469	2	kames
kemps	13	50	1252	2	kemps
kermes	12	46	1612	2	kermes
kexes	16	62	1681	2	kexes
kues	8	64	2677	2	kues
kyes	11	51	2493	2	kyes
lames	7	54	4554	2	lames
lees	4	54	5588	2	lees
leges	6	44	2728	2	leges
lenes	5	47	3852	2	lenes
les	3	56	6307	2	_les
leses	5	49	3081	2	leses
lexes	12	72	2526	2	lexes
lies	4	64	5419	2	lies
limes	7	56	3650	2	limes
lues	4	59	4355	2	lues
lyes	7	55	3083	2	lyes
maes	6	69	4839	2	maes
mas	5	81	7581	2	_mas
me	4	77	4833	2	_me_
med	6	61	4674	2	_med
meds	7	57	3536	2	meds
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	_meg
megs	7	55	3063	2	megs
mel	5	60	4748	2	_mel
mels	6	59	4153	2	mels
mem	7	79	4347	2	_mem
meme	8	53	3055	2	meme_
memos	9	57	1911	2	memos
mems	8	59	3150	2	mems
men	5	92	5284	2	_men
meres	7	51	4357	2	meres
mesa	6	70	2548	2	_mesa
mesh	9	68	2300	2	_mesh
mess	6	59	3243	2	mess
met	5	60	7243	2	_met
metes	7	47	3621	2	metes
mew	8	61	3773	2	_mew
mews	9	66	2933	2	mews
mezes	16	77	1926	2	mezes
mimes	9	57	3202	2	mimes
mis	5	81	6261	2	_mis
momes	9	51	3447	2	momes
mos	5	70	6712	2	_mos
mus	5	59	4675	2	_mus
names	7	48	3336	2	names
neems	7	73	1629	2	neems
nemas	7	53	2157	2	nemas
nenes	5	53	2967	2	nenes
neumes	8	31	1262	2	neumes
neves	8	70	2187	2	neves
noes	4	58	4539	2	noes
nomes	7	49	3312	2	nomes
obes	6	60	3683	2	obes
odes	5	72	4324	2	odes
oes	3	58	6619	2	_oes
okes	8	49	3634	2	okes
oles	4	64	5347	2	oles
omen	6	68	2818	2	omen
omens	7	56	1896	2	omens
omer	6	70	2839	2	omer
omers	7	69	2319	2	omers
oms	5	63	3751	2	om_s
ones	4	61	4653	2	ones
opes	6	59	4261	2	opes
ores	4	60	5668	2	ores
oses	4	66	4151	2	oses
owes	7	51	3710	2	owes
oxes	11	65	3072	2	oxes
oyes	7	49	4013	2	oyes
pedes	8	53	2728	2	pedes
pees	6	52	5737	2	pees
pekes	11	46	2356	2	pekes
peles	7	57	3808	2	peles
penes	7	58	3922	2	penes
peres	7	62	4664	2	peres
pes	5	72	5978	2	_pes
pies	6	69	4960	2	pies
pomes	9	48	3393	2	pomes
pyes	9	55	2899	2	pyes
redes	6	51	3912	2	redes
rees	4	53	6419	2	rees
reges	6	56	2878	2	reges
remet	7	48	4372	2	remet
remex	14	63	1579	2	remex
rems	6	62	3772	2	rem_s
res	3	55	6504	2	_res
rexes	12	45	2695	2	rexes
rhemes	11	59	1318	2	rhemes
rimes	7	56	3454	2	rimes
roes	4	59	5413	2	roes
rues	4	60	4448	2	rues
ryes	7	55	2935	2	ryes
seems	7	55	2502	2	seems
sees	4	53	6105	2	sees
seme	6	58	3665	2	seme_
semen	7	57	2410	2	semen
semens	8	46	1696	2	semens
semis	7	46	2353	2	semis
seres	5	54	4889	2	seres
sexes	12	61	2622	2	sexes
shes	7	57	3435	2	shes
smew	9	50	1773	2	smew
smews	10	46	1229	2	smews
sues	4	62	4765	2	sues
tames	7	52	4201	2	tames
teems	7	60	1978	2	teems
tees	4	53	5358	2	tees
teles	5	45	3600	2	teles
temps	9	54	1713	2	temps
themes	11	53	1925	2	themes
ties	4	52	4831	2	ties
times	7	56	3082	2	times
toes	4	69	5644	2	toes
tomes	7	60	3738	2	tomes
tres	4	65	4290	2	tres
tyes	7	64	3337	2	tyes
ukes	8	61	2281	2	ukes
umps	8	57	2194	2	umps
uses	4	49	3111	2	uses
utes	4	59	3088	2	utes
vees	7	54	3943	2	vees
veges	9	41	1886	2	veges
vermes	11	50	1914	2	vermes
vexes	15	57	1912	2	vexes
vies	7	52	3862	2	vies
voes	7	54	3282	2	voes
waes	7	60	4860	2	waes
wames	10	64	3280	2	wames
wees	7	62	4912	2	wees
woes	7	64	4066	2	woes
wyes	10	57	2750	2	wyes
yes	6	62	5061	2	_yes
yeses	8	51	1932	2	yeses
zees	13	63	3189	2	zees
zymes	19	247	1294	2	zymes

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.080	2233637.5
2	DLD Change Limit	29872	355	0.936	31914.5
3	Display Results	355	355	0.080	4437.5
	(SQL Overall)	178691	355	1.096	163039.2