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

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

355 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
feat	7	64	5822	(None)
beat	6	61	6830	1	beat
eat	3	69	8905	1	_eat
fat	6	81	7808	1	f_at
feal	7	139	4042	1	feal
fear	7	53	3779	1	fear
feast	8	59	3272	1	feast
feats	8	64	3275	1	feats
feet	7	53	5221	1	feet
felt	7	51	4693	1	felt
fest	7	49	4944	1	fest
fet	6	64	7163	1	fe_t
feta	7	65	2890	1	feta
fiat	7	66	4664	1	fiat
flat	7	71	4782	1	flat
frat	7	56	4854	1	frat
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
teat	4	59	6363	1	teat
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
defeat	10	38	1716	2	defeat
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
fa	5	101	4845	2	f_a_
fab	8	74	5313	2	f_ab
fact	9	71	4254	2	fact
fad	7	74	5241	2	f_ad
fag	7	68	5236	2	f_ag
fan	6	71	5886	2	f_an
far	6	77	6260	2	f_ar
fart	7	68	6056	2	fart
fas	6	82	6293	2	f_as
fast	7	70	5231	2	fast
fate	7	54	4428	2	f_ate
fats	7	62	5250	2	f_ats
fax	13	81	4331	2	f_ax
fay	9	74	5486	2	f_ay
fe	5	79	4474	2	fe__
fealty	12	29	1022	2	fealty
fears	8	48	2939	2	fears
fease	8	48	2487	2	fease
feasts	9	51	1609	2	feasts
feater	9	52	2405	2	feater
featly	12	37	1175	2	featly
feaze	17	52	1631	2	feaze
fecal	10	51	1921	2	fecal
feck	13	49	2343	2	feck
fed	7	65	4835	2	fe_d
feds	8	52	3431	2	feds
fee	6	68	6201	2	fe_e
feeb	9	69	2454	2	feeb
feed	8	45	3890	2	feed
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feh	9	61	3609	2	fe_h
fehs	10	65	2238	2	fehs
feint	8	47	3225	2	feint
feist	8	62	3007	2	feist
fell	7	68	3307	2	fell
felts	8	53	2454	2	felts
fem	8	60	4073	2	fe_m
feme	9	61	3054	2	feme
fems	9	64	2870	2	fems
fen	6	68	5135	2	fe_n
fend	8	48	3297	2	fend
fens	7	61	3976	2	fens
feod	8	155	2300	2	feod
fer	6	66	4612	2	fe_r
feral	8	54	2465	2	feral
fere	7	63	4223	2	fere
fern	7	61	2932	2	fern
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fests	8	58	2804	2	fests
fetal	8	56	2337	2	fetal
fetas	8	56	2440	2	fetas
fete	7	57	3492	2	fete
fets	7	53	4594	2	fets
feu	6	78	4366	2	fe_u
feuar	8	3	1024	2	feuar
feud	8	65	2302	2	feud
feus	7	58	3075	2	feus
few	9	54	3696	2	fe_w
fey	9	59	4088	2	fe_y
fez	15	62	3682	2	fe_z
fiar	7	64	2733	2	fiar
fiats	8	53	2448	2	fiats
fist	7	62	4842	2	fist
fit	6	63	6545	2	f_it
fixt	14	107	2971	2	fixt
flab	9	66	2835	2	flab
flag	8	74	2708	2	flag
flak	11	60	2617	2	flak
flam	9	63	3329	2	flam
flan	7	61	3418	2	flan
flap	9	61	2870	2	flap
flats	8	64	2974	2	flats
flaw	10	63	2664	2	flaw
flax	14	73	2563	2	flax
flay	10	63	3280	2	flay
flea	7	56	2849	2	flea_
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
fleet	8	59	3233	2	fleet
flit	7	65	3927	2	flit
float	8	59	2857	2	float
foal	7	66	3092	2	foal
foam	9	71	2717	2	foam
font	7	71	4375	2	font
foot	7	62	4801	2	foot
fort	7	64	5644	2	fort
frae	7	53	3047	2	frae
frag	8	51	2627	2	frag
frap	9	59	2581	2	frap
frats	8	68	2967	2	frats
fray	10	54	2890	2	fray
freak	12	51	1524	2	freak
fret	7	58	4504	2	fret
frit	7	70	4447	2	frit
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
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
swat	7	72	4444	2	swat
sweat	8	56	2840	2	sweat
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	7499	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
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.266	671770.7
2	DLD Change Limit	29872	355	1.143	26134.7
3	Display Results	355	355	0.153	2320.3
	(SQL Overall)	178691	355	1.562	114398.8