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

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

350 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
deer	5	67	3902	(None)
beer	6	56	3599	1	beer
dear	5	53	4360	1	dear
dee	4	76	6582	1	dee_
deed	6	53	4090	1	deed
deem	7	54	3289	1	deem
deep	7	60	3188	1	deep
deers	6	49	3052	1	deers
dees	5	63	5663	1	dees
deet	5	73	5658	1	deet
defer	9	46	1975	1	defer
dere	5	68	4590	1	dere
deter	6	50	2804	1	deter
doer	5	77	3470	1	doer
dyer	8	55	2211	1	dyer
jeer	11	54	2646	1	jeer
leer	4	62	3935	1	leer
peer	6	62	3835	1	peer
seer	4	55	4704	1	seer
veer	7	62	2957	1	veer
weer	7	55	3509	1	weer
adder	7	54	1959	2	adder
adeem	8	3	1180	2	adeem
ager	5	59	3584	2	ager
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
ceder	8	53	2223	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
dare	5	58	4886	2	dare
darer	6	52	3079	2	darer
dater	6	53	3231	2	dater
de	3	70	4954	2	d_e_
dead	6	54	3424	2	dead
deader	8	42	2047	2	deader
deaf	8	58	3840	2	deaf
deafer	10	41	1481	2	deafer
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dealer	7	41	2214	2	dealer
dean	5	60	3948	2	dean
dearer	7	48	2280	2	dearer
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
deb	6	63	4269	2	d_eb
debar	8	55	1786	2	debar
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
decern	9	13	1095	2	decern
deck	11	58	2775	2	deck
decker	13	52	1599	2	decker
deco	7	61	2597	2	deco
decor	8	47	1757	2	decor
decry	11	55	1435	2	decry
deeds	7	54	2376	2	deeds
deedy	10	43	1589	2	deedy
deems	8	54	2177	2	deems
deeper	9	36	1350	2	deeper
deeps	8	49	2177	2	deeps
deets	6	53	3024	2	deets
def	7	65	4672	2	d_ef
defers	10	51	1694	2	defers
deffer	13	44	1130	2	deffer
defi	8	63	2149	2	defi
defier	10	51	1865	2	defier
deft	8	55	4022	2	deft
defter	10	42	1592	2	defter
defy	11	49	2126	2	defy
degerm	10	3	789	2	degerm
deicer	9	41	1441	2	deicer
deil	5	62	3162	2	deil
deke	9	52	2876	2	deke
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
del	4	67	5275	2	d_el
dele	5	68	4308	2	dele
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delf	8	54	3657	2	delf
deli	5	56	3129	2	deli
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delt	5	78	5527	2	delt
delver	10	49	1349	2	delver
deme	7	65	3628	2	deme
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demur	8	3	1116	2	demur
demy	10	54	2285	2	demy
den	4	75	5434	2	d_en
denar	6	52	2329	2	denar
dene	5	66	4341	2	dene
denes	6	56	3972	2	denes
deni	5	69	2939	2	deni
denier	7	44	2069	2	denier
dens	5	59	4507	2	dens
denser	7	41	1519	2	denser
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
deperm	11	3	936	2	deperm
derm	7	60	3189	2	derm
derry	9	47	2137	2	derry
desert	7	27	2549	2	desert
desex	13	3	1198	2	desex
desk	9	56	1890	2	desk
deters	7	47	2468	2	deters
dev	7	60	3377	2	d_ev
deva	8	57	2098	2	deva
devel	9	42	1712	2	devel
devs	8	64	2403	2	devs
dew	7	71	3992	2	d_ew
dewar	9	58	1773	2	dewar
dewed	10	50	2030	2	dewed
dewier	10	40	1346	2	dewier
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	d_ex
dexes	13	52	2451	2	dexes
dexter	14	38	1089	2	dexter
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	d_ey
deys	8	50	2747	2	deys
dicer	8	54	2642	2	dicer
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dieter	7	35	1677	2	dieter
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dire	5	66	4414	2	dire
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
doe	4	73	6195	2	doe_
doers	6	52	2571	2	doers
does	5	65	5447	2	does
door	5	69	2851	2	door
doper	8	61	2839	2	doper
dor	4	72	5392	2	d_or
dore	5	63	5330	2	dore
dorr	5	66	2772	2	dorr
doser	6	62	2856	2	doser
doter	6	54	2862	2	doter
dour	5	63	3043	2	dour
dower	9	50	2770	2	dower
dozer	15	84	1927	2	dozer
drear	6	50	1690	2	drear
dree	5	66	3832	2	dree
dreed	7	52	2284	2	dreed
drees	6	56	2852	2	drees
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drew	8	62	2167	2	drew
drier	6	44	2396	2	drier
dryer	9	51	1146	2	dryer
due	4	52	4986	2	due_
duel	5	67	2970	2	duel
dueler	7	42	1368	2	dueler
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
duper	8	55	1900	2	duper
dure	5	63	4181	2	dure
durr	5	56	2435	2	durr
dweeb	11	3	774	2	dweeb
dye	7	53	3484	2	dye_
dyed	9	67	2076	2	dyed
dyers	9	66	1713	2	dyers
dyes	8	53	3189	2	dyes
ear	3	68	6788	2	_ear
edger	7	52	1593	2	edger
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eery	7	61	2962	2	_eery
eger	5	59	2356	2	eger
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
fleer	8	60	2077	2	fleer
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
goer	5	68	2710	2	goer
hear	7	61	4388	2	hear
heder	9	56	2363	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
idler	6	50	1566	2	idler
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	2999	2	keef
keek	7	56	2496	2	keek
keel	8	57	2946	2	keel
keen	8	48	3040	2	keen
keep	10	63	2981	2	keep
keet	8	53	4733	2	keet
keir	8	62	1787	2	keir
kier	8	65	2680	2	kier
lear	4	70	4595	2	lear
lee	3	60	6814	2	lee_
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
leger	6	57	2150	2	leger
lehr	7	55	1494	2	lehr
leper	7	48	2074	2	leper
lever	8	51	2516	2	lever
lier	4	59	4246	2	lier
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
odder	7	45	1539	2	odder
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
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	2675	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	3550	2	serer
sever	8	54	2605	2	sever
sewer	8	44	2621	2	sewer
sheer	8	47	2689	2	sheer
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
udder	7	63	1428	2	udder
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.076	2351197.4
2	DLD Change Limit	29872	350	1.000	29872.0
3	Display Results	350	350	0.096	3645.8
	(SQL Overall)	178691	350	1.172	152466.7