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

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

468 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
gate	5	57	4657	(None)
agate	6	65	2515	1	agate
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
gae	4	64	5770	1	ga_e
gage	6	59	3610	1	gage
gale	5	63	4732	1	gale
game	7	66	4432	1	game
gane	5	51	4530	1	gane
gape	7	51	3451	1	gape
gat	4	68	8051	1	gat_
gated	7	53	2977	1	gated
gater	6	45	3365	1	gater
gates	6	59	3951	1	gates
gats	5	67	5344	1	gats
gave	8	46	3405	1	gave
gaze	14	50	3241	1	gaze
gite	5	54	3861	1	gite
grate	6	49	3288	1	grate
hate	7	84	5017	1	hate
late	4	75	6048	1	late
mate	6	51	5422	1	mate
pate	6	53	5046	1	pate
rate	4	54	5876	1	rate
sate	4	55	5610	1	sate
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
agape	8	56	1484	2	agape
agates	7	61	2134	2	agates
agave	9	53	1403	2	agave
agaze	15	61	1366	2	agaze
age	4	71	5433	2	_age
agee	5	62	4149	2	agee
agnate	7	33	1488	2	agnate
ague	5	57	2592	2	ague
alate	5	53	4032	2	alate
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
ante	4	65	3890	2	ante
ape	5	72	5118	2	_ape
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	2815	2	enate
ergate	7	3	1514	2	ergate
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
gab	6	71	5599	2	ga_b
gable	8	53	2552	2	gable
gabs	7	67	4042	2	gabs
gaby	10	71	2319	2	gaby
gad	5	75	5665	2	ga_d
gadi	6	63	2972	2	gadi
gadje	14	5	774	2	gadje
gads	6	78	4338	2	gads
gaed	6	60	3151	2	gaed
gaen	5	73	2960	2	gaen
gaes	5	63	4803	2	gaes
gaff	11	48	2815	2	gaff
gaffe	12	41	1165	2	gaffe
gag	5	77	5363	2	ga_g
gaga	6	66	2555	2	gaga
gaged	8	55	2231	2	gaged
gager	7	47	2629	2	gager
gages	7	45	2997	2	gages
gags	6	64	4106	2	gags
gain	5	60	4216	2	gain
gait	5	61	5019	2	gait
gaited	8	44	1692	2	gaited
gaiter	7	38	1950	2	gaiter
gaits	6	57	2601	2	gaits
gal	4	60	5551	2	ga_l
gala	5	56	3516	2	gala
galea	6	47	2293	2	galea
gales	6	54	4248	2	gales
gall	5	63	3599	2	gall
gals	5	79	4650	2	gals
gam	6	70	6006	2	ga_m
gama	7	70	3552	2	gama
gamb	9	63	3184	2	gamb
gambe	10	62	1921	2	gambe
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamete	9	3	1359	2	gamete
gamey	11	53	2055	2	gamey
gamp	9	88	3321	2	gamp
gams	7	66	4888	2	gams
gamy	10	54	2753	2	gamy
gan	4	80	6013	2	ga_n
ganef	9	63	2246	2	ganef
ganev	9	55	1386	2	ganev
gang	6	60	3197	2	gang
gaol	5	69	2541	2	gaol
gap	6	70	5561	2	ga_p
gaped	9	61	2353	2	gaped
gaper	8	61	2512	2	gaper
gapes	8	60	3082	2	gapes
gaps	7	60	4297	2	gaps
gapy	10	63	2091	2	gapy
gar	4	72	5990	2	ga_r
garb	7	53	3267	2	garb
garote	7	7	1795	2	garote
gars	5	57	5074	2	gars
garter	7	44	2051	2	garter
garth	9	47	2022	2	garth
gas	4	88	7025	2	ga_s
gases	6	56	3399	2	gases
gash	8	68	3302	2	gash
gasp	7	62	2733	2	gasp
gast	5	60	5256	2	gast
gasted	8	48	2158	2	gasted
gaster	7	50	2735	2	gaster
gasts	6	66	2863	2	gasts
gateau	7	7	811	2	gateau
gaters	7	47	2864	2	gaters
gather	10	41	1585	2	gather
gator	6	44	1603	2	gator
gaud	6	70	2543	2	gaud
gauge	7	61	1790	2	gauge
gaum	7	57	2642	2	gaum
gaun	5	64	2771	2	gaun
gaur	5	67	2335	2	gaur
gauze	15	57	1297	2	gauze
gavel	9	58	1518	2	gavel
gawk	12	67	1669	2	gawk
gawp	10	76	1863	2	gawp
gay	7	68	5649	2	ga_y
gayer	9	45	1919	2	gayer
gays	8	73	3802	2	gays
gazed	16	55	2033	2	gazed
gazer	15	57	2007	2	gazer
gazes	15	54	2591	2	gazes
gee	4	53	5920	2	g_ee
gelate	7	34	2125	2	gelate
gene	5	62	3722	2	gene
geste	6	59	2069	2	geste
get	4	74	6746	2	get_
geta	5	66	2744	2	geta
gets	5	54	4248	2	gets
ghat	8	64	3528	2	ghat_
ghats	9	58	1861	2	ghats
ghee	8	57	2611	2	ghee
gibe	7	59	2778	2	gibe
gie	4	71	4954	2	g_ie
git	4	62	6605	2	git_
gites	6	56	3018	2	gites
gits	5	57	4459	2	gits
give	8	58	2935	2	give
glace	8	74	2015	2	glace
glade	7	51	2196	2	glade
glare	6	52	2295	2	glare
glaze	15	54	1816	2	glaze
glee	5	52	3906	2	glee
glue	5	56	2849	2	glue
glute	6	60	2090	2	glute
gnat	5	60	3443	2	gnat_
gnats	6	52	1771	2	gnats
goat	5	62	5083	2	goat_
goatee	7	32	1953	2	goatee
goats	6	55	2730	2	goats
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
got	4	98	7044	2	got_
goth	8	68	2508	2	goth
grace	8	51	2454	2	grace
grade	7	51	2609	2	grade
grape	8	48	2466	2	grape
grat	5	56	5128	2	grat_
grated	8	45	2392	2	grated
grater	7	46	2544	2	grater
grates	7	54	2989	2	grates
grave	9	46	2487	2	grave
graze	15	58	2005	2	graze
gree	5	66	4156	2	gree
grue	5	58	2571	2	grue
gude	6	54	2333	2	gude
gut	4	67	5385	2	gut_
guts	5	66	3725	2	guts
gybe	10	59	1624	2	gybe
gyrate	10	49	1252	2	gyrate
gyre	8	47	2276	2	gyre
gyve	11	62	1508	2	gyve
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
ingate	7	30	1824	2	ingate
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
jugate	14	37	946	2	jugate
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	3824	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
legate	7	29	1745	2	legate
ligate	7	25	1925	2	ligate
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
negate	7	29	1557	2	negate
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
orate	5	51	3330	2	orate
ovate	8	42	1439	2	ovate
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
paste	7	49	3295	2	paste
pat	5	80	8946	2	pat_
pated	8	52	3784	2	pated
paten	7	48	2734	2	paten
pater	7	47	4072	2	pater
pates	7	60	4789	2	pates
path	9	91	3491	2	path
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
pave	9	61	3389	2	pave
plate	7	46	3511	2	plate
prate	7	51	3598	2	prate
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
rugate	7	58	1381	2	rugate
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
spate	7	47	3158	2	spate
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
togate	7	45	1568	2	togate
tote	4	66	4367	2	tote
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.406	440125.6
2	DLD Change Limit	29872	468	0.906	32971.3
3	Display Results	468	468	0.110	4254.5
	(SQL Overall)	178691	468	1.422	125661.7