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

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

357 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
leer	4	62	3935	(None)
beer	6	56	3599	1	beer
deer	5	67	3902	1	deer
fleer	8	60	2077	1	fleer
jeer	11	54	2646	1	jeer
lear	4	70	4595	1	lear
lee	3	60	6814	1	lee_
leek	8	53	3173	1	leek
leers	5	48	2898	1	leers
leery	8	59	1913	1	leery
lees	4	54	5588	1	lees
leet	4	59	5790	1	leet
leger	6	57	2151	1	leger
lehr	7	55	1494	1	lehr
leper	7	48	2074	1	leper
lever	8	51	2516	1	lever
lier	4	59	4246	1	lier
peer	6	62	3835	1	peer
seer	4	55	4704	1	seer
veer	7	62	2957	1	veer
weer	7	55	3509	1	weer
ager	5	59	3584	2	ager
alder	6	54	2191	2	alder
alee	4	66	5232	2	alee_
alter	5	48	2850	2	alter
ameer	7	56	1898	2	ameer
aper	6	63	3623	2	aper
aver	7	59	3188	2	aver
bear	6	68	4464	2	bear
bee	5	62	6240	2	bee_
beef	9	62	3368	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beers	7	56	2839	2	beers
beery	10	52	2012	2	beery
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
bier	6	55	3183	2	bier
blear	7	59	1868	2	blear
bleed	8	50	1980	2	bleed
bleep	9	50	1345	2	bleep
bluer	7	49	1849	2	bluer
ceder	8	53	2224	2	ceder
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
cere	6	67	4147	2	cere
cheer	10	54	2038	2	cheer
clear	7	62	1905	2	clear
cleek	11	55	1491	2	cleek
clever	11	46	1153	2	clever
dear	5	53	4360	2	dear
dee	4	76	6582	2	dee_
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deers	6	49	3052	2	deers
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
defer	9	46	1975	2	defer
dere	5	68	4590	2	dere
deter	6	50	2804	2	deter
doer	5	77	3470	2	doer
dyer	8	55	2211	2	dyer
ear	3	68	6788	2	_ear
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eery	7	61	2962	2	_eery
eger	5	59	2357	2	eger
elder	6	40	2002	2	elder
elver	8	52	1624	2	elver
emeer	7	48	1536	2	emeer
er	2	83	4514	2	__er
ere	3	63	5277	2	_ere
err	3	56	2653	2	_err
ever	7	70	2769	2	ever
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fear	7	53	3779	2	fear
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feed	8	45	3890	2	feed
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feet	7	53	5221	2	feet
fer	6	66	4612	2	_fer
fere	7	63	4223	2	fere
fever	11	56	1795	2	fever
fewer	11	52	1612	2	fewer
feyer	11	50	1452	2	feyer
flee	7	62	3879	2	flee_
fleers	9	60	1579	2	fleers
flees	8	58	2875	2	flees
fleet	8	59	3233	2	fleet
flier	8	60	2340	2	flier
flyer	11	49	1625	2	flyer
freer	8	60	2124	2	freer
gear	5	59	3497	2	gear
gee	4	53	5920	2	gee_
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
glee	5	52	3906	2	glee_
gleed	7	53	2057	2	gleed
gleek	10	53	1510	2	gleek
glees	6	50	2759	2	glees
gleet	6	55	3234	2	gleet
gluer	6	51	1677	2	gluer
goer	5	68	2710	2	goer
hear	7	61	4388	2	hear
heder	9	56	2364	2	heder
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
here	7	64	4710	2	here
hewer	11	57	1993	2	hewer
hexer	15	51	1668	2	hexer
hoer	7	65	3398	2	hoer
iller	5	48	2129	2	iller
jee	10	66	4864	2	jee_
jeed	12	54	2850	2	jeed
jeep	13	56	2484	2	jeep
jeers	12	48	1813	2	jeers
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
keef	11	58	3000	2	keef
keek	7	56	2497	2	keek
keel	8	57	2947	2	keel
keen	8	48	3041	2	keen
keep	10	63	2982	2	keep
keet	8	53	4734	2	keet
keir	8	62	1787	2	keir
kier	8	65	2681	2	kier
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
lair	4	59	3415	2	lair
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
lar	3	79	6753	2	l_ar
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laveer	9	41	1042	2	laveer
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
lea	3	76	6018	2	l_ea
lead	5	60	3885	2	lead
leader	7	48	2465	2	leader
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leaker	10	46	2007	2	leaker
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leaner	6	40	2219	2	leaner
leap	6	60	3268	2	leap
leaper	8	81	1894	2	leaper
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leas	4	59	5418	2	leas
leaser	6	53	2267	2	leaser
leaver	9	43	2151	2	leaver
leben	7	3	1485	2	leben
lech	9	68	2544	2	lech
lecher	11	34	1585	2	lecher
led	4	62	5455	2	l_ed
ledger	8	59	1439	2	ledger
leech	10	49	1321	2	leech
leeks	9	53	1889	2	leeks
leered	7	38	1622	2	leered
leets	5	49	2712	2	leets
left	7	63	4048	2	left
lefter	9	36	1343	2	lefter
leg	4	64	4611	2	l_eg
legers	7	45	1831	2	legers
leges	6	44	2729	2	leges
legs	5	61	3369	2	legs
lehrs	8	61	1113	2	lehrs
lei	3	68	4638	2	l_ei
leis	4	57	3960	2	leis
lek	7	56	4030	2	l_ek
leke	8	55	2740	2	leke
leks	8	54	2760	2	leks
leku	8	65	1991	2	leku
lemur	7	3	977	2	lemur
lend	5	62	3367	2	lend
lender	7	39	2127	2	lender
lenes	5	47	3852	2	lenes
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lent	4	63	6053	2	lent
lepers	8	48	1732	2	lepers
lept	6	64	4088	2	lept
les	3	56	6307	2	l_es
leses	5	49	3081	2	leses
less	4	56	3510	2	less
lesser	6	35	1485	2	lesser
lest	4	69	5632	2	lest
let	3	64	8147	2	l_et
lets	4	71	4794	2	lets
letter	6	37	2258	2	letter
leu	3	60	4740	2	l_eu
leud	5	72	2342	2	leud
lev	6	61	3942	2	l_ev
leva	7	70	2071	2	leva
levee	8	40	2381	2	levee
level	8	41	1655	2	level
levers	9	46	2132	2	levers
levier	9	40	1387	2	levier
levo	7	68	2006	2	levo
levy	10	64	1850	2	levy
lewd	8	57	1659	2	lewd
lewder	10	47	961	2	lewder
lex	10	79	4382	2	l_ex
lexes	12	72	2526	2	lexes
ley	6	62	4681	2	l_ey
leys	7	64	3018	2	leys
lez	12	55	4131	2	l_ez
liar	4	72	2968	2	liar
liber	7	47	2362	2	liber
lie	3	82	6452	2	lie_
lied	5	58	3809	2	lied
lieder	7	49	1232	2	lieder
lief	7	60	3699	2	lief
liefer	9	52	957	2	liefer
lien	4	53	3980	2	lien
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
liever	9	46	1186	2	liever
lifer	8	58	2215	2	lifer
liger	6	50	2447	2	liger
liker	9	56	2706	2	liker
liner	5	59	3892	2	liner
lire	4	78	4529	2	lire
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
loner	5	54	3104	2	loner
loper	7	51	2923	2	loper
lore	4	58	5035	2	lore
loser	5	47	2867	2	loser
lour	4	54	3068	2	lour
lover	8	55	2645	2	lover
lower	8	58	3041	2	lower
lues	4	59	4355	2	lues
luger	6	53	2208	2	luger
lure	4	51	4246	2	lure
lurer	5	46	2531	2	lurer
lwei	7	53	1264	2	lwei
lye	6	65	3341	2	lye_
lyes	7	55	3083	2	lyes
lyre	7	56	2379	2	lyre
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
mere	6	72	4444	2	mere
merer	7	51	2623	2	merer
meter	7	51	3032	2	meter
near	4	52	3650	2	near
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
never	8	62	1864	2	never
newer	8	57	1746	2	newer
older	6	51	2117	2	older
omer	6	70	2839	2	omer
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
pear	6	97	4523	2	pear
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peers	7	51	3027	2	peers
peery	10	57	1944	2	peery
pees	6	52	5737	2	pees
per	5	63	5309	2	_per
pere	6	64	5026	2	pere
peter	7	44	2759	2	peter
pier	6	60	3529	2	pier
plier	7	52	2128	2	plier
plyer	10	62	1433	2	plyer
queer	14	37	1281	2	queer
rear	4	56	4455	2	rear
ree	3	79	7407	2	ree_
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
refer	8	48	2214	2	refer
ruer	4	61	2756	2	ruer
sear	4	73	5384	2	sear
seder	6	48	2676	2	seder
see	3	57	7226	2	see_
seed	5	55	4948	2	seed
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seers	5	51	3638	2	seers
sees	4	53	6105	2	sees
ser	3	67	5240	2	_ser
sere	4	61	5347	2	sere
serer	5	59	3551	2	serer
sever	8	54	2605	2	sever
sewer	8	44	2622	2	sewer
sheer	8	47	2689	2	sheer
sleek	9	46	1904	2	sleek
sleep	7	49	2018	2	sleep
sleet	5	56	3913	2	sleet
slier	5	48	2724	2	slier
slyer	8	55	1512	2	slyer
sneer	5	49	1995	2	sneer
speer	7	46	2390	2	speer
steer	5	54	2386	2	steer
suer	4	53	3403	2	suer
sweer	8	49	1857	2	sweer
tear	4	52	4288	2	tear
tee	3	83	6687	2	tee_
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
tier	4	49	3614	2	tier
tyer	7	53	2339	2	tyer
ulcer	7	3	1075	2	ulcer
user	4	50	2300	2	user
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veers	8	45	2136	2	veers
veery	11	58	1625	2	veery
vees	7	54	3943	2	vees
vexer	15	55	1352	2	vexer
vier	7	54	2815	2	vier
wear	7	58	3672	2	wear
weber	10	3	1352	2	weber
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weep	9	51	3165	2	weep
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
weir	7	60	1992	2	weir
were	7	62	3833	2	were
year	7	65	3425	2	year
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees

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.263	679433.5
2	DLD Change Limit	29872	357	0.923	32364.0
3	Display Results	357	357	0.076	4697.4
	(SQL Overall)	178691	357	1.262	141593.5