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

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

294 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
eke	7	56	3009	(None)
deke	9	52	2876	1	deke
eek	7	79	3510	1	eek
eked	9	67	1802	1	eked
ekes	8	67	2660	1	ekes
eme	5	58	3718	1	eme
ere	3	63	5277	1	ere
eve	6	63	3116	1	eve
ewe	6	66	3098	1	ewe
eye	6	55	3977	1	eye
leke	8	55	2740	1	leke
oke	7	58	3948	1	oke
peke	10	59	2620	1	peke
uke	7	57	2729	1	uke
ace	5	96	5683	2	ace
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
akee	8	59	3681	2	akee
ale	3	65	7234	2	ale
ane	3	78	6694	2	ane
ape	5	72	5118	2	ape
are	3	78	7457	2	are
ate	3	70	5924	2	ate
ave	6	77	4870	2	ave
awe	6	77	4662	2	awe
axe	10	82	3949	2	axe
aye	6	71	5176	2	aye
bake	10	56	3751	2	bake
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bene	6	64	3949	2	bene
bike	10	65	3259	2	bike
bye	8	61	3459	2	bye
cake	10	54	3996	2	cake
cede	7	49	2876	2	cede
cee	5	59	5270	2	cee
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
coke	10	70	3838	2	coke
cue	5	75	4418	2	cue
cuke	10	58	2498	2	cuke
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
dene	5	66	4341	2	dene
dere	5	68	4590	2	dere
die	4	67	5965	2	die
dike	9	59	3576	2	dike
doe	4	73	6195	2	doe
due	4	52	4986	2	due
duke	9	56	2810	2	duke
dye	7	53	3484	2	dye
dyke	12	64	1818	2	dyke
ear	3	68	6788	2	ear
ease	4	50	4233	2	ease
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
eave	7	57	3358	2	eave
ebb	7	24	1862	2	ebb
eche	9	75	2028	2	eche
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edge	6	57	1966	2	edge
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eel	3	79	4684	2	eel
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
eger	5	59	2356	2	eger
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eide	5	58	3223	2	eide
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
elks	8	58	2003	2	elks
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
else	4	59	2308	2	else
em	4	94	4515	2	e_m
emes	6	54	3466	2	emes
emeu	6	67	2343	2	emeu
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
en	2	80	5239	2	e_n
end	4	68	3435	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon
epee	6	46	2850	2	epee
er	2	83	4514	2	e_r
era	3	57	4150	2	era
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
erne	4	67	2742	2	erne
err	3	56	2653	2	err
ers	3	60	4628	2	ers
es	2	90	4822	2	e_s
eses	4	53	3610	2	eses
esker	9	44	1298	2	esker
esne	4	70	1879	2	esne
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
even	7	52	2227	2	even
ever	7	70	2769	2	ever
eves	7	62	3046	2	eves
evoke	12	47	885	2	evoke
ewer	7	75	2398	2	ewer
ewes	7	63	2870	2	ewes
ex	9	88	3564	2	e_x
exec	13	53	1394	2	exec
exed	12	54	2059	2	exed
exes	11	65	3081	2	exes
eyed	8	66	2323	2	eyed
eyen	7	62	2366	2	eyen
eyer	7	61	2728	2	eyer
eyes	7	58	3788	2	eyes
eyne	7	63	2246	2	eyne
eyre	7	55	2525	2	eyre
fake	11	55	3494	2	fake
fe	5	79	4474	2	_fe
fee	6	68	6201	2	fee
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
fyke	14	59	1529	2	fyke
gae	4	64	5770	2	gae
gee	4	53	5920	2	gee
geek	9	53	2702	2	geek
gene	5	62	3722	2	gene
gie	4	71	4954	2	gie
hae	6	73	6400	2	hae
hake	11	56	3784	2	hake
he	5	81	5195	2	_he
hebe	9	64	2470	2	hebe
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hie	6	76	5270	2	hie
hike	11	68	3039	2	hike
hoe	6	75	6272	2	hoe
hoke	11	59	3593	2	hoke
hue	6	66	4230	2	hue
ice	5	67	3724	2	ice
ire	3	69	4317	2	ire
jake	15	59	2577	2	jake
jee	10	66	4864	2	jee
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
joe	10	66	4235	2	joe
joke	15	59	2616	2	joke
juke	15	47	2166	2	juke
ka	6	91	4508	2	_ka
kae	7	67	4454	2	kae
kea	7	65	4091	2	kea
keef	11	58	2999	2	keef
keek	7	56	2496	2	keek
keel	8	57	2946	2	keel
keen	8	48	3040	2	keen
keep	10	63	2981	2	keep
keet	8	53	4733	2	keet
kef	10	56	3966	2	kef
keg	8	64	3253	2	keg
ken	7	63	4398	2	ken
kep	9	64	3720	2	kep
kex	14	60	2958	2	kex
key	10	58	3333	2	key
ki	6	75	3795	2	_ki
kike	7	65	2478	2	kike
kue	7	66	3186	2	kue
kye	10	73	2727	2	kye
lake	8	57	4160	2	lake
lee	3	60	6814	2	lee
leek	8	53	3173	2	leek
lek	7	56	4030	2	lek_
leks	8	54	2760	2	leks
leku	8	65	1991	2	leku
lie	3	82	6452	2	lie
like	8	60	4084	2	like
lye	6	65	3341	2	lye
mae	5	76	5910	2	mae
make	10	55	3788	2	make
me	4	77	4833	2	_me
meek	10	56	2483	2	meek
meme	8	53	3055	2	meme
mere	6	72	4444	2	mere
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mike	10	55	3528	2	mike
moke	10	62	3422	2	moke
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
nene	4	59	3206	2	nene
neve	7	62	2483	2	neve
nuke	8	59	2075	2	nuke
obe	5	66	3864	2	obe
ode	4	74	4658	2	ode
oe	2	84	7306	2	_oe
oka	7	69	2680	2	oka
okeh	11	46	1532	2	okeh
okes	8	49	3634	2	okes
ole	3	71	5521	2	ole
one	3	70	5091	2	one
ope	5	68	4524	2	ope
ore	3	66	6183	2	ore
ose	3	81	4734	2	ose
owe	6	70	4103	2	owe
pe	4	76	4903	2	_pe
pee	5	60	6651	2	pee
peek	10	60	3143	2	peek
pekes	11	46	2356	2	pekes
pekoe	11	46	1236	2	pekoe
pele	6	55	3955	2	pele
pere	6	64	5026	2	pere
pie	5	54	5740	2	pie
pike	10	63	3521	2	pike
poke	10	53	3536	2	poke
puke	10	50	2546	2	puke
pye	8	64	3250	2	pye
rake	8	48	4157	2	rake
re	2	61	5374	2	_re
rede	5	50	3766	2	rede
ree	3	79	7407	2	ree
reek	8	52	3252	2	reek
rekey	12	40	1473	2	rekey
rete	4	49	4413	2	rete
roe	3	68	6107	2	roe
rue	3	55	4926	2	rue
rye	6	60	3254	2	rye
ryke	11	56	1640	2	ryke
sae	3	83	6518	2	sae
sake	8	52	4496	2	sake
see	3	57	7226	2	see
seek	8	59	3548	2	seek
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
she	6	68	3769	2	she
sike	8	71	3878	2	sike
ska	7	69	2586	2	ska
skee	8	54	3147	2	skee
skeg	9	53	1616	2	skeg
skep	10	52	1935	2	skep
skew	11	62	1876	2	skew
ski	7	49	2568	2	ski
sky	10	64	2099	2	sky
soke	8	54	3626	2	soke
sue	3	56	5146	2	sue
syke	11	54	2056	2	syke
tae	3	82	6705	2	tae
take	8	47	3926	2	take
tee	3	83	6687	2	tee
tele	4	50	4087	2	tele
the	6	74	3605	2	the
tie	3	65	5753	2	tie
tike	8	55	3448	2	tike
toe	3	101	6685	2	toe
toke	8	67	3849	2	toke
tye	6	58	3744	2	tye
tyke	11	57	2050	2	tyke
ukes	8	61	2281	2	ukes
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vee	6	57	5018	2	vee
vie	6	54	4763	2	vie
voe	6	77	3905	2	voe
wae	6	75	5695	2	wae
wake	11	49	3570	2	wake
we	5	70	4345	2	_we
wee	6	67	6081	2	wee
week	11	64	2815	2	week
weka	11	70	1387	2	weka
were	7	62	3833	2	were
woe	6	66	5124	2	woe
woke	11	55	2796	2	woke
wye	9	63	3197	2	wye
ye	5	76	5006	2	_ye
yoke	11	56	2639	2	yoke
zee	12	61	4323	2	zee
zek	16	73	2316	2	zek_
zeks	17	58	1506	2	zeks

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	294	0.373	37758.7
3	Display Results	294	294	0.063	4666.7
	(SQL Overall)	178691	294	0.499	358098.2