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

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

319 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
lear	4	70	4595	(None)
bear	6	68	4464	1	bear
blear	7	59	1868	1	blear
clear	7	62	1905	1	clear
dear	5	53	4360	1	dear
ear	3	68	6788	1	_ear
fear	7	53	3779	1	fear
gear	5	59	3497	1	gear
hear	7	61	4388	1	hear
lar	3	79	6753	1	l_ar
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
lean	4	63	4524	1	lean
leap	6	60	3268	1	leap
learn	5	53	2266	1	learn
lears	5	59	3873	1	lears
leary	8	59	2738	1	leary
leas	4	59	5418	1	leas
leer	4	62	3935	1	leer
lehr	7	55	1494	1	lehr
liar	4	72	2968	1	liar
near	4	52	3650	1	near
pear	6	97	4523	1	pear
rear	4	56	4455	1	rear
sear	4	73	5384	1	sear
tear	4	52	4288	1	tear
wear	7	58	3672	1	wear
year	7	65	3425	1	year
afar	7	67	2078	2	afar
agar	5	87	2641	2	agar
ajar	11	62	1770	2	ajar
alar	4	63	4007	2	alar
alegar	7	3	928	2	alegar
altar	5	55	2064	2	altar
anear	5	54	2032	2	anear
ar	2	113	7938	2	__ar
bar	5	80	7055	2	_bar
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
beer	6	56	3599	2	beer
bleak	11	59	1538	2	bleak
blears	8	51	1645	2	blears
bleary	11	51	1255	2	bleary
bleat	7	57	3700	2	bleat
boar	6	61	3429	2	boar
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
clean	7	54	2041	2	clean
clears	8	41	1656	2	clears
cleat	7	63	3506	2	cleat
czar	15	60	1313	2	czar
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
debar	8	55	1786	2	debar
deer	5	67	3902	2	deer
denar	6	52	2329	2	denar
dewar	9	58	1773	2	dewar
drear	6	50	1690	2	drear
earl	4	58	3814	2	_earl
earn	4	67	3755	2	_earn
ears	4	63	5659	2	_ears
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
elan	4	67	3424	2	elan
er	2	83	4514	2	_e_r
era	3	57	4150	2	_era
err	3	56	2653	2	_err
far	6	77	6260	2	_far
feal	7	139	4042	2	feal
fears	8	48	2939	2	fears
feat	7	64	5822	2	feat
fer	6	66	4612	2	fe_r
feuar	8	3	1024	2	feuar
fiar	7	64	2733	2	fiar
flea	7	56	2849	2	flea_
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
fleer	8	60	2077	2	fleer
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
gleam	8	69	1673	2	gleam
glean	6	58	1820	2	glean
gnar	5	60	2138	2	gnar
guar	5	69	2329	2	guar
haar	7	73	2349	2	haar
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
heard	9	52	2275	2	heard
hears	8	67	3737	2	hears
heart	8	54	4074	2	heart
heat	7	70	6142	2	heat
heir	7	75	2380	2	heir
her	6	65	4781	2	he_r
hoar	7	67	2916	2	hoar
ilea	4	59	3146	2	ilea_
ileac	7	58	1417	2	ileac
ileal	5	61	1808	2	ileal
izar	13	66	1601	2	izar
jar	10	76	4615	2	_jar
jean	11	66	2928	2	jean
jeer	11	54	2646	2	jeer
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
kebar	11	51	1353	2	kebar
keir	8	62	1787	2	keir
knar	8	58	1872	2	knar
kyar	11	69	1684	2	kyar
la	2	192	6163	2	l_a_
laari	5	44	1571	2	laari
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
lahar	8	31	1426	2	lahar
lair	4	59	3415	2	lair
lam	5	76	6671	2	l_am
lap	5	85	6527	2	l_ap
lard	5	67	4200	2	l_ard
lari	4	58	3915	2	l_ari
lark	8	57	3386	2	l_ark
lars	4	69	5657	2	l_ars
las	3	72	8147	2	l_as
lat	3	75	9340	2	l_at
lav	6	68	4734	2	l_av
law	6	86	5664	2	l_aw
lax	10	76	5152	2	l_ax
lay	6	88	6535	2	l_ay
lazar	14	41	1364	2	lazar
leach	10	54	2252	2	leach
leader	7	48	2465	2	leader
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
leafs	8	57	2118	2	leafs
leafy	11	63	1621	2	leafy
leaker	10	46	2007	2	leaker
leaks	9	59	2391	2	leaks
leaky	12	52	1772	2	leaky
leaner	6	40	2219	2	leaner
leans	5	55	3625	2	leans
leant	5	67	3778	2	leant
leaper	8	81	1894	2	leaper
leaps	7	55	2293	2	leaps
leapt	7	50	2747	2	leapt
learns	6	55	1374	2	learns
learnt	6	40	1925	2	learnt
lease	5	52	3026	2	lease
leaser	6	53	2267	2	leaser
leash	8	55	1921	2	leash
least	5	61	3488	2	least
leave	8	47	2372	2	leave
leaver	9	43	2151	2	leaver
leavy	11	57	1577	2	leavy
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
leers	5	48	2898	2	leers
leery	8	59	1913	2	leery
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
leger	6	57	2151	2	leger
legs	5	61	3369	2	legs
lehrs	8	61	1113	2	lehrs
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
lekvar	13	3	304	2	lekvar
leman	7	56	2260	2	leman
lemur	7	3	977	2	lemur
lend	5	62	3367	2	lend
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lent	4	63	6053	2	lent
leper	7	48	2074	2	leper
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
lever	8	51	2516	2	lever
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
liard	6	54	1859	2	liard
liars	5	47	2316	2	liars
lidar	6	3	1272	2	lidar
lier	4	59	4246	2	lier
linear	6	51	1334	2	linear
lira	4	69	2868	2	lira
load	5	67	3060	2	load
loaf	7	67	3490	2	loaf
loam	6	56	3048	2	loam
loan	4	74	3645	2	loan
lobar	7	3	1301	2	lobar
lour	4	54	3068	2	lour
luau	4	48	2416	2	luau
lunar	5	70	1731	2	lunar
lyard	9	51	1321	2	lyard
lyart	8	51	2188	2	lyart
maar	6	60	2506	2	maar
mar	5	79	6595	2	_mar
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
neap	6	69	2701	2	neap
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat
oar	3	70	5795	2	_oar
olea	4	65	3272	2	olea_
osar	4	68	2095	2	osar
par	5	74	6702	2	_par
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
peer	6	62	3835	2	peer
per	5	63	5309	2	pe_r
plea	6	68	3060	2	plea_
plead	8	58	1846	2	plead
pleas	7	56	2703	2	pleas
pleat	7	47	3447	2	pleat
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rearm	7	59	2357	2	rearm
rears	5	47	3965	2	rears
rebar	7	54	2019	2	rebar
roar	4	63	2857	2	roar
scar	6	64	3420	2	scar
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seer	4	55	4704	2	seer
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
sewar	8	54	2110	2	sewar
shear	8	54	2483	2	shear
smear	7	44	1639	2	smear
soar	4	68	3867	2	soar
spar	6	54	3330	2	spar
spear	7	58	2106	2	spear
star	4	80	3776	2	star
swear	8	53	1685	2	swear
tar	3	75	7069	2	_tar
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
ulnar	5	60	1398	2	ulnar
var	6	61	4833	2	_var
veal	7	69	3681	2	veal
veer	7	62	2957	2	veer
velar	8	58	1763	2	velar
vera	7	68	2884	2	vera
war	6	72	6242	2	_war
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
yar	6	72	5383	2	_yar
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
yearn	8	63	1643	2	yearn
years	8	45	2767	2	years
yeas	7	86	3842	2	yeas
zeal	13	55	3033	2	zeal

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.266	671770.7
2	DLD Change Limit	29872	319	0.796	37527.6
3	Display Results	319	319	0.076	4197.4
	(SQL Overall)	178691	319	1.138	157022.0