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

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

218 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
eth	6	66	3098	(None)
beth	9	66	2923	1	beth
eath	7	57	3566	1	eath
edh	7	69	2156	1	edh
eh	5	83	3996	1	e_h
et	2	69	6419	1	et_
eta	3	58	3419	1	eta
etch	9	54	1914	1	etch
eths	7	66	1952	1	eths
heth	10	70	2802	1	heth
meth	9	58	2784	1	meth
nth	6	63	2059	1	nth
teth	7	63	2789	1	teth
aah	6	162	5296	2	aah
ah	5	138	6879	2	_ah
ash	6	79	4460	2	ash
at	2	123	9340	2	at_
ate	3	70	5924	2	ate
att	3	54	5465	2	att
bah	8	77	5535	2	bah
bath	9	59	4008	2	bath
berth	10	49	1788	2	berth
bet	5	83	7667	2	bet_
beta	6	62	3413	2	beta
beths	10	55	1922	2	beths
bets	6	70	5144	2	bets
both	9	65	3343	2	both
cete	6	49	3478	2	cete
cheth	13	50	1382	2	cheth
dah	7	81	4898	2	dah
death	9	48	2252	2	death
depth	11	43	1185	2	depth
doeth	9	4	1198	2	doeth
doth	8	62	2571	2	doth
duh	7	79	3038	2	duh
each	9	55	3058	2	each
ear	3	68	6788	2	ear
earth	8	50	2305	2	earth
eat	3	69	8905	2	eat
eats	4	70	5487	2	eats
eau	3	74	5094	2	eau
ebb	7	24	1863	2	ebb
eche	9	75	2028	2	eche
echo	9	66	1595	2	echo
echt	9	57	2290	2	echt
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edhs	8	62	1210	2	edhs
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
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eke	7	56	3009	2	eke
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elhi	7	6	1240	2	elhi
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
er	2	83	4514	2	e_r
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3836	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
etas	4	64	3227	2	etas
ether	8	45	1877	2	ether
ethic	10	15	1122	2	ethic
ethos	8	55	1419	2	ethos
ethyl	11	3	651	2	ethyl
etic	6	61	2395	2	etic
etna	4	64	1526	2	etna
etui	4	54	1623	2	etui
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
eye	6	55	3977	2	eye
feh	9	61	3609	2	feh
fet	6	64	7163	2	fet_
feta	7	65	2890	2	feta
fetch	13	49	1347	2	fetch
fete	7	57	3492	2	fete
fets	7	53	4594	2	fets
foh	9	81	3589	2	foh
get	4	74	6746	2	get_
geta	5	66	2744	2	geta
gets	5	54	4248	2	gets
goth	8	68	2508	2	goth
hah	9	106	5522	2	hah
hath	10	59	3391	2	hath
heath	11	57	2428	2	heath
heh	9	60	3962	2	heh
het	6	76	7431	2	het_
heths	11	63	1778	2	heths
hets	7	55	4720	2	hets
huh	9	64	3201	2	huh
ich	8	62	2774	2	ich
it	2	84	5568	2	it_
itch	9	56	1917	2	itch
its	3	55	3883	2	its
jet	10	67	5482	2	jet_
jete	11	59	2725	2	jete
jets	11	58	3410	2	jets
ketch	14	49	1202	2	ketch
keto	8	62	2345	2	keto
kheth	15	50	975	2	kheth
kith	11	58	2636	2	kith
lath	7	66	4038	2	lath
lech	9	68	2544	2	lech
let	3	64	8147	2	let_
letch	10	52	1580	2	letch
lethe	8	57	1730	2	lethe
lets	4	71	4794	2	lets
loth	7	61	3213	2	loth
math	9	54	3745	2	math
mesh	9	68	2300	2	mesh
met	5	60	7243	2	met_
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
meths	10	53	2023	2	meths
moth	9	67	3133	2	moth
myth	12	67	1543	2	myth
nah	6	98	4700	2	nah
neath	8	60	2028	2	neath
net	3	66	7029	2	net_
nets	4	59	4153	2	nets
nett	4	66	4323	2	nett
noh	6	66	4064	2	noh
oath	7	61	3215	2	oath
oh	5	74	4700	2	_oh
ooh	6	76	3709	2	ooh
pah	8	88	5359	2	pah
path	9	91	3491	2	path
pech	11	61	2545	2	pech
peh	8	67	4096	2	peh
pet	5	64	7730	2	pet_
pets	6	62	4833	2	pets
pht	8	60	3052	2	pht
pith	9	54	3269	2	pith
poh	8	67	4053	2	poh
rah	6	80	5240	2	rah
rath	7	60	3766	2	rath
resh	7	65	2345	2	resh
ret	3	59	8283	2	ret_
retch	10	48	1830	2	retch
rete	4	49	4413	2	rete
rets	4	53	5256	2	rets
ruth	7	68	2599	2	ruth
set	3	66	8125	2	set_
seta	4	56	3731	2	seta
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
sh	5	68	2852	2	_sh
shh	9	71	2107	2	shh
sith	7	54	3515	2	sith
soth	7	59	3252	2	soth
sty	6	62	2731	2	sty
ta	2	116	6245	2	_ta
tea	3	73	5332	2	tea
tech	9	59	2544	2	tech
ted	4	64	4656	2	ted
tee	3	83	6687	2	tee
teeth	8	73	1585	2	teeth
teg	4	57	4162	2	teg
tel	3	56	4790	2	tel
ten	3	58	5611	2	ten
tenth	8	54	2183	2	tenth
tet	3	92	7499	2	tet
teths	8	54	1851	2	teths
tets	4	58	4746	2	tets
tew	6	66	4015	2	tew
the	6	74	3605	2	_the
tho	6	74	3396	2	_tho
thy	9	70	2291	2	_thy
ti	2	84	4829	2	_ti
to	2	188	5898	2	_to
ugh	7	65	2068	2	ugh
uh	5	74	2985	2	_uh
ut	2	86	4703	2	ut_
uta	3	74	2558	2	uta
ute	3	53	3588	2	ute
uts	3	55	3437	2	uts
vet	6	59	5852	2	vet_
vetch	13	44	1184	2	vetch
veto	7	66	2299	2	veto
vets	7	68	3509	2	vets
wet	6	59	6662	2	wet_
wets	7	59	4029	2	wets
with	10	57	3047	2	with
yah	9	90	4635	2	yah
yeah	10	67	2541	2	yeah
yech	12	72	2053	2	yech
yeh	9	71	3577	2	yeh
yet	6	69	6069	2	yet_
yeti	7	58	2321	2	yeti
yett	7	64	3449	2	yett
zeta	13	51	2164	2	zeta

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.266	671770.7
2	DLD Change Limit	14084	218	0.390	36112.8
3	Display Results	218	218	0.030	7266.7
	(SQL Overall)	178691	218	0.686	260482.5