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

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

295 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
fear	7	53	3779	(None)
bear	6	68	4464	1	bear
dear	5	53	4360	1	dear
ear	3	68	6788	1	_ear
far	6	77	6260	1	f_ar
feal	7	139	4042	1	feal
fears	8	48	2939	1	fears
feat	7	64	5822	1	feat
fer	6	66	4612	1	fe_r
feuar	8	3	1024	1	feuar
fiar	7	64	2733	1	fiar
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
afeard	10	5	826	2	afeard
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
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
er	2	83	4514	2	_e_r
era	3	57	4150	2	_era
err	3	56	2653	2	_err
fa	5	101	4845	2	f_a_
fab	8	74	5313	2	f_ab
fad	7	74	5241	2	f_ad
faery	11	60	1548	2	faery
fag	7	68	5236	2	f_ag
fair	7	63	3252	2	fair
fan	6	71	5885	2	f_an
fard	8	56	3906	2	f_ard
fare	7	63	5446	2	f_are
farl	7	63	3855	2	f_arl
farm	9	59	3453	2	f_arm
faro	7	61	3692	2	f_aro
fart	7	68	6056	2	f_art
fas	6	82	6293	2	f_as
fat	6	81	7808	2	f_at
fax	13	81	4331	2	f_ax
fay	9	74	5486	2	f_ay
fe	5	79	4474	2	fe__
feared	10	63	2043	2	feared
fearer	9	48	2018	2	fearer
fease	8	48	2487	2	fease
feast	8	59	3272	2	feast
feater	9	52	2405	2	feater
feats	8	64	3275	2	feats
feaze	17	52	1631	2	feaze
fecal	10	51	1921	2	fecal
feck	13	49	2343	2	feck
fed	7	65	4835	2	fe_d
feds	8	52	3431	2	feds
fee	6	68	6201	2	fe_e
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
feh	9	61	3609	2	fe_h
fehs	10	65	2238	2	fehs
fell	7	68	3307	2	fell
felt	7	51	4693	2	felt
fem	8	60	4073	2	fe_m
feme	9	61	3054	2	feme
fems	9	64	2870	2	fems
femur	10	3	868	2	femur
fen	6	68	5135	2	fe_n
fend	8	48	3297	2	fend
fens	7	61	3976	2	fens
feod	8	155	2300	2	feod
feral	8	54	2465	2	feral
fere	7	63	4223	2	fere
fern	7	61	2932	2	fern
ferry	11	60	2080	2	ferry
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
feta	7	65	2890	2	feta
fetal	8	56	2337	2	fetal
fetas	8	56	2440	2	fetas
fete	7	57	3492	2	fete
fetor	8	12	1453	2	fetor
fets	7	53	4594	2	fets
feu	6	78	4366	2	fe_u
feuars	9	3	865	2	feuars
feud	8	65	2302	2	feud
feus	7	58	3075	2	feus
fever	11	56	1795	2	fever
few	9	54	3696	2	fe_w
fewer	11	52	1612	2	fewer
fey	9	59	4088	2	fe_y
feyer	11	50	1452	2	feyer
fez	15	62	3682	2	fe_z
fiars	8	67	2083	2	fiars
fiat	7	66	4664	2	fiat
filar	8	48	1929	2	filar
fir	6	67	4489	2	f_ir
flab	9	66	2835	2	flab
flag	8	74	2708	2	flag
flair	8	61	1412	2	flair
flak	11	60	2617	2	flak
flam	9	63	3329	2	flam
flan	7	61	3418	2	flan
flap	9	61	2870	2	flap
flare	8	48	2363	2	flare
flat	7	71	4782	2	flat
flaw	10	63	2664	2	flaw
flax	14	73	2563	2	flax
flay	10	63	3280	2	flay
flea	7	56	2849	2	flea_
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
fleer	8	60	2077	2	fleer
flir	7	64	2220	2	flir
foal	7	66	3092	2	foal
foam	9	71	2717	2	foam
for	6	69	5207	2	f_or
fora	7	59	3739	2	fora
four	7	62	2686	2	four
frae	7	53	3047	2	frae
frag	8	51	2627	2	frag
frap	9	59	2581	2	frap
frat	7	56	4854	2	frat
fray	10	54	2890	2	fray
freak	12	51	1524	2	freak
freer	8	60	2124	2	freer
friar	8	54	1427	2	friar
fubar	10	3	992	2	fubar
fur	6	66	3732	2	f_ur
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
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	2505	2	maar
mar	5	79	6594	2	_mar
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3808	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
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	2356	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	2109	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.076	2351197.4
2	DLD Change Limit	29872	295	0.873	34217.6
3	Display Results	295	295	0.063	4682.5
	(SQL Overall)	178691	295	1.012	176572.1