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

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

349 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
leks	8	54	2760	(None)
elks	8	58	2003	1	elks
leaks	9	59	2391	1	leaks
leas	4	59	5418	1	leas
leeks	9	53	1889	1	leeks
lees	4	54	5588	1	lees
legs	5	61	3369	1	legs
leis	4	57	3960	1	leis
lek	7	56	4030	1	lek_
leke	8	55	2740	1	leke
leku	8	65	1991	1	leku
lens	4	61	4649	1	lens
les	3	56	6307	1	le_s
less	4	56	3510	1	less
lets	4	71	4794	1	lets
leys	7	64	3018	1	leys
zeks	17	58	1506	1	zeks
alecs	7	66	2073	2	alecs
alefs	8	73	1966	2	alefs
ales	4	70	6710	2	ale_s
arks	8	59	3687	2	arks
asks	8	57	2121	2	asks
auks	8	55	2526	2	auks
beaks	11	53	2662	2	beaks
becks	13	55	2201	2	becks
beds	7	59	3778	2	beds
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bens	6	59	4570	2	bens
berks	11	54	2312	2	berks
bes	5	65	5743	2	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bleaks	12	51	1243	2	bleaks
blebs	9	64	1615	2	blebs
bless	7	59	1781	2	bless
blets	7	53	2494	2	blets
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cleeks	12	50	1054	2	cleeks
clefs	10	66	1624	2	clefs
clerks	12	45	884	2	clerks
clews	10	55	1633	2	clews
daks	9	71	3060	2	daks
debs	7	65	3024	2	debs
decks	12	48	2219	2	decks
dees	5	63	5663	2	dees
deke	9	52	2876	2	deke
dekes	10	52	2445	2	dekes
dels	5	67	4547	2	dels
dens	5	59	4507	2	dens
desk	9	56	1890	2	desk
desks	10	59	1307	2	desks
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
dreks	10	57	1475	2	dreks
eds	4	66	3892	2	_eds
eek	7	79	3510	2	eek_
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
eke	7	56	3009	2	_eke
ekes	8	67	2660	2	_ekes
elds	5	63	2485	2	elds
elk	7	67	2612	2	elk_
ells	4	64	3135	2	ells
elms	6	73	2270	2	elms
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
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
fecks	14	54	1785	2	fecks
feds	8	52	3431	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
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
fleas	8	64	2366	2	fleas
flecks	15	43	1080	2	flecks
flees	8	58	2875	2	flees
flews	11	53	1644	2	flews
fleys	11	70	1560	2	fleys
gecks	12	51	1709	2	gecks
geds	6	67	3081	2	geds
geeks	10	49	1584	2	geeks
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gems	7	53	2911	2	gems
gens	5	57	4007	2	gens
gets	5	54	4248	2	gets
gleds	7	54	1789	2	gleds
gleeks	11	48	967	2	gleeks
glees	6	50	2759	2	glees
glens	6	65	1985	2	glens
gleys	9	65	1485	2	gleys
hecks	14	52	2065	2	hecks
hehs	10	67	2396	2	hehs
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
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
ileus	5	46	1689	2	ileus
ilks	8	72	1857	2	ilks
inks	8	69	2650	2	inks
irks	8	62	2013	2	irks
jees	11	59	3854	2	jees
jerks	16	65	1489	2	jerks
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
keas	8	63	3709	2	keas
kecks	10	54	1657	2	kecks
keeks	8	47	1725	2	keeks
kefs	11	59	2274	2	kefs
kegs	9	58	2402	2	kegs
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	2	keys
kliks	8	39	882	2	kliks
labs	6	71	4512	2	labs
lacks	11	61	2920	2	lacks
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lake	8	57	4160	2	lake
lakes	9	57	3765	2	lakes
lakh	11	49	1995	2	lakh
lakhs	12	52	1034	2	lakhs
laky	11	67	2582	2	laky
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
larks	9	52	2781	2	larks
lars	4	69	5657	2	lars
las	3	72	8147	2	l_as
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
lea	3	76	6018	2	le_a
lead	5	60	3885	2	lead
leads	6	60	2849	2	leads
leaf	7	64	4103	2	leaf
leafs	8	57	2118	2	leafs
leak	8	62	3371	2	leak
leaky	12	52	1772	2	leaky
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leans	5	55	3625	2	leans
leap	6	60	3268	2	leap
leaps	7	55	2293	2	leaps
lear	4	70	4595	2	lear
lears	5	59	3873	2	lears
lease	5	52	3026	2	lease
leash	8	55	1921	2	leash
least	5	61	3488	2	least
lech	9	68	2544	2	lech
led	4	62	5455	2	le_d
lee	3	60	6814	2	le_e
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
leers	5	48	2898	2	leers
leet	4	59	5790	2	leet
leets	5	49	2712	2	leets
left	7	63	4048	2	left
lefts	8	65	1781	2	lefts
leg	4	64	4611	2	le_g
leges	6	44	2729	2	leges
lehr	7	55	1494	2	lehr
lehrs	8	61	1113	2	lehrs
lei	3	68	4638	2	le_i
lend	5	62	3367	2	lend
lends	6	53	2625	2	lends
lenes	5	47	3852	2	lenes
lenis	5	63	2686	2	lenis
leno	4	73	3139	2	leno
lenos	5	60	2486	2	lenos
lense	5	45	2343	2	lense
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
leses	5	49	3081	2	leses
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
leu	3	60	4740	2	le_u
leud	5	72	2342	2	leud
leuds	6	62	1481	2	leuds
lev	6	61	3942	2	le_v
leva	7	70	2071	2	leva
levis	8	58	1855	2	levis
levo	7	68	2006	2	levo
levy	10	64	1850	2	levy
lewd	8	57	1659	2	lewd
lewis	8	53	1584	2	lewis
lex	10	79	4382	2	le_x
lexes	12	72	2526	2	lexes
lexis	12	59	1603	2	lexis
ley	6	62	4681	2	le_y
lez	12	55	4131	2	le_z
libs	6	67	3276	2	libs
licks	11	53	2539	2	licks
lids	5	63	3646	2	lids
liens	5	65	2550	2	liens
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieus	5	62	1848	2	lieus
like	8	60	4084	2	like
likes	9	62	3190	2	likes
links	9	64	3019	2	links
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	l_is
lits	4	62	5249	2	lits
lobs	6	64	4108	2	lobs
locks	11	51	2692	2	locks
loess	5	57	1470	2	loess
logs	5	73	4311	2	logs
looks	9	51	2486	2	looks
loos	4	90	5112	2	loos
lops	6	60	4335	2	lops
loss	4	53	3796	2	loss
lots	4	76	5209	2	lots
lows	7	58	4301	2	lows
lucks	11	57	2356	2	lucks
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lums	6	57	3424	2	lums
lunks	9	48	2245	2	lunks
lurks	9	52	1874	2	lurks
luvs	7	58	1850	2	luvs
lweis	8	45	869	2	lweis
lyes	7	55	3083	2	lyes
meds	7	57	3536	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
merks	11	47	2240	2	merks
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
nebs	6	61	2498	2	nebs
necks	11	51	1933	2	necks
negs	5	57	2736	2	negs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
neuks	9	65	1086	2	neuks
news	7	61	2737	2	news
oaks	8	65	2790	2	oaks
oes	3	58	6619	2	oe_s
okes	8	49	3634	2	okes
oleos	5	54	1968	2	oleos
oles	4	64	5347	2	ole_s
peaks	11	48	2562	2	peaks
peas	6	57	5506	2	peas
pecks	13	57	2443	2	pecks
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
peeks	11	50	2111	2	peeks
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
peke	10	59	2620	2	peke
pekes	11	46	2356	2	pekes
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
perks	11	53	2580	2	perks
pes	5	72	5978	2	pe_s
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
pleas	7	56	2703	2	pleas
plebs	9	58	1458	2	plebs
plews	10	54	1535	2	plews
rebs	6	57	3356	2	rebs
recks	11	56	2513	2	recks
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
reeks	9	41	2403	2	reeks
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
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
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seeks	9	47	2464	2	seeks
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sleds	6	44	1885	2	sleds
sleeks	10	45	1246	2	sleeks
slews	8	62	2035	2	slews
suks	8	59	2712	2	suks
teaks	9	42	2290	2	teaks
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
tets	4	58	4746	2	tets
tews	7	64	3164	2	tews
treks	9	60	1685	2	treks
tsks	8	64	1066	2	tsks
ukes	8	61	2281	2	ukes
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
webs	9	66	2212	2	webs
weds	8	66	2893	2	weds
weeks	12	50	1786	2	weeks
wees	7	62	4912	2	wees
weka	11	70	1387	2	weka
wekas	12	39	1179	2	wekas
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
woks	11	62	2490	2	woks
yaks	11	60	2520	2	yaks
yeas	7	86	3842	2	yeas
yelks	12	64	1362	2	yelks
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yerks	12	54	1656	2	yerks
yes	6	62	5061	2	ye_s
yeuks	12	51	1009	2	yeuks
yews	10	53	2396	2	yews
ylems	10	3	926	2	ylems
yoks	11	62	2374	2	yoks
yuks	11	64	1802	2	yuks
zeds	14	58	2180	2	zeds
zees	13	63	3189	2	zees
zek	16	73	2316	2	zek_
zeps	15	60	1934	2	zeps
zerks	18	51	1382	2	zerks

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.283	631417.0
2	DLD Change Limit	29872	349	0.860	34734.9
3	Display Results	349	349	0.093	3752.7
	(SQL Overall)	178691	349	1.236	144572.0