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

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

332 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
dear	5	53	4360	(None)
bear	6	68	4464	1	bear
dead	6	54	3424	1	dead
deaf	8	58	3840	1	deaf
deair	6	58	1719	1	deair
deal	5	63	4741	1	deal
dean	5	60	3948	1	dean
dears	6	57	3688	1	dears
deary	9	58	2684	1	deary
debar	8	55	1786	1	debar
deer	5	67	3902	1	deer
denar	6	52	2329	1	denar
dewar	9	58	1773	1	dewar
drear	6	50	1690	1	drear
ear	3	68	6788	1	_ear
fear	7	53	3779	1	fear
gear	5	59	3497	1	gear
hear	7	61	4388	1	hear
lear	4	70	4595	1	lear
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
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
blear	7	59	1868	2	blear
boar	6	61	3429	2	boar
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
clear	7	62	1905	2	clear
czar	15	60	1313	2	czar
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
damar	8	41	1774	2	damar
dan	4	68	5967	2	d_an
dap	6	66	5245	2	d_ap
darb	7	60	3353	2	d_arb
dare	5	58	4886	2	d_are
dark	9	51	3321	2	d_ark
darn	5	64	3462	2	d_arn
dart	5	58	5787	2	d_art
daw	7	71	4836	2	d_aw
day	7	62	5411	2	d_ay
de	3	70	4954	2	de__
deader	8	42	2047	2	deader
deads	7	57	2691	2	deads
deafer	10	41	1481	2	deafer
deairs	7	40	1378	2	deairs
dealer	7	41	2214	2	dealer
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
deans	6	61	3139	2	deans
dearer	7	48	2280	2	dearer
dearie	7	33	1981	2	dearie
dearly	10	46	1532	2	dearly
dearth	10	42	1251	2	dearth
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
debark	13	42	1094	2	debark
debars	9	42	1804	2	debars
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
decaf	11	49	1944	2	decaf
decal	8	55	2323	2	decal
decare	9	39	1915	2	decare
decay	11	47	1848	2	decay
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
decor	8	47	1757	2	decor
decry	11	55	1435	2	decry
dedal	7	57	1902	2	dedal
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
deers	6	49	3052	2	deers
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
def	7	65	4672	2	de_f
defat	9	54	2669	2	defat
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degas	7	51	1916	2	degas
deil	5	62	3162	2	deil
dekare	11	28	1156	2	dekare
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
demark	13	42	1102	2	demark
deme	7	65	3628	2	deme
demo	7	74	2755	2	demo
demur	8	3	1116	2	demur
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
denari	7	109	1735	2	denari
denars	7	46	2143	2	denars
denary	10	53	1686	2	denary
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
deodar	8	3	771	2	deodar
depart	9	47	2056	2	depart
derat	6	50	4408	2	derat
deray	9	50	2418	2	deray
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
derry	9	47	2137	2	derry
desk	9	56	1890	2	desk
deter	6	50	2804	2	deter
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devas	9	62	1888	2	devas
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dewan	9	57	1804	2	dewan
dewars	10	51	1707	2	dewars
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
diary	9	50	1697	2	diary
dinar	6	63	1989	2	dinar
doat	5	69	4767	2	doat
doer	5	77	3470	2	doer
dogear	8	3	819	2	dogear
door	5	69	2851	2	door
dor	4	72	5392	2	d_or
dorr	5	66	2772	2	dorr
dour	5	63	3043	2	dour
drab	7	62	2645	2	drab
drag	6	48	2505	2	drag
dram	7	58	3200	2	dram
drat	5	62	4783	2	drat
draw	8	56	2301	2	draw
dray	8	54	2809	2	dray
dread	7	44	1902	2	dread
dream	8	51	2039	2	dream
drears	7	46	1425	2	drears
dreary	10	46	1167	2	dreary
duad	6	65	2141	2	duad
dual	5	59	2817	2	dual
dura	5	52	3211	2	dura
durr	5	56	2435	2	durr
dwarf	12	60	1524	2	dwarf
dyad	9	64	1545	2	dyad
dyer	8	55	2211	2	dyer
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
endear	7	41	1001	2	endear
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
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
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
idea	5	91	2277	2	idea_
ideal	6	57	1639	2	ideal
ideas	6	59	1901	2	ideas
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
lar	3	79	6753	2	_lar
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
lean	4	63	4524	2	lean
leap	6	60	3268	2	leap
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leas	4	59	5418	2	leas
leer	4	62	3935	2	leer
lehr	7	55	1494	2	lehr
liar	4	72	2968	2	liar
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
odea	5	62	2457	2	odea_
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
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
redear	7	35	1517	2	redear
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
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.280	638182.1
2	DLD Change Limit	29872	332	0.843	35435.3
3	Display Results	332	332	0.080	4150.0
	(SQL Overall)	178691	332	1.203	148537.8