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

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

331 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
lean	4	63	4524	(None)
bean	6	64	4386	1	bean
clean	7	54	2041	1	clean
dean	5	60	3948	1	dean
elan	4	67	3424	1	elan
glean	6	58	1820	1	glean
jean	11	66	2928	1	jean
lea	3	76	6018	1	lea_
lead	5	60	3885	1	lead
leaf	7	64	4103	1	leaf
leak	8	62	3371	1	leak
leal	4	60	4327	1	leal
leans	5	55	3625	1	leans
leant	5	67	3778	1	leant
leap	6	60	3268	1	leap
lear	4	70	4595	1	lear
learn	5	53	2266	1	learn
leas	4	59	5418	1	leas
leman	7	56	2260	1	leman
loan	4	74	3645	1	loan
mean	6	55	3808	1	mean
pean	6	61	4717	1	pean
wean	7	57	3435	1	wean
yean	7	58	3458	1	yean
aeon	4	56	3461	2	aeon
alan	4	68	4408	2	alan
an	2	118	7907	2	__an
azan	13	65	2178	2	azan
ban	5	83	6683	2	_ban
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
beano	7	54	2155	2	beano
beans	7	57	3469	2	beans
bear	6	68	4464	2	bear
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
been	6	53	3578	2	been
began	8	63	1957	2	began
ben	5	65	5492	2	be_n
bleak	11	59	1538	2	bleak
blear	7	59	1868	2	blear
bleat	7	57	3700	2	bleat
bran	6	57	4038	2	bran
can	5	77	6013	2	_can
clan	6	56	3392	2	clan
cleans	8	58	1705	2	cleans
clear	7	62	1905	2	clear
cleat	7	63	3506	2	cleat
cyan	9	64	1962	2	cyan
dan	4	68	5966	2	_dan
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear
den	4	75	5434	2	de_n
dewan	9	57	1804	2	dewan
ear	3	68	6788	2	_ear
earn	4	67	3755	2	_earn
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
elain	5	53	2470	2	elain
eland	6	58	2039	2	eland
elans	5	55	2775	2	elans
en	2	80	5239	2	_e_n
eon	3	60	5208	2	_eon
ern	3	57	3835	2	_ern
fan	6	71	5885	2	_fan
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fen	6	68	5135	2	fe_n
fern	7	61	2932	2	fern
flan	7	61	3418	2	flan
flea	7	56	2849	2	flea_
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
gaen	5	73	2960	2	gaen
gan	4	80	6012	2	_gan
gear	5	59	3497	2	gear
gen	4	59	5051	2	ge_n
gleam	8	69	1673	2	gleam
gleans	7	50	1474	2	gleans
glen	5	60	2720	2	gle_n
gran	5	63	3501	2	gran
guan	5	53	2558	2	guan
haen	7	62	2945	2	haen
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heat	7	70	6142	2	heat
hen	6	75	5527	2	he_n
hern	7	61	3489	2	hern
hewn	10	67	1985	2	hewn
hwan	10	57	1689	2	hwan
ilea	4	59	3146	2	ilea_
ileac	7	58	1417	2	ileac
ileal	5	61	1808	2	ileal
jeans	12	60	2211	2	jeans
jeon	11	68	2144	2	jeon
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
keen	8	48	3040	2	keen
ken	7	63	4398	2	ke_n
kern	8	53	2621	2	kern
khan	11	58	1914	2	khan
koan	8	54	2503	2	koan
la	2	192	6163	2	l_a_
lab	5	88	6478	2	l_ab
lac	5	101	5582	2	l_ac
lad	4	81	6570	2	l_ad
lag	4	78	6212	2	l_ag
lagan	6	65	2034	2	lagan
lain	4	61	4628	2	lain
lam	5	76	6671	2	l_am
land	5	63	3730	2	l_and
lane	4	51	5332	2	l_ane
lang	5	66	3737	2	l_ang
lank	8	47	3444	2	l_ank
lap	5	85	6527	2	l_ap
lar	3	79	6753	2	l_ar
las	3	72	8147	2	l_as
lat	3	75	9340	2	l_at
lauan	5	52	1679	2	lauan
lav	6	68	4734	2	l_av
law	6	86	5664	2	l_aw
lawn	7	59	2563	2	lawn
lax	10	76	5152	2	l_ax
lay	6	88	6535	2	l_ay
leach	10	54	2252	2	leach
leaden	7	45	1522	2	leaden
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
leafs	8	57	2118	2	leafs
leafy	11	63	1621	2	leafy
leaks	9	59	2391	2	leaks
leaky	12	52	1772	2	leaky
leaned	7	34	2254	2	leaned
leaner	6	40	2219	2	leaner
leanly	9	38	1150	2	leanly
leaps	7	55	2293	2	leaps
leapt	7	50	2747	2	leapt
learns	6	55	1374	2	learns
learnt	6	40	1925	2	learnt
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
lease	5	52	3026	2	lease
leash	8	55	1921	2	leash
least	5	61	3488	2	least
leave	8	47	2372	2	leave
leaven	9	50	1307	2	leaven
leavy	11	57	1577	2	leavy
leben	7	3	1485	2	leben
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
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
left	7	63	4048	2	left
leg	4	64	4611	2	le_g
legal	6	57	1594	2	legal
legman	9	4	965	2	legman
legs	5	61	3369	2	legs
lehr	7	55	1494	2	lehr
lei	3	68	4638	2	le_i
leis	4	57	3960	2	leis
lek	7	56	4030	2	le_k
leke	8	55	2740	2	leke
leks	8	54	2760	2	leks
leku	8	65	1991	2	leku
lemans	8	53	1639	2	lemans
lemon	7	56	1818	2	lemon
lend	5	62	3367	2	lend
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lent	4	63	6053	2	lent
leone	5	50	1882	2	leone
lept	6	64	4088	2	lept
les	3	56	6307	2	le_s
less	4	56	3510	2	less
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
lets	4	71	4794	2	lets
leu	3	60	4740	2	le_u
leud	5	72	2342	2	leud
lev	6	61	3942	2	le_v
leva	7	70	2071	2	leva
levant	9	3	1449	2	levant
levin	8	48	1641	2	levin
levo	7	68	2006	2	levo
levy	10	64	1850	2	levy
lewd	8	57	1659	2	lewd
lex	10	79	4382	2	le_x
ley	6	62	4681	2	le_y
leys	7	64	3018	2	leys
lez	12	55	4131	2	le_z
liana	5	39	1589	2	liana
liane	5	47	2066	2	liane
liang	6	49	1441	2	liang
liar	4	72	2968	2	liar
lien	4	53	3980	2	lien
ligan	6	79	2028	2	ligan
liman	7	59	2160	2	liman
limn	6	65	2769	2	limn
lin	3	79	6737	2	l_in
linn	4	60	3459	2	linn
lion	4	63	3444	2	lion
llano	5	9	1060	2	llano
load	5	67	3060	2	load
loaf	7	67	3490	2	loaf
loam	6	56	3048	2	loam
loans	5	60	2646	2	loans
logan	6	81	2328	2	logan
loin	4	68	3872	2	loin
loon	4	73	4479	2	loon
loran	5	59	2509	2	loran
lorn	4	64	3525	2	lorn
lown	7	69	2929	2	lown
luau	4	48	2416	2	luau
luna	4	62	2985	2	luna
man	5	74	6585	2	_man
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
means	7	58	3122	2	means
meant	7	65	3720	2	meant
meany	10	46	2047	2	meany
meat	6	63	5960	2	meat
men	5	92	5284	2	me_n
moan	6	58	3201	2	moan
naan	4	76	2193	2	naan
nan	3	78	5487	2	_nan
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
neon	4	70	2642	2	neon
ocean	7	12	1296	2	ocean
olea	4	65	3272	2	olea_
olein	5	3	1600	2	olein
paean	7	72	2272	2	paean
pan	5	84	6644	2	_pan
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
peans	7	54	3764	2	peans
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
pecan	9	19	1903	2	pecan
peen	6	59	3808	2	peen
pein	6	58	3494	2	pein
pekan	11	16	1397	2	pekan
pen	5	65	5884	2	pe_n
peon	6	56	3524	2	peon
pian	6	61	3609	2	pian
plan	6	58	3394	2	plan
plea	6	68	3060	2	plea_
plead	8	58	1846	2	plead
pleas	7	56	2703	2	pleas
pleat	7	47	3447	2	pleat
plena	7	58	1639	2	plena
pleon	7	42	1638	2	pleon
quean	14	36	1284	2	quean
ran	3	82	6661	2	_ran
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
redan	6	61	2501	2	redan
rein	4	60	4089	2	rein
reman	7	57	3015	2	reman
reran	5	73	2910	2	reran
rewan	8	56	2366	2	rewan
roan	4	72	3420	2	roan
scan	6	55	3045	2	scan
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
sedan	6	56	2042	2	sedan
seen	4	69	4312	2	seen
sen	3	60	5852	2	se_n
sewan	8	59	2129	2	sewan
sewn	7	61	2433	2	sewn
skean	9	44	1562	2	skean
span	6	52	3466	2	span
spean	7	46	2051	2	spean
swan	7	66	3131	2	swan
tan	3	71	6756	2	_tan
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
teen	4	59	3820	2	teen
ten	3	58	5611	2	te_n
tern	4	61	3480	2	tern
than	7	61	2877	2	than
ulan	4	65	2739	2	ulan
ulpan	7	3	1012	2	ulpan
van	6	62	4632	2	_van
veal	7	69	3681	2	veal
vegan	9	51	1415	2	vegan
vein	7	56	2575	2	vein
vena	7	61	2629	2	vena
wan	6	67	6193	2	_wan
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear
ween	7	58	3546	2	ween
wen	6	62	4960	2	we_n
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year
yearn	8	63	1643	2	yearn
yeas	7	86	3842	2	yeas
yen	6	68	4738	2	ye_n
yuan	7	61	2001	2	yuan
zeal	13	55	3033	2	zeal
zein	13	56	2060	2	zein

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.063	2836365.1
2	DLD Change Limit	29872	331	1.546	19322.1
3	Display Results	331	331	0.156	2121.8
	(SQL Overall)	178691	331	1.765	101241.4