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

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

535 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
pate	6	53	5046	(None)
ate	3	70	5924	1	_ate
bate	6	65	5242	1	bate
cate	6	62	5460	1	cate
date	5	64	4332	1	date
fate	7	54	4428	1	fate
gate	5	57	4657	1	gate
hate	7	84	5017	1	hate
late	4	75	6048	1	late
mate	6	51	5422	1	mate
pace	8	63	4577	1	pace
page	7	60	3610	1	page
pale	6	60	5501	1	pale
pane	6	49	5029	1	pane
pare	6	67	6084	1	pare
pase	6	53	4686	1	pase
paste	7	49	3295	1	paste
pat	5	80	8946	1	pat_
pated	8	52	3784	1	pated
paten	7	48	2734	1	paten
pater	7	47	4072	1	pater
pates	7	60	4789	1	pates
path	9	91	3491	1	path
pats	6	64	6085	1	pats
paty	9	52	3456	1	paty
pave	9	61	3389	1	pave
plate	7	46	3511	1	plate
prate	7	51	3598	1	prate
rate	4	54	5876	1	rate
sate	4	55	5610	1	sate
spate	7	47	3158	1	spate
tate	4	47	4860	1	tate
abate	7	66	2784	2	abate
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
agate	6	65	2515	2	agate
age	4	71	5433	2	_age
alate	5	53	4032	2	alate
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
ante	4	65	3890	2	ante
apace	9	47	1838	2	apace
ape	5	72	5118	2	_ape
apse	6	77	2538	2	apse
apt	5	73	5254	2	apt_
apter	7	61	2020	2	apter
are	3	78	7457	2	_are
at	2	123	9340	2	_at_
ates	4	50	4792	2	_ates
att	3	54	5465	2	_att
ave	6	77	4870	2	_ave
awe	6	77	4662	2	_awe
axe	10	82	3949	2	_axe
aye	6	71	5176	2	_aye
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
baste	7	48	2998	2	baste
bat	5	109	8895	2	bat_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bath	9	59	4008	2	bath
bathe	10	58	2288	2	bathe
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
bite	6	65	4700	2	bite
blate	7	59	3378	2	blate
bute	6	67	3967	2	bute
byte	9	65	2181	2	byte
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
came	8	76	4875	2	came
cane	6	66	5312	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carte	7	59	4042	2	carte
case	6	58	4808	2	case
caste	7	59	3236	2	caste
cat	5	82	8234	2	cat_
cater	7	48	4072	2	cater
cates	7	59	5189	2	cates
cats	6	63	5634	2	cats
cave	9	59	4126	2	cave
cete	6	49	3478	2	cete
cite	6	56	4034	2	cite
cote	6	66	4873	2	cote
crate	7	65	3740	2	crate
cute	6	64	4045	2	cute
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
data	5	60	2665	2	data
dated	7	55	3099	2	dated
dater	6	53	3231	2	dater
dates	6	56	3915	2	dates
dato	5	61	2994	2	dato
daze	14	73	2723	2	daze
dite	5	55	4755	2	dite
dote	5	54	4288	2	dote
ease	4	50	4233	2	ease
eat	3	69	8905	2	eat_
eaten	5	53	2305	2	eaten
eater	5	46	3984	2	eater
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eave	7	57	3358	2	eave
elate	5	53	3588	2	elate
enate	5	44	2814	2	enate
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4357	2	fane
fare	7	63	5446	2	fare
fat	6	81	7808	2	fat_
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fete	7	57	3492	2	fete
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4530	2	gane
gape	7	51	3451	2	gape
gat	4	68	8051	2	gat_
gated	7	53	2977	2	gated
gater	6	45	3365	2	gater
gates	6	59	3951	2	gates
gats	5	67	5344	2	gats
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
gite	5	54	3861	2	gite
grate	6	49	3288	2	grate
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
haet	7	56	5950	2	haet
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hare	7	62	5573	2	hare
haste	8	59	2786	2	haste
hat	6	72	8996	2	hat_
hated	9	57	3402	2	hated
hater	8	50	3475	2	hater
hates	8	67	4257	2	hates
hath	10	59	3391	2	hath
hats	7	68	5825	2	hats
haute	8	95	2161	2	haute
have	10	61	3707	2	have
haze	16	48	3339	2	haze
hyte	10	90	1894	2	hyte
irate	5	56	2798	2	irate
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
jato	11	58	2268	2	jato
jete	11	59	2725	2	jete
jute	11	53	2789	2	jute
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
kat	7	74	6829	2	kat_
kata	8	56	2602	2	kata
kats	8	59	4433	2	kats
kite	8	53	3823	2	kite
kyte	11	70	1776	2	kyte
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5333	2	lane
lase	4	61	4851	2	lase
lat	3	75	9340	2	lat_
lated	6	52	4067	2	lated
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lath	7	66	4038	2	lath
lathe	8	56	2671	2	lathe
lati	4	64	3827	2	lati
latke	9	48	1709	2	latke
lats	4	59	6270	2	lats
latte	5	54	2630	2	latte
latu	4	79	3418	2	latu
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lite	4	70	5454	2	lite
lute	4	63	4101	2	lute
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
mage	7	57	3913	2	mage
make	10	55	3789	2	make
male	6	60	5230	2	male
mane	6	50	5203	2	mane
mare	6	47	5933	2	mare
mat	5	80	8394	2	mat_
mated	8	55	3778	2	mated
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
math	9	54	3745	2	math
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
matte	7	56	2684	2	matte
maze	15	54	3498	2	maze
mete	6	44	3813	2	mete
mite	6	62	4941	2	mite
mote	6	70	4808	2	mote
mute	6	51	3687	2	mute
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nates	5	52	3833	2	nates
nave	7	57	3231	2	nave
nite	4	59	4358	2	nite
note	4	62	3996	2	note
oat	3	98	8826	2	oat_
oaten	5	52	2240	2	oaten
oater	5	54	3373	2	oater
oath	7	61	3215	2	oath
oats	4	65	5421	2	oats
opiate	8	5	1346	2	opiate
orate	5	51	3330	2	orate
ovate	8	42	1439	2	ovate
pa	4	104	5648	2	pa__
pac	7	90	5408	2	pa_c
paca	8	51	3224	2	paca
paced	10	69	3168	2	paced
pacer	9	61	3161	2	pacer
paces	9	67	4111	2	paces
pacey	12	67	2028	2	pacey
pack	12	55	3544	2	pack
pacs	8	58	4218	2	pacs
pact	8	66	4872	2	pact
pacts	9	51	2580	2	pacts
pacy	11	53	2868	2	pacy
pad	6	80	5732	2	pa_d
padi	7	63	3178	2	padi
padle	8	45	2234	2	padle
padre	8	60	1816	2	padre
pads	7	67	4295	2	pads
paged	9	59	2678	2	paged
pager	8	47	2820	2	pager
pages	8	52	3507	2	pages
pah	8	88	5359	2	pa_h
paid	7	57	3748	2	paid
paik	10	57	2680	2	paik
pail	6	61	4183	2	pail
pain	6	56	4724	2	pain
pair	6	60	3151	2	pair
paise	7	50	2833	2	paise
pal	5	67	6167	2	pa_l
palate	8	42	2678	2	palate
palea	7	50	2866	2	palea
paled	8	55	3872	2	paled
paler	7	54	3693	2	paler
pales	7	57	5380	2	pales
palet	7	46	5080	2	palet
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
palter	8	44	2326	2	palter
paly	9	58	3553	2	paly
pam	7	78	5839	2	pa_m
pams	8	56	4176	2	pams
pan	5	84	6645	2	pa_n
paned	8	54	3718	2	paned
panel	7	60	2362	2	panel
panes	7	61	4869	2	panes
pang	7	53	3629	2	pang
panne	7	66	2365	2	panne
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
panted	9	50	2482	2	panted
pantie	8	43	2647	2	pantie
panto	7	61	2941	2	panto
pants	7	65	3692	2	pants
panty	10	59	2930	2	panty
pap	7	67	5840	2	pa_p
papa	8	58	2714	2	papa
paper	9	51	2866	2	paper
paps	8	64	4345	2	paps
par	5	74	6702	2	pa_r
para	6	52	4217	2	para
parae	7	63	3570	2	parae
pard	7	64	4132	2	pard
pared	8	69	4676	2	pared
pareo	7	46	3260	2	pareo
parer	7	58	3990	2	parer
pares	7	71	6448	2	pares
pareu	7	49	2874	2	pareu
parge	8	58	3185	2	parge
park	10	52	3749	2	park
parle	7	58	3616	2	parle
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
parse	7	52	3699	2	parse
part	6	59	6746	2	part
parted	9	42	2868	2	parted
parts	7	77	4337	2	parts
party	10	66	3061	2	party
parve	10	98	2485	2	parve
pas	5	87	7574	2	pa_s
paseo	7	70	2251	2	paseo
pases	7	53	4650	2	pases
pash	9	56	3813	2	pash
pass	6	52	3995	2	pass
passe	7	55	2569	2	passe
past	6	59	5901	2	past
pasta	7	66	2453	2	pasta
pasted	9	44	2690	2	pasted
pastel	8	59	1871	2	pastel
paster	8	57	3437	2	paster
pastes	8	52	3391	2	pastes
pastie	8	55	2552	2	pastie
pasts	7	59	3650	2	pasts
pasty	10	57	2505	2	pasty
patch	12	52	2122	2	patch
patens	8	48	2086	2	patens
patent	8	45	2492	2	patent
paters	8	49	3583	2	paters
paths	10	55	2138	2	paths
patin	7	68	3285	2	patin
patine	8	53	2812	2	patine
patio	7	44	2635	2	patio
patly	10	50	2058	2	patly
patsy	10	57	1720	2	patsy
patted	9	47	2468	2	patted
pattee	8	43	2338	2	pattee
patten	8	44	1819	2	patten
patter	8	46	2826	2	patter
pattie	8	40	2096	2	pattie
patty	10	47	2361	2	patty
patzer	17	31	1164	2	patzer
pause	7	50	2183	2	pause
paved	11	55	2526	2	paved
paver	10	42	2583	2	paver
paves	10	48	3392	2	paves
paw	8	76	5117	2	pa_w
pawed	11	57	2561	2	pawed
pawer	10	44	2297	2	pawer
pawl	9	51	2326	2	pawl
pawn	9	46	2530	2	pawn
paws	9	60	3818	2	paws
pax	12	73	4685	2	pa_x
paxes	14	49	2842	2	paxes
pay	8	84	6118	2	pa_y
payed	11	59	2593	2	payed
payee	10	55	2472	2	payee
payer	10	51	2572	2	payer
pays	9	59	4022	2	pays
pe	4	76	4903	2	p__e
peace	9	50	2608	2	peace
peage	8	47	2357	2	peage
pease	7	52	3111	2	pease
peat	6	59	6793	2	peat_
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
pedate	9	31	1776	2	pedate
pee	5	60	6651	2	p_ee
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pere	6	64	5026	2	pere
pet	5	64	7730	2	pet_
peter	7	44	2759	2	peter
pets	6	62	4833	2	pets
phage	11	51	1367	2	phage
phase	10	46	1721	2	phase
phat	9	58	3786	2	phat_
pht	8	60	3052	2	pht_
pice	8	46	4109	2	pice
pie	5	54	5740	2	p_ie
pike	10	63	3521	2	pike
pile	6	56	4969	2	pile
pine	6	77	5571	2	pine
pipe	8	64	3443	2	pipe
pirate	8	23	2288	2	pirate
piste	7	58	2460	2	piste
pit	5	64	7192	2	pit_
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
place	9	48	2461	2	place
plage	8	45	2040	2	plage
plane	7	49	2914	2	plane
plat	6	60	4887	2	plat_
plated	9	52	2577	2	plated
platen	8	45	1820	2	platen
plater	8	44	2769	2	plater
plates	8	54	3224	2	plates
plats	7	55	3137	2	plats
platy	10	50	2166	2	platy
plie	6	51	2739	2	plie
poet	6	55	5290	2	poet
poke	10	53	3536	2	poke
pole	6	59	5130	2	pole
pome	8	56	3669	2	pome
pone	6	57	4753	2	pone
pope	8	55	3561	2	pope
pore	6	64	5126	2	pore
pose	6	64	4173	2	pose
pot	5	80	7843	2	pot_
pots	6	64	5236	2	pots
prase	7	61	2875	2	prase
prat	6	59	5204	2	prat_
prated	9	49	2492	2	prated
prater	8	48	2535	2	prater
prates	8	46	3316	2	prates
prats	7	63	3339	2	prats
pree	6	70	4473	2	pree
pst	5	79	3251	2	pst_
puce	8	51	2788	2	puce
puke	10	50	2546	2	puke
pule	6	50	4095	2	pule
pupate	10	42	1312	2	pupate
pure	6	55	4333	2	pure
put	5	57	5907	2	put_
puts	6	56	4175	2	puts
putt	6	69	3784	2	putt
putz	15	83	2632	2	putz
pye	8	64	3250	2	p_ye
pyre	9	49	2555	2	pyre
qat	12	52	5333	2	qat_
qats	13	53	3134	2	qats
quate	14	45	2141	2	quate
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rat	3	78	9274	2	rat_
rated	6	54	4138	2	rated
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
rath	7	60	3766	2	rath
rathe	8	58	2192	2	rathe
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
rete	4	49	4413	2	rete
rite	4	58	4945	2	rite
rote	4	62	4902	2	rote
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sat	3	62	8848	2	sat_
sated	6	62	3853	2	sated
satem	7	60	2146	2	satem
sates	5	49	4932	2	sates
sati	4	55	3933	2	sati
saute	5	50	2808	2	saute
save	7	57	4136	2	save
site	4	70	5241	2	site
skate	9	47	2155	2	skate
slate	5	54	3828	2	slate
space	9	53	2567	2	space
spade	8	44	2332	2	spade
spae	6	50	3432	2	spa_e
spake	11	43	2274	2	spake
spale	7	49	2921	2	spale
spare	7	51	3556	2	spare
spat	6	65	4852	2	spat_
spates	8	50	2817	2	spates
spathe	11	51	1569	2	spathe
spats	7	50	3138	2	spats
spite	7	54	3066	2	spite
state	5	62	3733	2	state
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
taste	5	51	2723	2	taste
tat	3	76	9029	2	tat_
tater	5	41	3861	2	tater
tates	5	54	4498	2	tates
tats	4	68	5813	2	tats
tote	4	66	4367	2	tote
update	9	38	1029	2	update
uprate	8	39	1654	2	uprate
urate	5	54	3216	2	urate
ute	3	53	3588	2	_ute
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vat	6	78	6345	2	vat_
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
vote	7	47	2862	2	vote
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
waste	8	61	2505	2	waste
wat	6	73	7892	2	wat_
water	8	47	3331	2	water
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wave	10	52	3473	2	wave
wite	7	54	4327	2	wite
wyte	10	60	1864	2	wyte
yare	7	56	3694	2	yare

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.283	631417.0
2	DLD Change Limit	29872	535	0.763	39150.7
3	Display Results	535	535	0.143	3741.3
	(SQL Overall)	178691	535	1.189	150286.8