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

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

368 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
peats	7	61	4019	(None)
beats	7	60	4224	1	beats
eats	4	70	5487	1	_eats
feats	8	64	3275	1	feats
heats	8	58	3840	1	heats
meats	7	50	3405	1	meats
neats	5	59	3190	1	neats
pats	6	64	6085	1	p_ats
peags	8	61	2284	1	peags
peaks	11	48	2562	1	peaks
peals	7	52	3549	1	peals
peans	7	54	3764	1	peans
pears	7	51	3861	1	pears
peas	6	57	5506	1	pea_s
peat	6	59	6793	1	peat_
peaty	10	57	2569	1	peaty
pelts	7	61	2881	1	pelts
pests	7	59	3327	1	pests
pets	6	62	4833	1	pe_ts
plats	7	55	3137	1	plats
pleats	8	52	1859	1	pleats
prats	7	63	3339	1	prats
seats	5	48	4434	1	seats
teats	5	56	3681	1	teats
bats	6	69	6233	2	_bats
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beasts	8	45	1972	2	beasts
beat	6	61	6830	2	beat_
beaus	7	51	2711	2	beaus
beauts	8	60	1528	2	beauts
beets	7	61	3144	2	beets
belts	7	59	3116	2	belts
bents	7	60	3369	2	bents
bests	7	59	3261	2	bests
betas	7	55	2876	2	betas
bets	6	70	5144	2	be_ts
blats	7	51	3250	2	blats
bleats	8	55	1861	2	bleats
boats	7	56	3515	2	boats
brats	7	53	3601	2	brats
cats	6	63	5634	2	_cats
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
chats	10	57	3009	2	chats
cheats	11	45	1954	2	cheats
cleats	8	49	1931	2	cleats
coats	7	56	3500	2	coats
deads	7	57	2691	2	deads
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dears	6	57	3688	2	dears
death	9	48	2252	2	death
deaths	10	59	1444	2	deaths
debts	8	64	1837	2	debts
deets	6	53	3024	2	deets
defats	10	51	1455	2	defats
delts	6	57	3179	2	delts
dents	6	50	3180	2	dents
derats	7	46	2506	2	derats
doats	6	52	2488	2	doats
drats	6	66	2837	2	drats
ears	4	63	5659	2	_ears
east	4	66	5910	2	_east
easts	5	75	3032	2	_easts
eat	3	69	8905	2	_eat_
eath	7	57	3566	2	_eath
efts	7	65	1948	2	_efts
epacts	10	50	1039	2	epacts
etas	4	64	3227	2	_etas
fats	7	62	5250	2	_fats
fears	8	48	2939	2	fears
feast	8	59	3272	2	feast
feasts	9	51	1609	2	feasts
feat	7	64	5822	2	feat_
felts	8	53	2454	2	felts
fests	8	58	2804	2	fests
fetas	8	56	2440	2	fetas
fets	7	53	4594	2	fe_ts
fiats	8	53	2448	2	fiats
flats	8	64	2974	2	flats
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
gears	6	46	2869	2	gears
gelts	6	59	2461	2	gelts
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
getas	6	54	2148	2	getas
gets	5	54	4248	2	ge_ts
ghats	9	58	1861	2	ghats
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
greats	7	63	1839	2	greats
haets	8	65	2512	2	haets
hats	7	68	5825	2	_hats
heads	9	51	2711	2	heads
heals	8	57	3345	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
hearts	9	62	1894	2	hearts
heat	7	70	6142	2	heat_
heath	11	57	2428	2	heath
heaths	12	63	1638	2	heaths
hefts	11	62	1815	2	hefts
hents	8	73	3074	2	hents
hests	8	58	2993	2	hests
hets	7	55	4720	2	he_ts
ikats	9	53	1115	2	ikats
jeans	12	60	2211	2	jeans
jests	12	59	2245	2	jests
jets	11	58	3410	2	je_ts
kats	8	59	4433	2	_kats
keas	8	63	3709	2	kea_s
keets	9	51	2348	2	keets
kelts	9	52	2263	2	kelts
khats	12	53	1601	2	khats
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
least	5	61	3488	2	least
leasts	6	46	1641	2	leasts
leets	5	49	2712	2	leets
lefts	8	65	1781	2	lefts
lets	4	71	4794	2	le_ts
mats	6	54	6029	2	_mats
meads	8	54	2532	2	meads
meals	7	59	3337	2	meals
means	7	58	3123	2	means
meat	6	63	5960	2	meat_
meatus	8	51	1292	2	meatus
meaty	10	70	2131	2	meaty
meets	7	42	2461	2	meets
melts	7	49	3010	2	melts
moats	7	58	2764	2	moats
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat_
neath	8	60	2028	2	neath
nerts	5	59	2498	2	nerts
nests	5	57	2800	2	nests
nets	4	59	4153	2	ne_ts
netts	5	53	2072	2	netts
newts	8	60	1528	2	newts
oats	4	65	5421	2	_oats
pacs	8	58	4218	2	p_acs
pacts	9	51	2580	2	pacts
pads	7	67	4295	2	p_ads
paeans	8	51	1826	2	paeans
pals	6	69	5135	2	p_als
pams	8	56	4176	2	p_ams
pans	6	58	5573	2	p_ans
pants	7	65	3692	2	pants
paps	8	64	4345	2	p_aps
pars	6	75	6079	2	p_ars
parts	7	77	4337	2	parts
pas	5	87	7574	2	p_a_s
pass	6	52	3995	2	p_ass
past	6	59	5901	2	p_ast
pasts	7	59	3650	2	pasts
pat	5	80	8946	2	p_at_
pate	6	53	5046	2	p_ate
pates	7	60	4789	2	p_ates
path	9	91	3491	2	p_ath
paths	10	55	2138	2	p_aths
patsy	10	57	1720	2	p_atsy
paty	9	52	3456	2	p_aty
paws	9	60	3818	2	p_aws
pays	9	59	4022	2	p_ays
pea	5	66	5724	2	pea__
peace	9	50	2608	2	peace
peaces	10	63	2408	2	peaces
peach	12	54	2249	2	peach
peag	7	54	3134	2	pea_g
peage	8	47	2357	2	peage
peages	9	43	2185	2	peages
peak	10	65	3520	2	pea_k
peaky	14	57	1815	2	peaky
peal	6	86	4810	2	pea_l
pean	6	61	4717	2	pea_n
peanuts	9	3	699	2	peanuts
pear	6	97	4523	2	pea_r
pearl	7	53	2446	2	pearl
pearls	8	47	1539	2	pearls
peart	7	64	4075	2	peart
pease	7	52	3111	2	pease
peases	8	52	2947	2	peases
peavy	13	50	1484	2	peavy
pecans	10	15	1583	2	pecans
pechs	12	55	1620	2	pechs
pecks	13	57	2443	2	pecks
pecs	8	46	3410	2	pe_cs
pedals	9	43	1603	2	pedals
pedants	10	3	1011	2	pedants
pedate	9	31	1776	2	pedate
pedes	8	53	2729	2	pedes
peds	7	58	3524	2	pe_ds
peeks	11	50	2111	2	peeks
peels	7	52	2642	2	peels
peens	7	64	2819	2	peens
peeps	9	58	2236	2	peeps
peers	7	51	3027	2	peers
pees	6	52	5737	2	pe_es
pegs	7	55	3176	2	pe_gs
pehs	9	56	2576	2	pe_hs
peins	7	61	2806	2	peins
pekans	12	17	1055	2	pekans
pekes	11	46	2356	2	pekes
peles	7	57	3808	2	peles
pelfs	10	50	1629	2	pelfs
pelt	6	76	5108	2	pelt_
penates	9	33	2160	2	penates
pends	8	55	2719	2	pends
penes	7	58	3922	2	penes
penis	7	51	2932	2	penis
pens	6	56	4964	2	pe_ns
pent	6	65	5907	2	pent_
peons	7	53	2718	2	peons
pepos	9	66	2008	2	pepos
peps	8	51	3451	2	pe_ps
peres	7	62	4664	2	peres
peris	7	55	3707	2	peris
perks	11	53	2580	2	perks
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
pert	6	67	5932	2	pert_
pervs	10	51	1737	2	pervs
pes	5	72	5978	2	pe__s
pesos	7	72	2162	2	pesos
pest	6	55	5529	2	pest_
pesto	7	57	2372	2	pesto
pestos	8	47	1908	2	pestos
pesty	10	64	2171	2	pesty
pet	5	64	7730	2	pe_t_
petal	7	65	2689	2	petal
petals	8	47	1981	2	petals
petti	7	51	1945	2	petti
petto	7	60	2104	2	petto
petty	10	53	2029	2	petty
pewits	11	28	1068	2	pewits
pews	9	57	3153	2	pe_ws
phat	9	58	3786	2	phat_
phots	10	54	1850	2	phots
phuts	10	46	1350	2	phuts
pians	7	51	2696	2	pians
pias	6	65	4255	2	pia_s
pietas	8	45	1650	2	pietas
pints	7	59	3622	2	pints
pitas	7	74	2767	2	pitas
pits	6	63	4874	2	p_its
plaits	8	38	1647	2	plaits
plans	7	57	3127	2	plans
plants	8	49	2180	2	plants
plat	6	60	4887	2	plat_
plate	7	46	3511	2	plate
plates	8	54	3224	2	plates
platy	10	50	2166	2	platy
platys	11	45	985	2	platys
plays	10	63	2077	2	plays
pleads	9	46	1395	2	pleads
pleas	7	56	2703	2	plea_s
pleat	7	47	3447	2	pleat_
plots	7	50	2567	2	plots
poets	7	60	2444	2	poets
ports	7	59	3459	2	ports
posts	7	52	2878	2	posts
pots	6	64	5236	2	p_ots
pouts	7	55	3032	2	pouts
prams	9	61	2551	2	prams
praos	7	49	2356	2	praos
prat	6	59	5204	2	prat_
prate	7	51	3598	2	prate
prates	8	46	3316	2	prates
praus	7	46	2175	2	praus
prays	10	50	2243	2	prays
preacts	11	32	1136	2	preacts
prests	8	40	2126	2	prests
punts	7	58	2800	2	punts
puts	6	56	4175	2	p_uts
putts	7	57	1927	2	putts
pyas	9	62	2570	2	pya_s
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
reacts	8	36	1660	2	reacts
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reatas	6	40	2101	2	reatas
rents	5	59	3518	2	rents
repeats	9	43	1605	2	repeats
rests	5	49	3587	2	rests
rets	4	53	5256	2	re_ts
scats	7	59	3060	2	scats
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seat	4	75	7556	2	seat_
sects	7	56	2289	2	sects
septs	7	54	2060	2	septs
sets	4	55	4950	2	se_ts
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
skats	9	46	2154	2	skats
slats	5	54	3690	2	slats
spats	7	50	3138	2	spats
speaks	12	51	1458	2	speaks
speans	8	54	1714	2	speans
spears	8	40	1947	2	spears
spelts	8	46	1464	2	spelts
splats	8	48	1730	2	splats
sprats	8	58	1993	2	sprats
stats	5	59	3336	2	stats
swats	8	57	2686	2	swats
sweats	9	48	1461	2	sweats
tats	4	68	5813	2	_tats
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teat	4	59	6363	2	teat_
tents	5	64	3421	2	tents
tests	5	65	3019	2	tests
tets	4	58	4746	2	te_ts
texts	12	55	1504	2	texts
treats	6	48	2169	2	treats
twats	8	66	1660	2	twats
upbeats	11	9	573	2	upbeats
vats	7	68	4174	2	_vats
veals	8	49	2619	2	veals
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vests	8	53	2598	2	vests
vets	7	68	3509	2	ve_ts
wats	7	75	5588	2	_wats
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
welts	8	52	2519	2	welts
wests	8	57	2700	2	wests
wets	7	59	4029	2	we_ts
whats	11	77	1899	2	whats
wheats	12	50	1322	2	wheats
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yeast	8	53	2794	2	yeast
yeasts	9	64	1305	2	yeasts
yetts	8	67	1513	2	yetts
zeals	14	53	2085	2	zeals
zests	14	54	1974	2	zests
zetas	14	50	1816	2	zetas

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	53800	0.310	576422.6
2	DLD Change Limit	53800	368	1.673	32157.8
3	Display Results	368	368	0.093	3957.0
	(SQL Overall)	178691	368	2.076	86074.7