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

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

386 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
legs	5	61	3369	(None)
begs	7	57	3383	1	begs
kegs	9	58	2401	1	kegs
lags	5	65	4622	1	lags
leas	4	59	5418	1	leas
lees	4	54	5588	1	lees
leg	4	64	4611	1	leg_
leges	6	44	2728	1	leges
leis	4	57	3960	1	leis
leks	8	54	2760	1	leks
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
logs	5	73	4311	1	logs
lugs	5	52	3352	1	lugs
megs	7	55	3063	1	megs
negs	5	57	2736	1	negs
pegs	7	55	3176	1	pegs
regs	5	54	3657	1	regs
segs	5	49	3388	1	segs
tegs	5	60	3149	1	tegs
aegis	6	3	1678	2	aegis
ages	5	58	4459	2	ages
ags	4	75	5166	2	_ags
alecs	7	66	2073	2	alecs
alefs	8	73	1966	2	alefs
ales	4	70	6710	2	ale_s
bags	7	66	4550	2	bags
beds	7	59	3778	2	beds
bees	6	54	5338	2	bees
beg	6	59	4413	2	beg_
bels	6	61	4249	2	bels
bens	6	59	4570	2	bens
bergs	8	47	1804	2	bergs
bes	5	65	5743	2	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bigs	7	62	3502	2	bigs
blebs	9	64	1615	2	blebs
bless	7	59	1781	2	bless
blets	7	53	2494	2	blets
blogs	8	53	1923	2	blogs
bogs	7	57	4275	2	bogs
bugs	7	60	3591	2	bugs
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cigs	7	56	2510	2	cigs
clags	8	56	2112	2	clags
clefs	10	66	1624	2	clefs
clews	10	55	1633	2	clews
clogs	8	55	1955	2	clogs
cogs	7	73	4003	2	cogs
dags	6	66	4259	2	dags
debs	7	65	3024	2	debs
dees	5	63	5663	2	dees
degas	7	51	1916	2	degas
dels	5	67	4547	2	dels
dens	5	59	4507	2	dens
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
digs	6	60	3605	2	digs
dogs	6	64	4015	2	dogs
dregs	7	61	1486	2	dregs
dugs	6	148	3228	2	dugs
eds	4	66	3892	2	_eds
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
egg	5	69	1867	2	_egg
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	_egis
ego	4	67	2605	2	_ego
egos	5	58	2165	2	_egos
elds	5	63	2485	2	elds
elegy	9	3	930	2	elegy
elks	8	58	2003	2	elks
ells	4	64	3135	2	ells
elms	6	73	2270	2	elms
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
engs	5	61	2139	2	engs
ens	3	72	4592	2	_ens
ergs	5	55	2381	2	ergs
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
ess	3	60	3088	2	_ess
fags	8	69	3912	2	fags
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
figs	8	53	3264	2	figs
flags	9	53	2128	2	flags
fleas	8	64	2366	2	fleas
flees	8	58	2875	2	flees
flews	11	53	1644	2	flews
fleys	11	70	1560	2	fleys
flogs	9	59	1996	2	flogs
fogs	8	70	3500	2	fogs
fugs	8	57	3069	2	fugs
gags	6	64	4106	2	gags
geds	6	67	3081	2	geds
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
gigs	6	66	3118	2	gigs
gleds	7	54	1789	2	gleds
glees	6	50	2759	2	glees
gleg	6	62	1980	2	gleg_
glens	6	65	1985	2	glens
gleys	9	65	1485	2	gleys
glugs	7	52	1428	2	glugs
hags	8	67	4084	2	hags
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
hogs	8	71	3966	2	hogs
hugs	8	61	2975	2	hugs
iggs	6	66	1267	2	iggs
ileus	5	46	1689	2	ileus
jags	12	61	3279	2	jags
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
jigs	12	65	2476	2	jigs
jogs	12	71	2933	2	jogs
jugs	12	55	2560	2	jugs
keas	8	63	3709	2	keas
kefs	11	59	2274	2	kefs
keg	8	64	3253	2	keg_
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	2	keys
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lag	4	78	6212	2	lag_
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
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
leaks	9	59	2391	2	leaks
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
ledge	7	65	1946	2	ledge
ledges	8	49	1798	2	ledges
ledgy	10	57	1201	2	ledgy
lee	3	60	6814	2	le_e
leek	8	53	3173	2	leek
leeks	9	53	1889	2	leeks
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
legal	6	57	1594	2	legal
legals	7	34	1273	2	legals
leger	6	57	2150	2	leger
legers	7	45	1831	2	legers
leggy	10	52	1024	2	leggy
legist	7	13	1525	2	legist
legit	6	13	2350	2	legit
legits	7	13	1300	2	legits
lehr	7	55	1494	2	lehr
lehrs	8	61	1113	2	lehrs
lei	3	68	4638	2	le_i
lek	7	56	4030	2	le_k
leke	8	55	2740	2	leke
leku	8	65	1991	2	leku
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
lids	5	63	3645	2	lids
liege	6	53	1443	2	liege
lieges	7	41	1344	2	lieges
liens	5	65	2550	2	liens
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieus	5	62	1848	2	lieus
lings	6	71	3577	2	lings
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
loess	5	57	1470	2	loess
log	4	62	5268	2	log_
loge	5	68	3719	2	loge
loges	6	65	3420	2	loges
logo	5	79	3176	2	logo
logos	6	72	2533	2	logos
logy	8	70	2578	2	logy
longs	6	55	2706	2	longs
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
lues	4	59	4355	2	lues
lug	4	61	3806	2	lug_
luge	5	55	3164	2	luge
luges	6	59	2875	2	luges
lums	6	57	3424	2	lums
lungs	6	52	2388	2	lungs
luvs	7	58	1850	2	luvs
lweis	8	45	869	2	lweis
lyes	7	55	3083	2	lyes
mags	7	54	4452	2	mags
meds	7	57	3536	2	meds
meg	6	60	4095	2	meg_
mega	7	76	2087	2	mega
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
migs	7	69	3532	2	migs
mogs	7	54	3933	2	mogs
mugs	7	62	3204	2	mugs
nags	5	54	3602	2	nags
nebs	6	61	2498	2	nebs
neg	4	72	3734	2	neg_
negus	6	45	1356	2	negus
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
nogs	5	65	3461	2	nogs
oes	3	58	6619	2	oe_s
oleos	5	54	1968	2	oleos
oles	4	64	5347	2	ole_s
peags	8	61	2284	2	peags
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
pees	6	52	5737	2	pees
peg	6	58	4306	2	peg_
pehs	9	56	2576	2	pehs
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pe_s
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
pigs	7	66	3422	2	pigs
pleas	7	56	2703	2	pleas
plebs	9	58	1458	2	plebs
plews	10	54	1535	2	plews
plugs	8	52	1349	2	plugs
pugs	7	63	3277	2	pugs
rags	5	54	4837	2	rags
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
reg	4	61	4649	2	reg_
reges	6	56	2878	2	reges
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
rigs	5	51	3759	2	rigs
rugs	5	60	3368	2	rugs
sags	5	59	4840	2	sags
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
sees	4	53	6105	2	sees
seg	4	55	4488	2	seg_
sego	5	65	2518	2	sego
segos	6	49	1948	2	segos
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
skegs	10	50	1123	2	skegs
slags	6	65	2590	2	slags
sleds	6	44	1885	2	sleds
slews	8	62	2035	2	slews
slogs	6	45	2184	2	slogs
slugs	6	46	1856	2	slugs
tags	5	55	4523	2	tags
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
teg	4	57	4162	2	teg_
tegg	6	53	1592	2	tegg
teggs	7	47	1074	2	teggs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
tets	4	58	4745	2	tets
tews	7	64	3164	2	tews
togs	5	72	4243	2	togs
tugs	5	62	3167	2	tugs
vees	7	54	3943	2	vees
veg	7	69	3106	2	veg_
veges	9	41	1886	2	veges
vets	7	68	3509	2	vets
vigs	8	54	2727	2	vigs
vugs	8	70	2287	2	vugs
wags	8	61	4055	2	wags
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
wigs	8	49	3125	2	wigs
wogs	8	65	3140	2	wogs
yags	8	66	3229	2	yags
yeas	7	86	3842	2	yeas
yegg	9	65	1179	2	yegg
yeggs	10	60	816	2	yeggs
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
zags	14	68	2668	2	zags
zeds	14	58	2180	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps
zigs	14	54	2279	2	zigs

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.140	1276364.3
2	DLD Change Limit	29872	386	1.720	17367.4
3	Display Results	386	386	0.093	4150.5
	(SQL Overall)	178691	386	1.953	91495.6