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

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

381 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
era	3	57	4150	(None)
bra	5	63	3946	1	bra
ear	3	68	6788	1	ear
er	2	83	4514	1	er_
eras	4	54	4150	1	eras
ere	3	63	5277	1	ere
erg	4	55	3107	1	erg
ern	3	57	3835	1	ern
err	3	56	2653	1	err
ers	3	60	4628	1	ers
eta	3	58	3419	1	eta
eyra	7	62	1755	1	eyra
ora	3	72	5083	1	ora
sera	4	61	4139	1	sera
vera	7	68	2884	1	vera
aa	2	191	7995	2	_aa
aba	5	128	5095	2	aba
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
aga	4	104	4723	2	aga
aha	6	112	4664	2	aha
ala	3	124	6360	2	ala
ama	5	108	5330	2	ama
ana	3	95	5982	2	ana
ar	2	113	7938	2	ar_
arak	8	69	2957	2	arak
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
area	4	58	4339	2	area
arf	6	74	5337	2	arf
aria	4	62	4542	2	aria
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
aura	4	58	3625	2	aura
ava	6	101	3932	2	ava
awa	6	119	3967	2	awa
ba	4	99	6234	2	_ba
baa	5	106	5042	2	baa
bar	5	80	7055	2	bar
bear	6	68	4464	2	bear
bema	8	58	2525	2	bema
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
beta	6	62	3413	2	beta
boa	5	69	5403	2	boa
bora	6	61	4163	2	bora
brad	7	52	3434	2	brad
brae	6	56	3911	2	brae
brag	7	52	2972	2	brag
bran	6	57	4038	2	bran
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
bura	6	61	3953	2	bura
car	5	91	6556	2	car
ceca	8	48	2078	2	ceca
cere	6	67	4147	2	cere
ceria	7	51	2535	2	ceria
cero	6	63	2945	2	cero
crab	8	57	2767	2	crab
crag	7	56	2530	2	crag
cram	8	56	3549	2	cram
crap	8	57	3184	2	crap
craw	9	77	2526	2	craw
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
dear	5	53	4360	2	dear
derat	6	50	4408	2	derat
deray	9	50	2418	2	deray
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
derma	8	49	1851	2	derma
deva	8	57	2098	2	deva
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
dry	7	65	2603	2	dry
dura	5	52	3211	2	dura
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
ebb	7	24	1862	2	ebb
ecru	6	58	1953	2	ecru
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
eery	7	61	2962	2	eery
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
egad	6	42	1541	2	egad
egal	5	51	1943	2	egal
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eke	7	56	3009	2	eke
el	2	67	4529	2	e_l
elan	4	67	3424	2	elan
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
en	2	80	5239	2	e_n
end	4	68	3435	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon
epha	9	3	1005	2	epha
erase	5	49	2549	2	erase
ergo	5	64	2015	2	ergo
ergs	5	55	2381	2	ergs
erica	7	3	1654	2	erica
erne	4	67	2742	2	erne
erns	4	54	2822	2	erns
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
erst	4	74	3643	2	erst
es	2	90	4822	2	e_s
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
etas	4	64	3227	2	etas
eth	6	66	3098	2	eth
etna	4	64	1526	2	etna
euro	4	53	2527	2	euro
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
exam	13	25	1462	2	exam
extra	12	3	900	2	extra
eyas	7	64	2743	2	eyas
eye	6	55	3977	2	eye
eyras	8	47	1592	2	eyras
eyre	7	55	2525	2	eyre
eyry	10	63	1588	2	eyry
fa	5	101	4845	2	_fa
far	6	77	6260	2	far
fear	7	53	3779	2	fear
fer	6	66	4612	2	fer_
feral	8	54	2465	2	feral
fere	7	63	4223	2	fere
feria	8	59	2271	2	feria
fern	7	61	2932	2	fern
feta	7	65	2890	2	feta
fora	7	59	3739	2	fora
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
fro	6	55	3064	2	fro
fry	9	62	2650	2	fry
gar	4	72	5990	2	gar
gear	5	59	3497	2	gear
gerah	9	3	1530	2	gerah
germ	7	54	2896	2	germ
geta	5	66	2744	2	geta
goa	4	73	4380	2	goa
grab	7	54	2761	2	grab
grad	6	68	2986	2	grad
gram	7	70	3458	2	gram
gran	5	63	3501	2	gran
grat	5	56	5128	2	grat
gray	8	53	2989	2	gray
ha	5	102	5994	2	_ha
hear	7	61	4388	2	hear
her	6	65	4781	2	her_
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
here	7	64	4710	2	here
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
herma	10	53	1888	2	herma
hern	7	61	3489	2	hern
hero	7	46	3578	2	hero
hers	7	58	4487	2	hers
hora	7	61	3655	2	hora
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
jar	10	76	4615	2	jar
jerk	15	49	2013	2	jerk
jura	11	60	2489	2	jura
ka	6	91	4508	2	_ka
kea	7	65	4091	2	kea
kerb	10	43	2271	2	kerb
kerf	11	58	2746	2	kerf
kern	8	53	2621	2	kern
koa	7	67	3777	2	koa
kora	8	64	3155	2	kora
la	2	192	6163	2	_la
lar	3	79	6753	2	lar
lea	3	76	6018	2	lea
lear	4	70	4595	2	lear
leva	7	70	2071	2	leva
lira	4	69	2868	2	lira
ma	4	100	6065	2	_ma
mar	5	79	6594	2	mar
mara	6	74	4456	2	mara
mega	7	76	2087	2	mega
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mesa	6	70	2548	2	mesa
meta	6	59	3241	2	meta
moa	5	72	4918	2	moa
mora	6	66	4127	2	mora
mura	6	56	3329	2	mura
na	2	86	5248	2	_na
near	4	52	3650	2	near
nema	6	55	2252	2	nema
nerd	5	66	2494	2	nerd
oar	3	70	5795	2	oar
oba	5	75	3155	2	oba
oca	5	67	3173	2	oca
oda	4	81	3304	2	oda
oka	7	69	2680	2	oka
okra	8	64	1357	2	okra
opera	7	3	1357	2	opera
or	2	73	5473	2	or_
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
orca	6	55	2277	2	orca
ore	3	66	6183	2	ore
orra	4	61	2072	2	orra
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
ova	6	68	2379	2	ova
pa	4	104	5648	2	_pa
par	5	74	6702	2	par
para	6	52	4217	2	para
pea	5	66	5724	2	pea
pear	6	97	4523	2	pear
per	5	63	5309	2	per_
pere	6	64	5026	2	pere
perea	7	50	2644	2	perea
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pia	5	68	4803	2	pia
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prat	6	59	5204	2	prat
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
pro	5	58	3726	2	pro
proa	6	62	2996	2	proa
pry	8	57	2805	2	pry
pya	8	70	2375	2	pya
qua	12	48	2197	2	qua
rad	4	76	6200	2	_rad
rag	4	57	6132	2	_rag
rah	6	80	5240	2	_rah
rai	3	76	5822	2	_rai
raj	10	57	4022	2	_raj
ram	5	68	6727	2	_ram
ran	3	82	6661	2	_ran
rap	5	62	6196	2	_rap
ras	3	75	7539	2	_ras
rat	3	78	9274	2	_rat
raw	6	72	5225	2	_raw
rax	10	84	4572	2	_rax
ray	6	63	6199	2	_ray
re	2	61	5374	2	_re
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
reb	5	58	4496	2	reb
rec	5	56	4546	2	rec
red	4	67	5580	2	red
ree	3	79	7407	2	ree
ref	6	60	5329	2	ref
reg	4	61	4649	2	reg
rei	3	56	4725	2	rei
rem	5	61	5004	2	rem
rep	5	58	4780	2	rep
reran	5	73	2910	2	reran
res	3	55	6504	2	res
ret	3	59	8283	2	ret
rev	6	53	3662	2	rev
rex	10	57	4099	2	rex
ria	3	67	4550	2	ria
rya	6	76	2201	2	rya
sea	3	61	6129	2	sea
sear	4	73	5384	2	sear
ser	3	67	5240	2	ser_
serac	7	59	2520	2	serac
serai	5	68	3016	2	serai
seral	5	63	3638	2	seral
sere	4	61	5347	2	sere
serf	7	63	4011	2	serf
sers	4	57	4665	2	sers
seta	4	56	3731	2	seta
sha	6	98	3778	2	sha
ska	7	69	2586	2	ska
sora	4	57	4691	2	sora
spa	5	57	3081	2	spa
sri	3	56	3400	2	sri
sura	4	57	4029	2	sura
ta	2	116	6245	2	_ta
tar	3	75	7069	2	tar
tea	3	73	5332	2	tea
tear	4	52	4288	2	tear
tela	4	55	3297	2	tela
tepa	6	60	2168	2	tepa
terai	5	35	2548	2	terai
terga	6	33	1564	2	terga
term	6	62	3315	2	term
tern	4	61	3480	2	tern
terra	5	44	1965	2	terra
tetra	5	34	1795	2	tetra
tora	4	75	4599	2	tora
trad	5	56	3091	2	trad
tram	6	70	3455	2	tram
trap	6	75	3280	2	trap
tray	7	76	3259	2	tray
try	6	65	2967	2	try
twa	6	77	2164	2	twa
urb	5	57	3110	2	urb
urd	4	64	2704	2	urd
urea	4	65	2805	2	urea
urn	3	57	3146	2	urn
urp	5	64	2639	2	urp
ursa	4	41	1690	2	ursa
uta	3	74	2558	2	uta
var	6	61	4833	2	var
vara	7	55	3088	2	vara
vela	7	57	2554	2	vela
vena	7	61	2629	2	vena
verb	9	62	2487	2	verb
vert	7	72	4937	2	vert
very	10	80	2564	2	very
via	6	56	3624	2	via
war	6	72	6242	2	war
wear	7	58	3672	2	wear
weka	11	70	1387	2	weka
were	7	62	3833	2	were
wert	7	97	4982	2	wert
wha	9	64	2207	2	wha
wrap	9	68	2197	2	wrap
wry	9	65	2470	2	wry
ya	5	102	5150	2	_ya
yar	6	72	5383	2	yar
yea	6	64	4575	2	yea
year	7	65	3425	2	year
yerba	10	10	1076	2	yerba
yerk	11	62	2208	2	yerk
za	11	149	3920	2	_za
zebra	16	3	788	2	zebra
zerk	17	53	1925	2	zerk
zero	13	48	2246	2	zero
zeta	13	51	2164	2	zeta
zoa	12	85	2999	2	zoa

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	381	0.420	33533.3
3	Display Results	381	381	0.093	4096.8
	(SQL Overall)	178691	381	0.576	310227.4