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

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

299 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
eta	3	58	3419	(None)
beta	6	62	3413	1	beta
eat	3	69	8905	1	eat
era	3	57	4150	1	era
et	2	69	6419	1	et_
etas	4	64	3227	1	etas
eth	6	66	3098	1	eth
etna	4	64	1526	1	etna
feta	7	65	2890	1	feta
geta	5	66	2744	1	geta
meta	6	59	3241	1	meta
seta	4	56	3731	1	seta
ta	2	116	6245	1	_ta
tea	3	73	5332	1	tea
uta	3	74	2558	1	uta
zeta	13	51	2164	1	zeta
aa	2	191	7995	2	_aa
aba	5	128	5095	2	aba
aceta	7	40	1735	2	aceta
acta	6	95	2480	2	acta
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
anta	4	68	3958	2	anta
at	2	123	9340	2	at_
atap	6	67	2245	2	atap
ate	3	70	5924	2	ate
atma	6	81	2177	2	atma
att	3	54	5465	2	att
ava	6	101	3932	2	ava
awa	6	119	3967	2	awa
ba	4	99	6234	2	_ba
baa	5	106	5042	2	baa
bat	5	109	8895	2	bat
beat	6	61	6830	2	beat
bema	8	58	2525	2	bema
bet	5	83	7667	2	bet_
betas	7	55	2876	2	betas
beth	9	66	2923	2	beth
bets	6	70	5144	2	bets
betta	7	49	1684	2	betta
boa	5	69	5403	2	boa
bota	6	62	3650	2	bota
bra	5	63	3946	2	bra
cat	5	82	8234	2	cat
ceca	8	48	2078	2	ceca
cesta	7	54	1948	2	cesta
cete	6	49	3478	2	cete
data	5	60	2665	2	data
delta	6	61	1777	2	delta
deva	8	57	2098	2	deva
dita	5	60	3252	2	dita
ear	3	68	6788	2	ear
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eau	3	74	5094	2	eau
ebb	7	24	1863	2	ebb
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
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
efts	7	65	1948	2	efts
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
entia	5	3	1820	2	entia
eon	3	60	5208	2	eon
epha	9	3	1005	2	epha
er	2	83	4514	2	e_r
eras	4	54	4150	2	eras
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
err	3	56	2653	2	err
ers	3	60	4628	2	ers
es	2	90	4822	2	e_s
ess	3	60	3088	2	ess
etape	7	44	1370	2	etape
etch	9	54	1914	2	etch
eths	7	66	1952	2	eths
etic	6	61	2395	2	etic
etnas	5	47	1393	2	etnas
etui	4	54	1623	2	etui
etyma	10	3	658	2	etyma
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
eyra	7	62	1755	2	eyra
fa	5	101	4845	2	_fa
fat	6	81	7808	2	fat
feat	7	64	5822	2	feat
fet	6	64	7163	2	fet_
fetal	8	56	2337	2	fetal
fetas	8	56	2440	2	fetas
fete	7	57	3492	2	fete
fets	7	53	4594	2	fets
gat	4	68	8051	2	gat
get	4	74	6746	2	get_
getas	6	54	2148	2	getas
gets	5	54	4248	2	gets
goa	4	73	4380	2	goa
ha	5	102	5994	2	_ha
hat	6	72	8996	2	hat
heat	7	70	6142	2	heat
het	6	76	7431	2	het_
heth	10	70	2802	2	heth
hets	7	55	4720	2	hets
iota	4	51	2783	2	iota
it	2	84	5568	2	it_
its	3	55	3883	2	its
jet	10	67	5482	2	jet_
jete	11	59	2725	2	jete
jets	11	58	3410	2	jets
jota	11	64	2362	2	jota
ka	6	91	4508	2	_ka
kat	7	74	6829	2	kat
kata	8	56	2602	2	kata
kea	7	65	4091	2	kea
keto	8	62	2345	2	keto
koa	7	67	3777	2	koa
la	2	192	6163	2	_la
lat	3	75	9340	2	lat
lea	3	76	6018	2	lea
lepta	7	57	1439	2	lepta
let	3	64	8147	2	let_
lets	4	71	4794	2	lets
leva	7	70	2071	2	leva
lota	4	72	3350	2	lota
ma	4	100	6065	2	_ma
mat	5	80	8393	2	mat
meat	6	63	5960	2	meat
mega	7	76	2087	2	mega
menta	7	44	2442	2	menta
mesa	6	70	2548	2	mesa
met	5	60	7243	2	met_
metal	7	54	2738	2	metal
mete	6	44	3813	2	mete
meth	9	58	2784	2	meth
moa	5	72	4918	2	moa
na	2	86	5248	2	_na
neat	4	63	5678	2	neat
nema	6	55	2252	2	nema
net	3	66	7029	2	net_
nets	4	59	4153	2	nets
nett	4	66	4323	2	nett
nota	4	68	3077	2	nota
nth	6	63	2059	2	nth
oat	3	98	8826	2	oat
oba	5	75	3155	2	oba
oca	5	67	3173	2	oca
oda	4	81	3304	2	oda
oka	7	69	2680	2	oka
ora	3	72	5083	2	ora
ova	6	68	2379	2	ova
pa	4	104	5648	2	_pa
pat	5	80	8946	2	pat
pea	5	66	5724	2	pea
peat	6	59	6793	2	peat
pet	5	64	7730	2	pet_
petal	7	65	2689	2	petal
pets	6	62	4833	2	pets
pia	5	68	4803	2	pia
pieta	7	54	2175	2	pieta
pita	6	54	3643	2	pita
pya	8	70	2375	2	pya
qat	12	52	5333	2	qat
qua	12	48	2197	2	qua
rat	3	78	9274	2	rat
reata	5	42	2539	2	reata
recta	7	42	2026	2	recta
ret	3	59	8283	2	ret_
retag	6	36	1841	2	retag
retax	12	45	1797	2	retax
rete	4	49	4413	2	rete
retia	5	53	2611	2	retia
rets	4	53	5256	2	rets
ria	3	67	4550	2	ria
rota	4	58	3434	2	rota
rya	6	76	2201	2	rya
sat	3	62	8848	2	sat
sea	3	61	6129	2	sea
seat	4	75	7556	2	seat
septa	7	55	1808	2	septa
sera	4	61	4139	2	sera
set	3	66	8125	2	set_
setae	5	60	2622	2	setae
setal	5	64	3090	2	setal
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
sha	6	98	3778	2	sha
ska	7	69	2586	2	ska
spa	5	57	3081	2	spa
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
star	4	80	3776	2	star
stat	4	73	5269	2	stat
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stoa	4	54	2591	2	stoa
sty	6	62	2731	2	sty
tab	5	74	6032	2	_tab
tad	4	79	5982	2	_tad
tae	3	82	6705	2	_tae
tag	4	72	5949	2	_tag
taj	10	64	4219	2	_taj
tam	5	86	6342	2	_tam
tan	3	71	6756	2	_tan
tao	3	83	5895	2	_tao
tap	5	76	6387	2	_tap
tar	3	75	7069	2	_tar
tas	3	84	7710	2	_tas
tat	3	76	9029	2	_tat
tau	3	68	5690	2	_tau
tav	6	60	4321	2	_tav
taw	6	101	5545	2	_taw
tax	10	94	4915	2	_tax
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
tecta	7	42	1552	2	tecta
ted	4	64	4656	2	ted
tee	3	83	6687	2	tee
teg	4	57	4162	2	teg
tel	3	56	4790	2	tel
tela	4	55	3297	2	tela
ten	3	58	5611	2	ten
tepa	6	60	2168	2	tepa
testa	5	48	2204	2	testa
tet	3	92	7498	2	tet
teth	7	63	2788	2	teth
tetra	5	34	1795	2	tetra
tets	4	58	4745	2	tets
tew	6	66	4015	2	tew
theta	8	34	1457	2	theta
ti	2	84	4829	2	_ti
to	2	188	5898	2	_to
twa	6	77	2164	2	twa
ut	2	86	4703	2	ut_
utas	4	59	2495	2	utas
ute	3	53	3588	2	ute
uts	3	55	3437	2	uts
vat	6	78	6345	2	vat
vela	7	57	2554	2	vela
vena	7	61	2629	2	vena
vera	7	68	2884	2	vera
vesta	8	66	1830	2	vesta
vet	6	59	5852	2	vet_
veto	7	66	2299	2	veto
vets	7	68	3509	2	vets
via	6	56	3624	2	via
vita	7	58	2852	2	vita
wat	6	73	7892	2	wat
weka	11	70	1387	2	weka
wet	6	59	6662	2	wet_
wets	7	59	4029	2	wets
wha	9	64	2207	2	wha
ya	5	102	5150	2	_ya
yea	6	64	4575	2	yea
yenta	8	39	1704	2	yenta
yet	6	69	6069	2	yet_
yeti	7	58	2321	2	yeti
yett	7	64	3449	2	yett
za	11	149	3920	2	_za
zetas	14	50	1816	2	zetas
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.060	2978183.3
2	DLD Change Limit	14084	299	0.346	40705.2
3	Display Results	299	299	0.063	4746.0
	(SQL Overall)	178691	299	0.469	381004.3