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

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

432 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
eras	4	54	4150	(None)
bras	6	57	4645	1	bras
ears	4	63	5659	1	ears
era	3	57	4150	1	era_
erase	5	49	2549	1	erase
ergs	5	55	2381	1	ergs
erns	4	54	2822	1	erns
eros	4	52	3845	1	eros
errs	4	56	2253	1	errs
ers	3	60	4628	1	er_s
etas	4	64	3227	1	etas
eyas	7	64	2743	1	eyas
eyras	8	47	1592	1	eyras
ras	3	75	7539	1	_ras
aas	3	109	7539	2	_aas
abas	6	86	4208	2	abas
agas	5	59	3884	2	agas
alas	4	63	5812	2	alas
amas	6	77	4629	2	amas
anas	4	66	4986	2	anas
arak	8	69	2957	2	arak
araks	9	48	2088	2	araks
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
areas	5	59	3577	2	areas
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
arias	5	54	3802	2	arias
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
arras	5	56	2613	2	arras
ars	3	76	7093	2	ar_s
arts	4	96	5026	2	arts
as	2	110	8307	2	__as
auras	5	59	3255	2	auras
baas	6	68	4467	2	baas
bars	6	65	6409	2	bars
bas	5	86	8175	2	_bas
bears	7	57	3904	2	bears
bemas	9	64	2428	2	bemas
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
betas	7	55	2876	2	betas
bias	6	47	3816	2	bias
boas	6	61	5083	2	boas
boras	7	59	3830	2	boras
bra	5	63	3946	2	bra_
brad	7	52	3434	2	brad
brads	8	55	2829	2	brads
brae	6	56	3911	2	brae
braes	7	57	3505	2	braes
brag	7	52	2972	2	brag
brags	8	56	2510	2	brags
bran	6	57	4038	2	bran
brans	7	54	3743	2	brans
brash	10	62	2156	2	brash
brass	7	54	2802	2	brass
brat	6	60	5554	2	brat
brats	7	53	3601	2	brats
braw	9	48	2956	2	braw
braws	10	64	2519	2	braws
bray	9	52	3290	2	bray
brays	10	67	2311	2	brays
bris	6	55	3961	2	bris
bros	6	56	3566	2	bros
buras	7	47	3629	2	buras
cars	6	73	6476	2	cars
ceres	7	55	4001	2	ceres
cerias	8	33	2198	2	cerias
ceros	7	47	2607	2	ceros
crab	8	57	2767	2	crab
crabs	9	54	2139	2	crabs
crag	7	56	2530	2	crag
crags	8	56	2257	2	crags
cram	8	56	3549	2	cram
crams	9	62	2915	2	crams
crap	8	57	3184	2	crap
craps	9	53	2864	2	craps
crash	10	91	2001	2	crash
crass	7	63	2804	2	crass
craw	9	77	2526	2	craw
craws	10	57	2312	2	craws
cris	6	62	3343	2	cris
crus	6	58	2848	2	crus
dears	6	57	3688	2	dears
degas	7	51	1916	2	degas
derat	6	50	4408	2	derat
derats	7	46	2506	2	derats
deray	9	50	2418	2	deray
derays	10	55	1425	2	derays
dermas	9	41	1681	2	dermas
derms	8	50	2289	2	derms
devas	9	62	1888	2	devas
drab	7	62	2645	2	drab
drabs	8	51	1967	2	drabs
drag	6	48	2505	2	drag
drags	7	55	2111	2	drags
dram	7	58	3200	2	dram
drams	8	60	2583	2	drams
drat	5	62	4783	2	drat
drats	6	66	2837	2	drats
draw	8	56	2301	2	draw
draws	9	51	1937	2	draws
dray	8	54	2809	2	dray
drays	9	58	1977	2	drays
drys	8	63	1480	2	drys
duras	6	57	2772	2	duras
ear	3	68	6788	2	e_ar
earl	4	58	3814	2	earl
earls	5	61	2751	2	earls
earn	4	67	3755	2	earn
earns	5	59	2756	2	earns
ease	4	50	4233	2	e_ase
east	4	66	5910	2	e_ast
easy	7	62	2449	2	e_asy
eat	3	69	8905	2	e_at
eats	4	70	5487	2	eats
eau	3	74	5094	2	e_au
ebbs	8	24	1199	2	ebbs
ecrus	7	51	1386	2	ecrus
ecus	6	54	2146	2	ecus
edhs	8	62	1210	2	edhs
eds	4	66	3892	2	e_ds
eels	4	65	3674	2	eels
effs	10	51	1403	2	effs
efs	6	68	2960	2	e_fs
efts	7	65	1948	2	efts
egad	6	42	1541	2	egad
egads	7	46	1092	2	egads
egal	5	51	1943	2	egal
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
ekes	8	67	2660	2	ekes
elan	4	67	3424	2	elan
elans	5	55	2775	2	elans
elds	5	63	2485	2	elds
elks	8	58	2003	2	elks
ells	4	64	3135	2	ells
elms	6	73	2270	2	elms
els	3	76	4572	2	e_ls
emes	6	54	3466	2	emes
ems	5	64	3549	2	e_ms
emus	6	68	2168	2	emus
ends	5	65	2852	2	ends
engs	5	61	2139	2	engs
ens	3	72	4592	2	e_ns
eons	4	66	3871	2	eons
ephas	10	3	1154	2	ephas
epos	6	67	2373	2	epos
er	2	83	4514	2	er__
erased	7	48	1675	2	erased
eraser	6	42	1633	2	eraser
erases	6	44	2540	2	erases
ere	3	63	5277	2	er_e
erg	4	55	3107	2	er_g
ergo	5	64	2015	2	ergo
ericas	8	3	1546	2	ericas
ern	3	57	3835	2	er_n
erne	4	67	2742	2	erne
ernes	5	52	2481	2	ernes
erose	5	57	2727	2	erose
err	3	56	2653	2	er_r
erses	5	58	2680	2	erses
erst	4	74	3643	2	erst
es	2	90	4822	2	e__s
eses	4	53	3610	2	eses
ess	3	60	3088	2	e_ss
eta	3	58	3419	2	eta_
eths	7	66	1952	2	eths
etnas	5	47	1393	2	etnas
euros	5	49	2024	2	euros
eves	7	62	3046	2	eves
ewes	7	63	2870	2	ewes
exam	13	25	1462	2	exam
exams	14	19	908	2	exams
exes	11	65	3081	2	exes
extras	13	3	1022	2	extras
eyass	8	44	1078	2	eyass
eyes	7	58	3788	2	eyes
eyra	7	62	1755	2	eyra_
eyres	8	49	2177	2	eyres
fas	6	82	6293	2	_fas
fears	8	48	2939	2	fears
feral	8	54	2465	2	feral
ferals	9	42	1664	2	ferals
feres	8	60	3818	2	feres
ferias	9	50	2039	2	ferias
ferns	8	52	2008	2	ferns
fetas	8	56	2440	2	fetas
frae	7	53	3047	2	frae
frag	8	51	2627	2	frag
frags	9	63	2216	2	frags
frap	9	59	2581	2	frap
fraps	10	56	2055	2	fraps
frass	8	53	2112	2	frass
frat	7	56	4854	2	frat
frats	8	68	2967	2	frats
fray	10	54	2890	2	fray
frays	11	69	2010	2	frays
gars	5	57	5074	2	gars
gas	4	88	7025	2	_gas
gears	6	46	2869	2	gears
gerah	9	3	1530	2	gerah
gerahs	10	3	941	2	gerahs
germs	8	51	1887	2	germs
getas	6	54	2148	2	getas
goas	5	52	3994	2	goas
grab	7	54	2761	2	grab
grabs	8	57	1969	2	grabs
grad	6	68	2986	2	grad
grads	7	56	2575	2	grads
gram	7	70	3458	2	gram
grams	8	53	2731	2	grams
gran	5	63	3501	2	gran
grans	6	48	3254	2	grans
grasp	8	48	1448	2	grasp
grass	6	61	2520	2	grass
grat	5	56	5128	2	grat
gray	8	53	2989	2	gray
grays	9	56	2133	2	grays
has	6	73	7265	2	_has
hears	8	67	3737	2	hears
herbs	10	55	2050	2	herbs
herds	9	64	2468	2	herds
heres	8	62	4590	2	heres
herls	8	52	2643	2	herls
herms	10	56	2643	2	herms
herns	8	48	2558	2	herns
heros	8	49	3086	2	heros
hers	7	58	4487	2	her_s
horas	8	63	3310	2	horas
ires	4	56	3928	2	ires
iris	4	57	3255	2	iris
irks	8	62	2013	2	irks
jars	11	73	3835	2	jars
jerks	16	65	1489	2	jerks
kaas	8	65	3184	2	kaas
kas	7	70	5858	2	_kas
keas	8	63	3709	2	keas
kerbs	11	50	1367	2	kerbs
kerfs	12	54	1357	2	kerfs
kerns	9	47	1956	2	kerns
koas	8	56	3509	2	koas
koras	9	59	2711	2	koras
kris	8	64	2360	2	kris
kvas	11	70	1594	2	kvas
lars	4	69	5657	2	lars
las	3	72	8147	2	_las
lears	5	59	3873	2	lears
leas	4	59	5418	2	leas
liras	5	60	2198	2	liras
maras	7	54	4328	2	maras
mars	6	62	6187	2	mars
mas	5	81	7582	2	_mas
mercs	9	60	2045	2	mercs
meres	7	51	4357	2	meres
merks	11	47	2240	2	merks
merls	7	74	2390	2	merls
mesas	7	68	2320	2	mesas
moas	6	55	4534	2	moas
moras	7	64	3877	2	moras
muras	7	53	2956	2	muras
nears	5	55	2942	2	nears
nemas	7	53	2157	2	nemas
nerds	6	57	1925	2	nerds
nerts	5	59	2498	2	nerts
oars	4	68	4603	2	oars
obas	6	57	3093	2	obas
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
okas	8	52	2539	2	okas
okras	9	44	1097	2	okras
operas	8	3	1245	2	operas
ora	3	72	5083	2	ora_
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
orals	5	58	2648	2	orals
orbs	6	66	2625	2	orbs
orcas	7	59	1862	2	orcas
orcs	6	70	2543	2	orcs
ores	4	60	5668	2	ores
ors	3	57	5011	2	or_s
orts	4	65	3833	2	orts
paras	7	61	4304	2	paras
pars	6	75	6079	2	pars
pas	5	87	7574	2	_pas
pears	7	51	3861	2	pears
peas	6	57	5506	2	peas
peres	7	62	4664	2	peres
peris	7	55	3707	2	peris
perks	11	53	2580	2	perks
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
pervs	10	51	1737	2	pervs
pias	6	65	4255	2	pias
pram	8	57	3349	2	pram
prams	9	61	2551	2	prams
prao	6	62	2902	2	prao
praos	7	49	2356	2	praos
prase	7	61	2875	2	prase
prat	6	59	5204	2	prat
prats	7	63	3339	2	prats
prau	6	65	2947	2	prau
praus	7	46	2175	2	praus
pray	9	63	3153	2	pray
prays	10	50	2243	2	prays
proas	7	50	2880	2	proas
pros	6	57	4278	2	pros
pyas	9	62	2570	2	pyas
rad	4	76	6200	2	_rad
rads	5	60	4660	2	_rads
rag	4	57	6132	2	_rag
rags	5	54	4837	2	_rags
rah	6	80	5240	2	_rah
rai	3	76	5822	2	_rai
rais	4	52	5262	2	_rais
raj	10	57	4022	2	_raj
ram	5	68	6727	2	_ram
rams	6	59	5077	2	_rams
ran	3	82	6662	2	_ran
rap	5	62	6196	2	_rap
raps	6	62	4773	2	_raps
rase	4	61	4998	2	_rase
rash	7	60	3993	2	_rash
rasp	6	60	2916	2	_rasp
rat	3	78	9274	2	_rat
rats	4	62	6037	2	_rats
raw	6	72	5225	2	_raw
raws	7	52	3821	2	_raws
rax	10	84	4572	2	_rax
ray	6	63	6199	2	_ray
rays	7	76	4235	2	_rays
read	5	59	4253	2	read
reads	6	48	3527	2	reads
real	4	57	5029	2	real
reals	5	50	3865	2	reals
ream	6	58	4161	2	ream
reams	7	57	2962	2	reams
reap	6	59	3474	2	reap
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear
rears	5	47	3965	2	rears
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
reran	5	73	2910	2	reran
res	3	55	6504	2	_res
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rias	4	55	4059	2	rias
ryas	7	72	2461	2	ryas
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
sera	4	61	4139	2	sera_
serac	7	59	2520	2	serac
seracs	8	44	1857	2	seracs
serai	5	68	3016	2	serai
serais	6	43	2613	2	serais
seral	5	63	3638	2	seral
seres	5	54	4889	2	seres
serfs	8	49	2201	2	serfs
sers	4	57	4665	2	ser_s
skas	8	53	2571	2	skas
soras	5	50	4101	2	soras
spas	6	70	3672	2	spas
sris	4	54	3415	2	sris
suras	5	53	3632	2	suras
tars	4	67	6395	2	tars
tas	3	84	7710	2	_tas
tears	5	54	3646	2	tears
teas	4	58	5149	2	teas
tepas	7	65	2168	2	tepas
terai	5	35	2548	2	terai
terais	6	40	2351	2	terais
terms	7	55	2347	2	terms
terns	5	52	2687	2	terns
terras	6	35	1697	2	terras
tetras	6	30	1762	2	tetras
texas	12	65	1493	2	texas
toras	5	55	4037	2	toras
trad	5	56	3091	2	trad
tram	6	70	3455	2	tram
trams	7	53	2767	2	trams
trans	5	49	3304	2	trans
trap	6	75	3280	2	trap
traps	7	57	2748	2	traps
trash	8	61	1976	2	trash
trass	5	62	2647	2	trass
tray	7	76	3259	2	tray
trays	8	56	2343	2	trays
tres	4	65	4290	2	tres
twas	7	68	2408	2	twas
upas	6	83	2238	2	upas
urase	5	46	2468	2	urase
urbs	6	59	2205	2	urbs
urds	5	59	2242	2	urds
ureas	5	58	2601	2	ureas
urns	4	63	2389	2	urns
urps	6	69	2047	2	urps
ursa	4	41	1690	2	ursa
urus	4	64	2613	2	urus
utas	4	59	2495	2	utas
varas	8	60	2819	2	varas
vars	7	57	4207	2	vars
vas	6	77	5577	2	_vas
vera	7	68	2884	2	vera_
verbs	10	46	1439	2	verbs
verts	8	57	2473	2	verts
wars	7	86	5980	2	wars
was	6	87	6756	2	_was
wears	8	60	3030	2	wears
wekas	12	39	1179	2	wekas
wrap	9	68	2197	2	wrap
wraps	10	56	1715	2	wraps
xerus	12	3	1333	2	xerus
years	8	45	2767	2	years
yeas	7	86	3842	2	yeas
yerbas	11	11	929	2	yerbas
yerks	12	54	1656	2	yerks
zas	12	69	4683	2	_zas
zebras	17	3	785	2	zebras
zerks	18	51	1382	2	zerks
zeros	14	49	1811	2	zeros
zetas	14	50	1816	2	zetas

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.063	2836365.1
2	DLD Change Limit	29872	432	0.873	34217.6
3	Display Results	432	432	0.110	3927.3
	(SQL Overall)	178691	432	1.046	170832.7