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

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

406 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
peat	6	59	6793	(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
pat	5	80	8946	1	p_at
pea	5	66	5724	1	pea_
peag	7	54	3134	1	peag
peak	10	65	3520	1	peak
peal	6	86	4810	1	peal
pean	6	61	4717	1	pean
pear	6	97	4523	1	pear
peart	7	64	4075	1	peart
peas	6	57	5506	1	peas
peats	7	61	4019	1	peats
peaty	10	57	2569	1	peaty
pelt	6	76	5108	1	pelt
pent	6	65	5907	1	pent
pert	6	67	5932	1	pert
pest	6	55	5529	1	pest
pet	5	64	7730	1	pe_t
phat	9	58	3786	1	phat
plat	6	60	4887	1	plat
pleat	7	47	3447	1	pleat
prat	6	59	5204	1	prat
seat	4	75	7556	1	seat
teat	4	59	6363	1	teat
apeak	11	55	1345	2	apeak
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
epact	9	49	2153	2	epact
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	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
pa	4	104	5648	2	p_a_
pac	7	90	5408	2	p_ac
pact	8	66	4872	2	pact
pad	6	80	5732	2	p_ad
paean	7	72	2272	2	paean
pah	8	88	5359	2	p_ah
pal	5	67	6167	2	p_al
pam	7	78	5839	2	p_am
pan	5	84	6645	2	p_an
pant	6	60	6126	2	pant
pap	7	67	5840	2	p_ap
par	5	74	6702	2	p_ar
part	6	59	6746	2	part
pas	5	87	7574	2	p_as
past	6	59	5901	2	past
pate	6	53	5046	2	p_ate
path	9	91	3491	2	p_ath
pats	6	64	6085	2	p_ats
paty	9	52	3456	2	p_aty
paw	8	76	5117	2	p_aw
pax	12	73	4685	2	p_ax
pay	8	84	6118	2	p_ay
pe	4	76	4903	2	pe__
peace	9	50	2608	2	peace
peach	12	54	2249	2	peach
peage	8	47	2357	2	peage
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peaky	14	57	1815	2	peaky
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
peanut	8	3	1818	2	peanut
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
pease	7	52	3111	2	pease
peavy	13	50	1484	2	peavy
pec	7	67	4441	2	pe_c
pecan	9	19	1903	2	pecan
pech	11	61	2545	2	pech
peck	12	57	3068	2	peck
pecs	8	46	3410	2	pecs
ped	6	67	5152	2	pe_d
pedal	8	60	2250	2	pedal
pedant	9	3	1949	2	pedant
pedate	9	31	1776	2	pedate
peds	7	58	3524	2	peds
pee	5	60	6651	2	pe_e
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
peg	6	58	4306	2	pe_g
pegs	7	55	3176	2	pegs
peh	8	67	4096	2	pe_h
pehs	9	56	2576	2	pehs
pein	6	58	3494	2	pein
pekan	11	16	1397	2	pekan
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelts	7	61	2881	2	pelts
pen	5	65	5884	2	pe_n
penal	7	52	2837	2	penal
pend	7	59	3453	2	pend
pens	6	56	4964	2	pens
peon	6	56	3524	2	peon
pep	7	64	4708	2	pe_p
pepo	8	76	2215	2	pepo
peps	8	51	3451	2	peps
per	5	63	5309	2	pe_r
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
perv	9	72	2481	2	perv
pes	5	72	5978	2	pe_s
peso	6	69	2582	2	peso
pesto	7	57	2372	2	pesto
pests	7	59	3327	2	pests
pesty	10	64	2171	2	pesty
petal	7	65	2689	2	petal
petit	7	43	3265	2	petit
pets	6	62	4833	2	pets
petti	7	51	1945	2	petti
petto	7	60	2104	2	petto
petty	10	53	2029	2	petty
pew	8	64	4230	2	pe_w
pewit	10	46	2279	2	pewit
pews	9	57	3153	2	pews
pfft	12	3	1188	2	pfft
phot	9	55	3436	2	phot
pht	8	60	3052	2	p_ht
phut	9	69	2597	2	phut
pia	5	68	4803	2	pia_
pial	6	56	3670	2	pial
pian	6	61	3609	2	pian
pias	6	65	4255	2	pias
pieta	7	54	2175	2	pieta
pint	6	69	6317	2	pint
pit	5	64	7192	2	p_it
pita	6	54	3643	2	pita
plait	7	56	3157	2	plait
plan	6	58	3394	2	plan
plant	7	54	3711	2	plant
plate	7	46	3511	2	plate
plats	7	55	3137	2	plats
platy	10	50	2166	2	platy
play	9	59	2898	2	play
plea	6	68	3060	2	plea_
plead	8	58	1846	2	plead
pleas	7	56	2703	2	pleas
pleats	8	52	1859	2	pleats
plot	6	61	4123	2	plot
poet	6	55	5290	2	poet
port	6	60	5963	2	port
post	6	79	5336	2	post
pot	5	80	7843	2	p_ot
pout	6	57	5255	2	pout
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prate	7	51	3598	2	prate
prats	7	63	3339	2	prats
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
preact	10	32	2039	2	preact
prest	7	57	3635	2	prest
psst	6	61	1840	2	psst
pst	5	79	3251	2	p_st
punt	6	57	4720	2	punt
put	5	57	5907	2	p_ut
putt	6	69	3784	2	putt
pya	8	70	2375	2	pya_
pyas	9	62	2570	2	pyas
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
repeat	8	51	2721	2	repeat
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
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
splat	7	61	2934	2	splat
sprat	7	66	3597	2	sprat
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
upbeat	10	9	1151	2	upbeat
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.280	638182.1
2	DLD Change Limit	29872	406	0.860	34734.9
3	Display Results	406	406	0.096	4229.2
	(SQL Overall)	178691	406	1.236	144572.0