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

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

477 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
seat	4	75	7556	(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
sat	3	62	8848	1	s_at
scat	6	58	4837	1	scat
sea	3	61	6129	1	sea_
seal	4	56	5437	1	seal
seam	6	66	4597	1	seam
sear	4	73	5384	1	sear
seas	4	57	5527	1	seas
seats	5	48	4434	1	seats
sect	6	74	4362	1	sect
sent	4	69	6301	1	sent
sept	6	58	4436	1	sept
set	3	66	8125	1	se_t
seta	4	56	3731	1	seta
sett	4	59	4905	1	sett
sext	11	73	3809	1	sext
shat	7	64	5659	1	shat
skat	8	70	3789	1	skat
slat	4	69	5902	1	slat
spat	6	65	4852	1	spat
stat	4	73	5269	1	stat
swat	7	72	4444	1	swat
sweat	8	56	2840	1	sweat
teat	4	59	6363	1	teat
asea	4	63	2718	2	asea_
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	5834	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
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	4733	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	8393	2	_mat
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3808	2	mean
meant	7	65	3720	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
miseat	8	29	2570	2	miseat
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
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
reseat	6	41	3149	2	reseat
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
sab	5	65	6320	2	s_ab
sac	5	74	5286	2	s_ac
sad	4	74	5920	2	s_ad
sae	3	83	6518	2	s_ae
sag	4	61	6340	2	s_ag
sal	3	64	6288	2	s_al
salt	4	57	5852	2	salt
sap	5	64	6323	2	s_ap
sate	4	55	5610	2	s_ate
sati	4	55	3932	2	s_ati
sau	3	63	5657	2	s_au
saw	6	82	5535	2	s_aw
sax	10	74	4764	2	s_ax
say	6	72	6476	2	s_ay
scab	8	59	2671	2	scab
scad	7	57	2576	2	scad
scag	7	66	2689	2	scag
scam	8	59	3235	2	scam
scan	6	55	3045	2	scan
scant	7	97	3507	2	scant
scar	6	64	3420	2	scar
scart	7	61	3977	2	scart
scats	7	59	3060	2	scats
scatt	7	60	3009	2	scatt
scent	7	58	3162	2	scent
scot	6	62	4260	2	scot
scut	6	58	3554	2	scut
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
seamy	10	59	2127	2	seamy
sears	5	47	4491	2	sears
seated	7	51	3105	2	seated
seater	6	45	3415	2	seater
sec	5	59	4532	2	se_c
secant	8	40	2329	2	secant
secs	6	50	3389	2	secs
sects	7	56	2289	2	sects
sedan	6	56	2042	2	sedan
sedate	7	30	1980	2	sedate
see	3	57	7226	2	se_e
seed	5	55	4948	2	seed
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seer	4	55	4704	2	seer
sees	4	53	6105	2	sees
seg	4	55	4488	2	se_g
sego	5	65	2518	2	sego
segs	5	49	3388	2	segs
sei	3	60	4893	2	se_i
seif	7	56	3872	2	seif
seis	4	55	4239	2	seis
sejant	13	31	1448	2	sejant
sel	3	82	5332	2	se_l
selah	8	3	1961	2	selah
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
semi	6	51	2722	2	semi
sen	3	60	5852	2	se_n
senate	6	37	2514	2	senate
send	5	52	3729	2	send
sene	4	68	4805	2	sene
sente	5	64	3287	2	sente
senti	5	62	2669	2	senti
sepal	7	77	2300	2	sepal
septa	7	55	1808	2	septa
septs	7	54	2060	2	septs
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
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
setae	5	60	2622	2	setae
setal	5	64	3090	2	setal
sets	4	55	4950	2	sets
setts	5	51	2432	2	setts
sew	6	62	4726	2	se_w
sewan	8	59	2129	2	sewan
sewar	8	54	2109	2	sewar
sewn	7	61	2433	2	sewn
sews	7	58	3602	2	sews
sex	10	70	4322	2	se_x
sexto	12	44	1545	2	sexto
sexts	12	51	1838	2	sexts
sexy	14	64	1802	2	sexy
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shaft	11	57	2525	2	shaft
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
shalt	8	55	3448	2	shalt
sham	9	64	3635	2	sham
shaw	10	81	3255	2	shaw
shay	10	71	3334	2	shay
shea	7	60	3157	2	shea_
sheaf	11	54	2412	2	sheaf
sheal	8	49	2770	2	sheal
shear	8	54	2483	2	shear
sheas	8	63	3179	2	sheas
sheath	12	4	1288	2	sheath
sheet	8	48	3695	2	sheet
shent	8	59	3349	2	shent
shit	7	67	4593	2	shit
shoat	8	56	3394	2	shoat
shot	7	61	5024	2	shot
shut	7	61	3758	2	shut
sial	4	59	3883	2	sial
sift	7	107	4066	2	sift
silt	4	65	5819	2	silt
sit	3	58	7775	2	s_it
ska	7	69	2586	2	ska_
skag	9	63	2151	2	skag
skas	8	53	2571	2	skas
skate	9	47	2154	2	skate
skats	9	46	2153	2	skats
skean	9	44	1562	2	skean
skeet	9	54	2918	2	skeet
skit	8	54	3752	2	skit
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slam	6	77	3797	2	slam
slant	5	52	3870	2	slant
slap	6	64	3404	2	slap
slate	5	54	3828	2	slate
slats	5	54	3690	2	slats
slaty	8	65	2315	2	slaty
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept
slit	4	62	5010	2	slit
slot	4	60	4982	2	slot
slut	4	50	4059	2	slut
smalt	7	47	2933	2	smalt
smart	7	58	3409	2	smart
smear	7	44	1639	2	smear
smelt	7	47	2678	2	smelt
smit	6	51	3840	2	smit
smut	6	66	2978	2	smut
snag	5	58	2787	2	snag
snap	6	57	2703	2	snap
snath	8	64	1980	2	snath
snaw	7	89	2307	2	snaw
sneak	9	60	1617	2	sneak
sneap	7	55	1482	2	sneap
snit	4	63	4247	2	snit
snot	4	47	4544	2	snot
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soar	4	68	3867	2	soar
soft	7	69	4282	2	soft
soot	4	57	6105	2	soot
sort	4	62	6481	2	sort
sot	3	103	8429	2	s_ot
spa	5	57	3081	2	spa_
spae	6	50	3432	2	spae
spait	7	56	3160	2	spait
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spar	6	54	3330	2	spar
spas	6	70	3672	2	spas
spate	7	47	3158	2	spate
spats	7	50	3138	2	spats
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
speak	11	46	1867	2	speak
spean	7	46	2051	2	spean
spear	7	58	2106	2	spear
spelt	7	54	3019	2	spelt
spent	7	55	3283	2	spent
spit	6	55	4508	2	spit
splat	7	61	2934	2	splat
spot	6	55	4068	2	spot
sprat	7	66	3597	2	sprat
squat	14	37	2014	2	squat
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
star	4	80	3776	2	star
start	5	56	4231	2	start
state	5	62	3733	2	state
stats	5	59	3336	2	stats
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stead	6	55	2027	2	stead
steak	9	52	1980	2	steak
steal	5	61	2547	2	steal
steam	7	63	2292	2	steam
stent	5	56	3451	2	stent
stet	4	59	4732	2	stet
stoat	5	71	3595	2	stoat
stot	4	63	4732	2	stot
suet	4	67	5482	2	suet
suit	4	56	4987	2	suit
swab	9	68	2531	2	swab
swag	8	75	2673	2	swag
swam	9	63	2998	2	swam
swan	7	66	3131	2	swan
swap	9	59	2543	2	swap
swart	8	62	3464	2	swart
swath	11	59	2038	2	swath
swats	8	57	2686	2	swats
sway	10	71	2823	2	sway
swear	8	53	1685	2	swear
sweats	9	48	1461	2	sweats
sweaty	12	37	1005	2	sweaty
sweet	8	53	3052	2	sweet
swept	10	57	2060	2	swept
swot	7	51	3465	2	swot
tat	3	76	9029	2	_tat
tea	3	73	5332	2	tea_
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
teats	5	56	3681	2	teats
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7498	2	te_t
text	11	60	3393	2	text
that	7	56	3932	2	that
treat	5	62	4035	2	treat
twat	7	58	3151	2	twat
unseat	6	42	2102	2	unseat
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.076	2351197.4
2	DLD Change Limit	29872	477	0.970	30795.9
3	Display Results	477	477	0.110	4336.4
	(SQL Overall)	178691	477	1.156	154577.0