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

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

301 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
earn	4	67	3755	(None)
barn	6	64	4464	1	barn
carn	6	62	4543	1	carn
darn	5	64	3462	1	darn
ear	3	68	6788	1	ear_
earl	4	58	3814	1	earl
earns	5	59	2756	1	earns
ears	4	63	5659	1	ears
ern	3	57	3836	1	e_rn
karn	8	61	2943	1	karn
learn	5	53	2266	1	learn
tarn	4	68	4272	1	tarn
warn	7	52	3932	1	warn
yarn	7	52	3004	1	yarn
yearn	8	63	1643	1	yearn
aeon	4	56	3461	2	aeon
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
ain	3	75	7910	2	_ain
airn	4	64	3384	2	airn
an	2	118	7908	2	_a_n
ar	2	113	7938	2	_ar_
arb	5	104	4842	2	_arb
arc	5	102	5090	2	_arc
are	3	78	7457	2	_are
arf	6	74	5337	2	_arf
ark	7	70	4496	2	_ark
arm	5	84	4963	2	_arm
ars	3	76	7093	2	_ars
art	3	86	7914	2	_art
awn	6	80	3591	2	_awn
bairn	7	75	1553	2	bairn
ban	5	83	6684	2	ba_n
bar	5	80	7055	2	bar_
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4441	2	barf
bark	10	62	4215	2	bark
barm	8	67	3961	2	barm
barns	7	63	3514	2	barns
barny	10	58	2173	2	barny
baron	7	81	3124	2	baron
bars	6	65	6409	2	bars
bean	6	64	4386	2	bea_n
bear	6	68	4464	2	bear_
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
born	6	73	3841	2	born
bran	6	57	4038	2	bran
burn	6	56	3643	2	burn
cain	6	56	4391	2	cain
cairn	7	57	1751	2	cairn
can	5	77	6014	2	ca_n
car	5	91	6556	2	car_
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carns	7	59	3756	2	carns
carny	10	58	2292	2	carny
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
cedarn	9	40	844	2	cedarn
corn	6	99	4581	2	corn
curn	6	67	3189	2	curn
damn	7	57	2432	2	damn
dan	4	68	5967	2	da_n
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
dark	9	51	3321	2	dark
darns	6	69	2789	2	darns
dart	5	58	5787	2	dart
dawn	8	56	2420	2	dawn
dean	5	60	3948	2	dea_n
dear	5	53	4360	2	dear_
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
durn	5	61	2763	2	durn
each	9	55	3058	2	each
eagre	6	43	1532	2	eagre
eared	6	51	3950	2	eared
earing	7	52	3548	2	earing
earls	5	61	2751	2	earls
early	8	53	2412	2	early
earned	7	48	1833	2	earned
earner	6	36	1722	2	earner
earth	8	50	2305	2	earth
ease	4	50	4233	2	ease
east	4	66	5910	2	east
easy	7	62	2449	2	easy
eat	3	69	8905	2	ea_t
eaten	5	53	2305	2	eaten
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eau	3	74	5094	2	ea_u
eaux	11	66	1842	2	eaux
eave	7	57	3358	2	eave
ebon	6	68	2110	2	ebon
ecru	6	58	1953	2	ecru
eery	7	61	2962	2	eery
elain	5	53	2470	2	elain
elan	4	67	3424	2	elan
en	2	80	5239	2	e__n
eon	3	60	5208	2	e_on
er	2	83	4514	2	e_r_
era	3	57	4150	2	e_ra
eras	4	54	4150	2	eras
ere	3	63	5277	2	e_re
erg	4	55	3107	2	e_rg
erne	4	67	2743	2	e_rne
erns	4	54	2823	2	e_rns
err	3	56	2653	2	e_rr
errs	4	56	2253	2	errs
ers	3	60	4628	2	e_rs
euro	4	53	2527	2	euro
even	7	52	2227	2	even
exon	11	71	1680	2	exon
eyen	7	62	2366	2	eyen
eyra	7	62	1755	2	eyra
eyre	7	55	2525	2	eyre
eyry	10	63	1588	2	eyry
fain	7	58	4056	2	fain
fan	6	71	5886	2	fa_n
far	6	77	6260	2	far_
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farl	7	63	3855	2	farl
farm	9	59	3454	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
faun	7	62	2662	2	faun
fawn	10	53	2195	2	fawn
fear	7	53	3779	2	fear_
fears	8	48	2939	2	fears
fern	7	61	2932	2	fern
firn	7	69	2751	2	firn
gaen	5	73	2960	2	gaen
gain	5	60	4216	2	gain
gan	4	80	6013	2	ga_n
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
garni	6	3	1570	2	garni
gars	5	57	5074	2	gars
gaun	5	64	2771	2	gaun
gear	5	59	3497	2	gear_
gears	6	46	2869	2	gears
girn	5	60	2687	2	girn
gran	5	63	3501	2	gran
haen	7	62	2945	2	haen
hard	8	54	4350	2	hard
hare	7	62	5573	2	hare
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3780	2	harm
harp	9	61	3429	2	harp
hart	7	68	6577	2	hart
hear	7	61	4388	2	hear_
heard	9	52	2275	2	heard
hears	8	67	3737	2	hears
heart	8	54	4074	2	heart
hern	7	61	3489	2	hern
horn	7	67	3561	2	horn
jar	10	76	4615	2	jar_
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
jean	11	66	2928	2	jea_n
kain	8	53	3430	2	kain
kaon	8	75	2103	2	kaon
karns	9	66	2415	2	karns
kart	8	67	5082	2	kart
kern	8	53	2622	2	kern
kirn	8	71	2345	2	kirn
lain	4	61	4628	2	lain
lar	3	79	6753	2	lar_
lard	5	67	4200	2	lard
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
lawn	7	59	2563	2	lawn
lean	4	63	4524	2	lea_n
lear	4	70	4595	2	lear_
learns	6	55	1374	2	learns
learnt	6	40	1925	2	learnt
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
lorn	4	64	3525	2	lorn
main	6	53	4552	2	main
man	5	74	6587	2	ma_n
mar	5	79	6595	2	mar_
mara	6	74	4458	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
maun	6	57	2721	2	maun
mawn	9	44	2414	2	mawn
mean	6	55	3809	2	mea_n
morn	6	62	3756	2	morn
naan	4	76	2193	2	naan
nan	3	78	5488	2	na_n
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
nark	8	52	3006	2	nark
nary	7	69	3122	2	nary
near	4	52	3650	2	near_
nears	5	55	2942	2	nears
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
pain	6	56	4724	2	pain
pan	5	84	6645	2	pa_n
par	5	74	6702	2	par_
para	6	52	4218	2	para
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
park	10	52	3749	2	park
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
part	6	59	6746	2	part
pawn	9	46	2530	2	pawn
pean	6	61	4717	2	pea_n
pear	6	97	4523	2	pear_
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
pirn	6	71	2838	2	pirn
porn	6	56	3602	2	porn
rain	4	62	5173	2	rain
ran	3	82	6662	2	ra_n
rare	4	53	4843	2	rare
rear	4	56	4455	2	rear_
rearm	7	59	2357	2	rearm
rears	5	47	3965	2	rears
reearn	6	6	1214	2	reearn
reran	5	73	2910	2	reran
sain	4	55	5129	2	sain
saran	5	37	3031	2	saran
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sarin	5	52	3925	2	sarin
sark	8	49	3897	2	sark
sawn	7	54	2816	2	sawn
sear	4	73	5384	2	sear_
sears	5	47	4491	2	sears
sharn	8	48	2370	2	sharn
sorn	4	66	4106	2	sorn
tain	4	55	4807	2	tain
tan	3	71	6758	2	ta_n
tar	3	75	7069	2	tar_
tare	4	59	5762	2	tare
tarns	5	64	3395	2	tarns
taro	4	68	4691	2	taro
tarp	6	69	3642	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
tear	4	52	4288	2	tear_
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
tern	4	61	3480	2	tern
torn	4	60	4425	2	torn
turn	4	63	3039	2	turn
urn	3	57	3147	2	_urn
vain	7	52	3300	2	vain
van	6	62	4633	2	va_n
var	6	61	4833	2	var_
vara	7	55	3089	2	vara
varna	8	45	1618	2	varna
vars	7	57	4207	2	vars
vary	10	52	2606	2	vary
wain	7	58	4020	2	wain
wan	6	67	6194	2	wa_n
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3568	2	warm
warns	8	72	3100	2	warns
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
wean	7	57	3435	2	wea_n
wear	7	58	3672	2	wear_
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
worn	7	56	3175	2	worn
yar	6	72	5383	2	yar_
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarns	8	56	2179	2	yarns
yawn	10	62	1909	2	yawn
yean	7	58	3458	2	yea_n
year	7	65	3425	2	year_
yearns	9	50	954	2	yearns
years	8	45	2767	2	years
zarf	16	69	2912	2	zarf

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.263	679433.5
2	DLD Change Limit	29872	301	0.890	33564.0
3	Display Results	301	301	0.080	3762.5
	(SQL Overall)	178691	301	1.233	144923.8