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

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

207 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
beth	9	66	2923	(None)
bath	9	59	4008	1	bath
berth	10	49	1788	1	berth
bet	5	83	7667	1	bet_
beta	6	62	3413	1	beta
beths	10	55	1922	1	beths
bets	6	70	5144	1	bets
both	9	65	3343	1	both
eth	6	66	3098	1	_eth
heth	10	70	2802	1	heth
meth	9	58	2784	1	meth
teth	7	63	2788	1	teth
abet	6	105	4794	2	abet_
abets	7	56	2167	2	abets
bach	11	61	3139	2	bach
bah	8	77	5535	2	b_ah
baht	9	67	4001	2	baht
baith	10	80	2313	2	baith
bash	9	152	4016	2	bash
bat	5	109	8895	2	bat_
batch	12	46	2010	2	batch
bate	6	65	5242	2	bate
bathe	10	58	2288	2	bathe
baths	10	59	2292	2	baths
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
be	4	79	4894	2	be__
beach	12	46	2389	2	beach
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beat	6	61	6830	2	beat
beats	7	60	4224	2	beats
beau	6	61	3727	2	beau
beck	12	62	2657	2	beck
bed	6	79	5062	2	be_d
beds	7	59	3778	2	beds
bedu	7	59	2369	2	bedu
bee	5	62	6240	2	be_e
beech	12	43	1550	2	beech
beef	9	62	3367	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
beets	7	61	3144	2	beets
beg	6	59	4413	2	be_g
begs	7	57	3383	2	begs
bel	5	71	4846	2	be_l
belch	12	44	1550	2	belch
bell	6	62	3718	2	bell
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
belts	7	59	3116	2	belts
bema	8	58	2525	2	bema
ben	5	65	5492	2	be_n
bench	12	56	1950	2	bench
bend	7	64	3526	2	bend
bene	6	64	3949	2	bene
bens	6	59	4570	2	bens
bent	6	77	5991	2	bent
bento	7	59	2295	2	bento
bents	7	60	3369	2	bents
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
bertha	11	42	917	2	bertha
berths	11	47	1242	2	berths
bes	5	65	5743	2	be_s
best	6	63	5532	2	best
bests	7	59	3261	2	bests
betas	7	55	2876	2	betas
betel	7	44	1990	2	betel
bethel	11	6	964	2	bethel
beton	7	60	2206	2	beton
betta	7	49	1684	2	betta
bevy	12	71	1522	2	bevy
bey	8	66	4542	2	be_y
beys	9	138	2955	2	beys
birth	10	56	1987	2	birth
bit	5	70	7089	2	bit_
bitch	12	50	1776	2	bitch
bite	6	65	4699	2	bite
bits	6	61	4815	2	bits
bitt	6	55	4580	2	bitt
blah	9	86	2506	2	blah
blet	6	62	4767	2	blet_
blets	7	53	2494	2	blets
booth	10	55	2201	2	booth
bosh	9	63	2897	2	bosh
bot	5	96	8040	2	bot_
bota	6	62	3650	2	bota
botch	12	67	1745	2	botch
bothy	13	67	1396	2	bothy
bots	6	64	5395	2	bots
bott	6	65	4857	2	bott
breath	11	39	1626	2	breath
brith	10	49	2437	2	brith
broth	10	65	2109	2	broth
bush	9	66	3071	2	bush
but	5	59	6302	2	but_
butch	12	54	1654	2	butch
bute	6	67	3967	2	bute
buts	6	72	4769	2	buts
butt	6	51	4374	2	butt
byte	9	65	2181	2	byte
cete	6	49	3478	2	cete
cheth	13	50	1382	2	cheth
death	9	48	2252	2	death
depth	11	43	1185	2	depth
doeth	9	4	1198	2	doeth
doth	8	62	2571	2	doth
eath	7	57	3566	2	eath
edh	7	69	2156	2	_edh
eh	5	83	3996	2	_e_h
et	2	69	6419	2	_et_
eta	3	58	3419	2	_eta
etch	9	54	1914	2	_etch
eths	7	66	1952	2	_eths
feh	9	61	3609	2	fe_h
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
get	4	74	6746	2	get_
geta	5	66	2744	2	geta
gets	5	54	4248	2	gets
goth	8	68	2508	2	goth
hath	10	59	3391	2	hath
heath	11	57	2428	2	heath
heh	9	60	3962	2	he_h
het	6	76	7431	2	het_
heths	11	63	1778	2	heths
hets	7	55	4720	2	hets
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	2635	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	3744	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
neath	8	60	2028	2	neath
net	3	66	7029	2	net_
nets	4	59	4153	2	nets
nett	4	66	4323	2	nett
nth	6	63	2059	2	_nth
oath	7	61	3215	2	oath
obeah	10	3	899	2	obeah
path	9	91	3491	2	path
pech	11	61	2545	2	pech
peh	8	67	4096	2	pe_h
pet	5	64	7730	2	pet_
pets	6	62	4833	2	pets
pith	9	54	3269	2	pith
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
sith	7	54	3515	2	sith
soth	7	59	3251	2	soth
tech	9	59	2544	2	tech
teeth	8	73	1585	2	teeth
tenth	8	54	2183	2	tenth
tet	3	92	7498	2	tet_
teths	8	54	1851	2	teths
tets	4	58	4745	2	tets
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
yeah	10	67	2541	2	yeah
yech	12	72	2053	2	yech
yeh	9	71	3577	2	ye_h
yet	6	69	6069	2	yet_
yeti	7	58	2321	2	yeti
yett	7	64	3449	2	yett
zeta	13	51	2164	2	zeta
zibeth	20	3	417	2	zibeth

Search took 3 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.143	1249587.4
2	DLD Change Limit	29872	207	1.733	17237.2
3	Display Results	207	207	0.080	2587.5
	(SQL Overall)	178691	207	1.956	91355.3