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

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

387 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
teat	4	59	6363	(None)
beat	6	61	6830	1	beat
eat	3	69	8905	1	_eat
feat	7	64	5822	1	feat
heat	7	70	6142	1	heat
meat	6	63	5960	1	meat
neat	4	63	5678	1	neat
peat	6	59	6793	1	peat
seat	4	75	7556	1	seat
tat	3	76	9029	1	t_at
tea	3	73	5332	1	tea_
teak	8	59	3084	1	teak
teal	4	55	4650	1	teal
team	6	62	3865	1	team
tear	4	52	4288	1	tear
teas	4	58	5149	1	teas
teats	5	56	3681	1	teats
tent	4	61	5986	1	tent
test	4	86	5162	1	test
tet	3	92	7499	1	te_t
text	11	60	3393	1	text
that	7	56	3932	1	that
treat	5	62	4035	1	treat
twat	7	58	3151	1	twat
at	2	123	9340	2	__at
bat	5	109	8895	2	_bat
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
beast	7	63	3864	2	beast
beats	7	60	4224	2	beats
beau	6	61	3727	2	beau
beaut	7	51	3521	2	beaut
beet	6	64	5754	2	beet
begat	8	66	2972	2	begat
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
beta	6	62	3413	2	beta
blat	6	65	5095	2	blat
bleat	7	57	3700	2	bleat
boat	6	63	6031	2	boat
brat	6	60	5554	2	brat
cat	5	82	8234	2	_cat
celt	6	56	4671	2	celt
cent	6	74	5101	2	cent
chat	9	55	4613	2	chat
cheat	10	57	3245	2	cheat
cleat	7	63	3506	2	cleat
coat	6	75	5835	2	coat
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
death	9	48	2252	2	death
debt	7	71	3902	2	debt
deet	5	73	5658	2	deet
defat	9	54	2669	2	defat
deft	8	55	4022	2	deft
delt	5	78	5527	2	delt
dent	5	71	5841	2	dent
derat	6	50	4408	2	derat
doat	5	69	4767	2	doat
drat	5	62	4783	2	drat
ear	3	68	6788	2	_ear
east	4	66	5910	2	_east
eath	7	57	3566	2	_eath
eats	4	70	5487	2	_eats
eau	3	74	5094	2	_eau
eft	6	60	3882	2	_eft
et	2	69	6419	2	_e_t
eta	3	58	3419	2	eta_
etas	4	64	3227	2	etas
fat	6	81	7808	2	_fat
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feast	8	59	3272	2	feast
feats	8	64	3275	2	feats
feet	7	53	5221	2	feet
felt	7	51	4693	2	felt
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
feta	7	65	2890	2	feta
fiat	7	66	4664	2	fiat
flat	7	71	4782	2	flat
frat	7	56	4854	2	frat
gat	4	68	8051	2	_gat
gear	5	59	3497	2	gear
gelt	5	64	4801	2	gelt
gent	5	69	5439	2	gent
gest	5	61	4913	2	gest
get	4	74	6746	2	ge_t
geta	5	66	2744	2	geta
ghat	8	64	3528	2	ghat
gnat	5	60	3443	2	gnat
goat	5	62	5083	2	goat
grat	5	56	5128	2	grat
great	6	60	3424	2	great
haet	7	56	5950	2	haet
hat	6	72	8996	2	_hat
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heart	8	54	4074	2	heart
heath	11	57	2428	2	heath
heats	8	58	3840	2	heats
heft	10	67	3629	2	heft
hent	7	66	5638	2	hent
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
ikat	8	76	2664	2	ikat
jean	11	66	2928	2	jean
jest	11	67	3850	2	jest
jet	10	67	5482	2	je_t
kat	7	74	6829	2	_kat
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
keet	8	53	4734	2	keet
kelt	8	53	4319	2	kelt
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
khat	11	67	3072	2	khat
kyat	11	60	2552	2	kyat
lat	3	75	9340	2	_lat
lea	3	76	6018	2	lea_
lead	5	60	3885	2	lead
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leant	5	67	3778	2	leant
leap	6	60	3268	2	leap
leapt	7	50	2747	2	leapt
lear	4	70	4595	2	lear
leas	4	59	5418	2	leas
least	5	61	3488	2	least
leet	4	59	5790	2	leet
left	7	63	4048	2	left
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
mat	5	80	8394	2	_mat
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meant	7	65	3721	2	meant
meats	7	50	3405	2	meats
meaty	10	70	2131	2	meaty
meet	6	53	5055	2	meet
melt	6	57	5289	2	melt
met	5	60	7243	2	me_t
meta	6	59	3241	2	meta
moat	6	63	5203	2	moat
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neath	8	60	2028	2	neath
neats	5	59	3190	2	neats
nest	4	55	4873	2	nest
net	3	66	7029	2	ne_t
nett	4	66	4323	2	nett
newt	7	69	3374	2	newt
next	11	66	3108	2	next
oat	3	98	8826	2	_oat
outeat	6	28	2453	2	outeat
pat	5	80	8946	2	_pat
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
pelt	6	76	5108	2	pelt
pent	6	65	5907	2	pent
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
phat	9	58	3786	2	phat
plat	6	60	4887	2	plat
pleat	7	47	3447	2	pleat
prat	6	59	5204	2	prat
qat	12	52	5333	2	_qat
rat	3	78	9274	2	_rat
react	7	46	3433	2	react
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
reata	5	42	2539	2	reata
reft	7	51	4127	2	reft
rent	4	66	6124	2	rent
resat	5	51	3968	2	resat
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
sat	3	62	8848	2	_sat
scat	6	58	4837	2	scat
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seats	5	48	4434	2	seats
sect	6	74	4362	2	sect
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	se_t
seta	4	56	3731	2	seta
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
shat	7	64	5660	2	shat
skat	8	70	3790	2	skat
slat	4	69	5902	2	slat
spat	6	65	4852	2	spat
stat	4	73	5269	2	stat
stead	6	55	2027	2	stead
steak	9	52	1980	2	steak
steal	5	61	2547	2	steal
steam	7	63	2293	2	steam
stent	5	56	3451	2	stent
stet	4	59	4732	2	ste_t
stoat	5	71	3595	2	stoat
swat	7	72	4444	2	swat
sweat	8	56	2840	2	sweat
ta	2	116	6245	2	t_a_
tab	5	74	6032	2	t_ab
tact	6	73	4903	2	tact
tad	4	79	5982	2	t_ad
tae	3	82	6705	2	t_ae
tael	4	60	3071	2	tael
tag	4	72	5949	2	t_ag
taj	10	64	4219	2	t_aj
tam	5	86	6342	2	t_am
tan	3	71	6757	2	t_an
tao	3	83	5895	2	t_ao
tap	5	76	6387	2	t_ap
tar	3	75	7069	2	t_ar
tart	4	75	6618	2	tart
tas	3	84	7710	2	t_as
tate	4	47	4860	2	t_ate
tats	4	68	5813	2	t_ats
tau	3	68	5690	2	t_au
taut	4	70	4896	2	taut
tav	6	60	4321	2	t_av
taw	6	101	5545	2	t_aw
tax	10	94	4915	2	t_ax
teach	10	52	2112	2	teach
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
teapot	8	4	1676	2	teapot
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
tease	5	54	2871	2	tease
teated	7	49	2402	2	teated
tech	9	59	2544	2	tech
tecta	7	42	1552	2	tecta
ted	4	64	4656	2	te_d
teds	5	49	3257	2	teds
tee	3	83	6687	2	te_e
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
teeth	8	73	1585	2	teeth
teff	10	60	2376	2	teff
teg	4	57	4162	2	te_g
tegg	6	53	1592	2	tegg
tegs	5	60	3149	2	tegs
tel	3	56	4790	2	te_l
tela	4	55	3297	2	tela
telae	5	43	2329	2	telae
tele	4	50	4087	2	tele
tell	4	49	3470	2	tell
tels	4	68	4169	2	tels
temp	8	53	2333	2	temp
tempt	9	51	2484	2	tempt
ten	3	58	5611	2	te_n
tenant	6	3	2247	2	tenant
tend	5	64	3377	2	tend
tenet	5	55	4221	2	tenet
tens	4	56	4741	2	tens
tenth	8	54	2183	2	tenth
tents	5	64	3421	2	tents
tenty	8	61	2160	2	tenty
tepa	6	60	2168	2	tepa
tepal	7	63	1958	2	tepal
tepas	7	65	2168	2	tepas
terai	5	35	2548	2	terai
term	6	62	3315	2	term
tern	4	61	3480	2	tern
testa	5	48	2204	2	testa
tests	5	65	3019	2	tests
testy	8	54	1906	2	testy
teth	7	63	2789	2	teth
tets	4	58	4746	2	tets
tew	6	66	4015	2	te_w
tews	7	64	3164	2	tews
texas	12	65	1493	2	texas
texts	12	55	1504	2	texts
thae	7	68	2556	2	thae
than	7	61	2877	2	than
thaw	10	75	2131	2	thaw
theft	11	41	1813	2	theft
theta	8	34	1457	2	theta
threat	9	50	2046	2	threat
tilt	4	62	5242	2	tilt
tint	4	67	5886	2	tint
tit	3	67	7105	2	t_it
toad	5	58	3018	2	toad
toast	5	58	3101	2	toast
toea	4	67	3233	2	toea_
toeas	5	57	2642	2	toeas
toft	7	74	4165	2	toft
toit	4	63	5306	2	toit
toot	4	59	5888	2	toot
tort	4	69	6746	2	tort
tost	4	83	5192	2	tost
tot	3	88	8477	2	t_ot
tout	4	67	5382	2	tout
tract	7	56	3571	2	tract
trad	5	56	3091	2	trad
trait	5	69	4084	2	trait
tram	6	70	3455	2	tram
trap	6	75	3280	2	trap
trapt	7	64	3339	2	trapt
tray	7	76	3259	2	tray
tread	6	48	2170	2	tread
treats	6	48	2169	2	treats
treaty	9	44	1435	2	treaty
tret	4	66	5353	2	tret
trot	4	63	5131	2	trot
tsar	4	78	1980	2	tsar
tuft	7	69	2951	2	tuft
tut	3	67	5809	2	t_ut
twa	6	77	2164	2	twa_
twae	7	47	1957	2	twae
twas	7	68	2408	2	twas
twats	8	66	1660	2	twats
tweak	12	5	775	2	tweak
tweet	8	48	2398	2	tweet
twit	7	63	2906	2	twit
tzar	13	63	1537	2	tzar
vat	6	78	6345	2	_vat
veal	7	69	3681	2	veal
vent	7	60	4905	2	vent
vert	7	72	4937	2	vert
vest	7	57	4360	2	vest
vet	6	59	5852	2	ve_t
vext	14	69	2776	2	vext
wat	6	73	7892	2	_wat
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
welt	7	55	4786	2	welt
went	7	60	5187	2	went
wept	9	56	3505	2	wept
wert	7	97	4982	2	wert
west	7	57	4808	2	west
wet	6	59	6662	2	we_t
what	10	54	3407	2	what
wheat	11	49	2457	2	wheat
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
year	7	65	3425	2	year
yeas	7	86	3842	2	yeas
yeast	8	53	2794	2	yeast
yet	6	69	6069	2	ye_t
yett	7	64	3449	2	yett
zeal	13	55	3033	2	zeal
zest	13	60	3570	2	zest
zeta	13	51	2164	2	zeta

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.296	603685.8
2	DLD Change Limit	29872	387	0.906	32971.3
3	Display Results	387	387	0.093	4161.3
	(SQL Overall)	178691	387	1.295	137985.3