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

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

276 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
fears	8	48	2939	(None)
bears	7	57	3904	1	bears
dears	6	57	3688	1	dears
ears	4	63	5659	1	_ears
fear	7	53	3779	1	fear_
feats	8	64	3275	1	feats
feuars	9	3	865	1	feuars
fiars	8	67	2083	1	fiars
gears	6	46	2869	1	gears
hears	8	67	3737	1	hears
lears	5	59	3873	1	lears
nears	5	55	2942	1	nears
pears	7	51	3861	1	pears
rears	5	47	3965	1	rears
sears	5	47	4491	1	sears
tears	5	54	3646	1	tears
wears	8	60	3030	1	wears
years	8	45	2767	1	years
afars	8	57	1651	2	afars
afeard	10	5	826	2	afeard
agars	6	61	2064	2	agars
anears	6	37	1718	2	anears
ars	3	76	7093	2	__ars
bars	6	65	6409	2	_bars
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bear	6	68	4464	2	bear_
beard	8	60	2496	2	beard
beards	9	41	1667	2	beards
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beers	7	56	2839	2	beers
blears	8	51	1645	2	blears
boars	7	52	2960	2	boars
cars	6	73	6476	2	_cars
cedars	9	33	1283	2	cedars
chars	10	59	3664	2	chars
clears	8	41	1656	2	clears
czars	16	48	1291	2	czars
deads	7	57	2691	2	deads
deairs	7	40	1378	2	deairs
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear_
deary	9	58	2684	2	deary
debars	9	42	1804	2	debars
deers	6	49	3052	2	deers
denars	7	46	2143	2	denars
dewars	10	51	1707	2	dewars
drears	7	46	1425	2	drears
ear	3	68	6788	2	_ear_
earl	4	58	3814	2	_earl
earls	5	61	2751	2	_earls
earn	4	67	3755	2	_earn
earns	5	59	2756	2	_earns
eats	4	70	5487	2	_eats
eras	4	54	4150	2	_eras
errs	4	56	2253	2	_errs
ers	3	60	4628	2	_e_rs
fabs	9	86	3586	2	f_abs
fads	8	69	3987	2	f_ads
faery	11	60	1548	2	faery
fags	8	69	3912	2	f_ags
fairs	8	58	2544	2	fairs
fans	7	62	4737	2	f_ans
far	6	77	6260	2	f_ar_
fard	8	56	3906	2	f_ard
fards	9	66	2984	2	f_ards
fare	7	63	5446	2	f_are
fares	8	58	5287	2	f_ares
farl	7	63	3855	2	f_arl
farls	8	57	3111	2	f_arls
farm	9	59	3453	2	f_arm
farms	10	63	2495	2	f_arms
faro	7	61	3692	2	f_aro
faros	8	55	3202	2	f_aros
fart	7	68	6056	2	f_art
farts	8	83	3684	2	f_arts
fas	6	82	6293	2	f_a_s
fats	7	62	5250	2	f_ats
fays	10	85	3536	2	f_ays
feal	7	139	4042	2	fea_l
feared	10	63	2043	2	feared
fearer	9	48	2018	2	fearer
fearers	10	48	1527	2	fearers
fease	8	48	2487	2	fease
feases	9	54	2292	2	feases
feast	8	59	3272	2	feast
feasts	9	51	1609	2	feasts
feat	7	64	5822	2	fea_t
feaze	17	52	1631	2	feaze
feazes	18	45	1417	2	feazes
feces	10	56	2536	2	feces
fecks	14	54	1785	2	fecks
feds	8	52	3431	2	fe_ds
feebs	10	61	1268	2	feebs
feeds	9	49	2114	2	feeds
feels	8	52	2304	2	feels
fees	7	64	5060	2	fe_es
fehs	10	65	2238	2	fe_hs
fells	8	53	2738	2	fells
felts	8	53	2454	2	felts
femes	10	56	2622	2	femes
fems	9	64	2870	2	fe_ms
femurs	11	3	671	2	femurs
fends	9	63	2497	2	fends
fens	7	61	3976	2	fe_ns
feods	9	95	1685	2	feods
fer	6	66	4612	2	fe_r_
feral	8	54	2465	2	feral
ferals	9	42	1664	2	ferals
fere	7	63	4223	2	fe_re
feres	8	60	3818	2	feres
fern	7	61	2932	2	fe_rn
ferns	8	52	2008	2	ferns
ferry	11	60	2080	2	ferry
fes	6	65	5167	2	fe__s
fess	7	65	2916	2	fe_ss
fests	8	58	2804	2	fests
fetas	8	56	2440	2	fetas
fetes	8	56	3014	2	fetes
fetors	9	10	1447	2	fetors
fets	7	53	4594	2	fe_ts
fetus	8	58	1654	2	fetus
feuar	8	3	1024	2	feuar_
feuds	9	59	1488	2	feuds
feus	7	58	3075	2	fe_us
fevers	12	54	1489	2	fevers
fezes	17	52	2002	2	fezes
fiar	7	64	2733	2	fiar_
fiats	8	53	2448	2	fiats
firs	7	66	3771	2	f_irs
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flairs	9	57	1191	2	flairs
flams	10	51	2501	2	flams
flans	8	53	2797	2	flans
flaps	10	56	2138	2	flaps
flare	8	48	2363	2	flare
flares	9	45	2170	2	flares
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
fleams	11	50	1194	2	fleams
fleas	8	64	2366	2	flea_s
fleers	9	60	1579	2	fleers
flirs	8	55	1893	2	flirs
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
fours	8	55	2149	2	fours
frags	9	63	2217	2	frags
fraps	10	56	2055	2	fraps
frass	8	53	2112	2	frass
frats	8	68	2967	2	frats
frays	11	69	2010	2	frays
freaks	13	47	1306	2	freaks
freers	9	47	1730	2	freers
friars	9	38	1209	2	friars
furs	7	67	3504	2	f_urs
gars	5	57	5074	2	_gars
gear	5	59	3497	2	gear_
gnars	6	67	1885	2	gnars
guars	6	50	2105	2	guars
haars	8	56	2047	2	haars
heads	9	51	2711	2	heads
heals	8	57	3346	2	heals
heaps	10	52	2322	2	heaps
hear	7	61	4388	2	hear_
heard	9	52	2275	2	heard
hearse	9	41	1427	2	hearse
heart	8	54	4074	2	heart
hearts	9	62	1894	2	hearts
heats	8	58	3840	2	heats
heirs	8	56	1856	2	heirs
hers	7	58	4487	2	he_rs
hoars	8	59	2555	2	hoars
izars	14	51	1293	2	izars
jars	11	73	3835	2	_jars
jeans	12	60	2211	2	jeans
jeers	12	48	1813	2	jeers
kbars	11	46	1260	2	kbars
keas	8	63	3709	2	kea_s
kebars	12	41	1249	2	kebars
keirs	9	53	1367	2	keirs
knars	9	44	1611	2	knars
kyars	12	48	1396	2	kyars
lars	4	69	5657	2	_lars
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lear	4	70	4595	2	lear_
learn	5	53	2266	2	learn
learns	6	55	1374	2	learns
leary	8	59	2738	2	leary
leas	4	59	5418	2	lea_s
leers	5	48	2898	2	leers
lehrs	8	61	1113	2	lehrs
liars	5	47	2316	2	liars
maars	7	46	2163	2	maars
mars	6	62	6187	2	_mars
meads	8	54	2532	2	meads
meals	7	59	3338	2	meals
means	7	58	3123	2	means
meats	7	50	3405	2	meats
neaps	7	56	1832	2	neaps
near	4	52	3650	2	near_
neats	5	59	3190	2	neats
oars	4	68	4603	2	_oars
pars	6	75	6079	2	_pars
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pear	6	97	4523	2	pear_
pearl	7	53	2446	2	pearl
pearls	8	47	1539	2	pearls
peart	7	64	4075	2	peart
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
peers	7	51	3027	2	peers
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear_
rearm	7	59	2357	2	rearm
rearms	8	51	1465	2	rearms
rebars	8	40	1983	2	rebars
roars	5	56	2224	2	roars
scars	7	54	3353	2	scars
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sear	4	73	5384	2	sear_
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seers	5	51	3638	2	seers
sers	4	57	4665	2	se_rs
sewars	9	40	1863	2	sewars
shears	9	38	2090	2	shears
smears	8	47	1443	2	smears
soars	5	47	3251	2	soars
spars	7	54	3154	2	spars
spears	8	40	1947	2	spears
stars	5	58	3657	2	stars
swears	9	41	1407	2	swears
tars	4	67	6395	2	_tars
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tear	4	52	4288	2	tear_
teary	8	51	2405	2	teary
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
tsars	5	67	1711	2	tsars
tzars	14	49	1427	2	tzars
vars	7	57	4207	2	_vars
veals	8	49	2619	2	veals
veers	8	45	2136	2	veers
velars	9	39	1372	2	velars
wars	7	86	5980	2	_wars
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear_
weary	11	56	2061	2	weary
weirs	8	43	1649	2	weirs
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year_
yearn	8	63	1643	2	yearn
yearns	9	50	954	2	yearns
yeas	7	86	3842	2	yea_s
zeals	14	53	2085	2	zeals

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	53800	0.313	570897.8
2	DLD Change Limit	53800	276	1.530	35163.4
3	Display Results	276	276	0.080	3450.0
	(SQL Overall)	178691	276	1.923	92923.0