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

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

329 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
dean	5	60	3948	(None)
bean	6	64	4386	1	bean
dan	4	68	5967	1	d_an
dead	6	54	3424	1	dead
deaf	8	58	3840	1	deaf
deal	5	63	4741	1	deal
deans	6	61	3139	1	deans
dear	5	53	4360	1	dear
den	4	75	5434	1	de_n
dewan	9	57	1804	1	dewan
jean	11	66	2928	1	jean
lean	4	63	4524	1	lean
mean	6	55	3809	1	mean
pean	6	61	4717	1	pean
wean	7	57	3435	1	wean
yean	7	58	3458	1	yean
adman	8	45	1790	2	adman
aeon	4	56	3461	2	aeon
alan	4	68	4408	2	alan
an	2	118	7908	2	__an
azan	13	65	2178	2	azan
ban	5	83	6684	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
bran	6	57	4038	2	bran
can	5	77	6014	2	_can
clan	6	56	3392	2	clan
clean	7	54	2041	2	clean
cyan	9	64	1962	2	cyan
dab	6	74	5556	2	d_ab
dad	5	84	5616	2	d_ad
dag	5	77	5301	2	d_ag
dah	7	81	4898	2	d_ah
dak	8	63	4069	2	d_ak
dal	4	75	5495	2	d_al
dam	6	74	5704	2	d_am
daman	8	48	2116	2	daman
damn	7	57	2432	2	damn
dang	6	51	3154	2	d_ang
dank	9	58	2824	2	d_ank
dans	5	67	4815	2	d_ans
dap	6	66	5245	2	d_ap
darn	5	64	3462	2	darn
daw	7	71	4836	2	d_aw
dawn	8	56	2420	2	dawn
day	7	62	5411	2	d_ay
de	3	70	4954	2	de__
deacon	9	5	1042	2	deacon
deaden	8	37	1432	2	deaden
deads	7	57	2691	2	deads
deafen	10	38	967	2	deafen
deair	6	58	1719	2	deair
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
deaned	8	46	2045	2	deaned
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
deash	9	56	1724	2	deash
death	9	48	2252	2	death
deave	9	50	2233	2	deave
deb	6	63	4269	2	de_b
debag	9	42	1230	2	debag
debar	8	55	1786	2	debar
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
decaf	11	49	1944	2	decaf
decal	8	55	2323	2	decal
decane	9	38	1887	2	decane
decant	9	35	2422	2	decant
decay	11	47	1848	2	decay
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
dedal	7	57	1902	2	dedal
dedans	8	59	1507	2	dedans
dee	4	76	6582	2	de_e
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
deewan	10	26	755	2	deewan
def	7	65	4672	2	de_f
defang	11	3	775	2	defang
defat	9	54	2669	2	defat
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degas	7	51	1916	2	degas
deign	7	43	1280	2	deign
deil	5	62	3162	2	deil
deke	9	52	2876	2	deke
del	4	67	5275	2	de_l
delay	9	48	2063	2	delay
dele	5	68	4308	2	dele
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
demand	10	43	1425	2	demand
deme	7	65	3628	2	deme
demean	9	5	1056	2	demean
demo	7	74	2755	2	demo
demon	8	65	2031	2	demon
demy	10	54	2285	2	demy
denar	6	52	2329	2	denar
dene	5	66	4341	2	dene
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
derat	6	50	4408	2	derat
deray	9	50	2418	2	deray
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desand	8	48	1263	2	desand
desk	9	56	1890	2	desk
desman	9	3	1169	2	desman
detain	7	46	1738	2	detain
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devas	9	62	1888	2	devas
devon	9	51	1368	2	devon
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dewans	10	52	1514	2	dewans
dewar	9	58	1773	2	dewar
dewax	16	55	1085	2	dewax
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	de_x
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
deys	8	50	2747	2	deys
dhak	12	55	1203	2	dhak
dhal	8	67	1928	2	dhal
dial	5	59	3506	2	dial
din	4	64	5946	2	d_in
divan	9	61	1484	2	divan
diwan	9	57	1255	2	diwan
djin	12	9	1163	2	djin
doat	5	69	4767	2	doat
don	4	67	5765	2	d_on
dona	5	55	2963	2	dona
down	8	64	2749	2	down
drab	7	62	2645	2	drab
drag	6	48	2505	2	drag
drain	6	52	2289	2	drain
dram	7	58	3200	2	dram
drank	10	48	1620	2	drank
drat	5	62	4783	2	drat
draw	8	56	2301	2	draw
drawn	9	56	1424	2	drawn
dray	8	54	2809	2	dray
dread	7	44	1902	2	dread
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
duad	6	65	2141	2	duad
dual	5	59	2817	2	dual
dun	4	65	4558	2	d_un
durn	5	61	2763	2	durn
dyad	9	64	1545	2	dyad
ear	3	68	6788	2	_ear
earn	4	67	3755	2	_earn
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
elan	4	67	3424	2	elan
en	2	80	5239	2	_e_n
eon	3	60	5208	2	_eon
ern	3	57	3836	2	_ern
fan	6	71	5886	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
gaen	5	73	2960	2	gaen
gan	4	80	6013	2	_gan
gear	5	59	3497	2	gear
gen	4	59	5051	2	ge_n
glean	6	58	1820	2	glean
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
idea	5	91	2277	2	idea_
ideal	6	57	1639	2	ideal
ideas	6	59	1901	2	ideas
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	3041	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
lea	3	76	6018	2	lea_
lead	5	60	3885	2	lead
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
leans	5	55	3625	2	leans
leant	5	67	3778	2	leant
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
learn	5	53	2266	2	learn
leas	4	59	5418	2	leas
leman	7	56	2260	2	leman
loan	4	74	3645	2	loan
man	5	74	6587	2	_man
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
means	7	58	3123	2	means
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meat	6	63	5960	2	meat
men	5	92	5285	2	me_n
moan	6	58	3202	2	moan
naan	4	76	2193	2	naan
nan	3	78	5488	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
odea	5	62	2457	2	odea_
odeon	6	4	1148	2	odeon
paean	7	72	2272	2	paean
pan	5	84	6645	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
quean	14	36	1284	2	quean
ran	3	82	6662	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	6757	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
van	6	62	4633	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	6194	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.280	638182.1
2	DLD Change Limit	29872	329	0.846	35309.7
3	Display Results	329	329	0.076	4328.9
	(SQL Overall)	178691	329	1.202	148661.4