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

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

356 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
gated	7	53	2977	(None)
bated	8	59	3553	1	bated
dated	7	55	3099	1	dated
fated	9	56	3213	1	fated
gaed	6	60	3151	1	ga_ed
gaged	8	55	2231	1	gaged
gaited	8	44	1692	1	gaited
gamed	9	51	2639	1	gamed
gaped	9	61	2353	1	gaped
gasted	8	48	2158	1	gasted
gate	5	57	4657	1	gate_
gater	6	45	3365	1	gater
gates	6	59	3951	1	gates
gazed	16	55	2033	1	gazed
grated	8	45	2392	1	grated
hated	9	57	3402	1	hated
lated	6	52	4067	1	lated
mated	8	55	3778	1	mated
pated	8	52	3784	1	pated
rated	6	54	4138	1	rated
sated	6	62	3853	1	sated
aahed	9	178	1644	2	aahed
abated	9	59	1845	2	abated
abed	7	97	3413	2	_abed
aced	7	95	4088	2	_aced
acted	8	85	2173	2	acted
agate	6	65	2515	2	agate_
agates	7	61	2134	2	agates
aged	6	73	3425	2	_aged
ahed	8	95	3625	2	_ahed
alated	7	56	2515	2	alated
anted	6	63	2824	2	anted
aped	7	85	3815	2	_aped
ate	3	70	5924	2	_ate_
ates	4	50	4792	2	_ates
awed	8	84	3603	2	_awed
axed	12	88	2961	2	_axed
baaed	8	52	1816	2	baaed
baited	9	53	1924	2	baited
baked	12	61	3077	2	baked
baled	8	54	3644	2	baled
baned	8	54	3635	2	baned
bared	8	51	4448	2	bared
based	8	53	3158	2	based
basted	9	52	2723	2	basted
bate	6	65	5242	2	bate_
bates	7	58	4634	2	bates
bathed	12	55	1874	2	bathed
batted	9	56	2365	2	batted
bayed	11	54	2302	2	bayed
boated	9	42	2197	2	boated
caged	9	54	2636	2	caged
caked	12	61	2862	2	caked
caned	8	58	3809	2	caned
canted	9	48	2578	2	canted
caped	10	49	3180	2	caped
cared	8	60	5009	2	cared
carted	9	86	3144	2	carted
cased	8	60	3241	2	cased
cate	6	62	5460	2	cate_
cater	7	48	4072	2	cater
cates	7	59	5189	2	cates
catted	9	54	2247	2	catted
caved	11	62	2756	2	caved
cawed	11	66	2706	2	cawed
cited	8	44	2195	2	cited
coated	9	49	2704	2	coated
coted	8	50	3385	2	coted
crated	9	48	2777	2	crated
dared	7	59	3501	2	dared
darted	8	46	2092	2	darted
date	5	64	4332	2	date_
dater	6	53	3231	2	dater
dates	6	56	3915	2	dates
dauted	8	41	1493	2	dauted
dawed	10	62	2281	2	dawed
dawted	11	48	968	2	dawted
dazed	16	59	1936	2	dazed
doated	8	41	1818	2	doated
doted	7	52	2707	2	doted
eared	6	51	3950	2	eared
eased	6	54	3040	2	eased
eaten	5	53	2305	2	eaten
eater	5	46	3984	2	eater
eaved	9	59	2450	2	eaved
elated	7	47	2582	2	elated
faced	11	77	2765	2	faced
faded	10	50	2524	2	faded
faked	13	52	2548	2	faked
famed	11	59	2834	2	famed
fared	9	58	4234	2	fared
farted	10	51	2178	2	farted
fasted	10	53	2095	2	fasted
fate	7	54	4428	2	fate_
fates	8	51	3923	2	fates
fatted	10	54	1984	2	fatted
faxed	16	62	2053	2	faxed
fayed	12	64	2215	2	fayed
fazed	18	62	2296	2	fazed
feted	9	44	2093	2	feted
gabbed	12	52	1689	2	gabbed
gabled	10	55	1845	2	gabled
gad	5	75	5665	2	ga__d
gadded	10	39	1317	2	gadded
gadid	8	55	1738	2	gadid
gae	4	64	5770	2	ga_e_
gaen	5	73	2960	2	ga_en
gaes	5	63	4803	2	ga_es
gaffed	14	42	1020	2	gaffed
gage	6	59	3610	2	gage_
gager	7	47	2629	2	gager
gages	7	45	2997	2	gages
gagged	10	48	1715	2	gagged
gained	8	46	1746	2	gained
gaiter	7	38	1950	2	gaiter
gale	5	63	4732	2	gale_
galea	6	47	2294	2	galea
gales	6	54	4248	2	gales
galled	8	46	2286	2	galled
game	7	66	4432	2	game_
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gammed	12	42	1616	2	gammed
gane	5	51	4530	2	gane_
ganef	9	63	2246	2	ganef
ganev	9	55	1386	2	ganev
ganged	9	46	1919	2	ganged
gaoled	8	48	1450	2	gaoled
gape	7	51	3451	2	gape_
gaper	8	61	2512	2	gaper
gapes	8	60	3082	2	gapes
gapped	12	42	1712	2	gapped
garbed	10	48	1566	2	garbed
garoted	9	7	1013	2	garoted
garred	8	52	1741	2	garred
garter	7	44	2051	2	garter
gases	6	56	3399	2	gases
gashed	11	63	2197	2	gashed
gasped	10	48	1429	2	gasped
gassed	8	52	1763	2	gassed
gaster	7	50	2735	2	gaster
gat	4	68	8051	2	gat__
gateau	7	7	811	2	gateau
gaters	7	47	2864	2	gaters
gather	10	41	1586	2	gather
gator	6	44	1604	2	gator
gats	5	67	5344	2	gat_s
gaud	6	70	2543	2	ga_ud
gauged	9	47	1347	2	gauged
gaumed	10	46	1032	2	gaumed
gave	8	46	3405	2	gave_
gavel	9	58	1518	2	gavel
gawked	15	46	876	2	gawked
gawped	13	50	907	2	gawped
gayer	9	45	1919	2	gayer
gaze	14	50	3241	2	gaze_
gazer	15	57	2007	2	gazer
gazes	15	54	2591	2	gazes
geared	8	53	1774	2	geared
ged	5	70	4453	2	g__ed
geed	6	54	3550	2	g_eed
gelated	9	36	1564	2	gelated
gibed	9	62	1596	2	gibed
gied	6	46	3198	2	g_ied
gifted	11	45	1070	2	gifted
girted	8	39	1287	2	girted
gite	5	54	3861	2	gite_
gites	6	56	3018	2	gites
gitted	8	40	1505	2	gitted
glared	8	47	1520	2	glared
glazed	17	47	1177	2	glazed
gled	6	56	3114	2	g_led
gleed	7	53	2057	2	gleed
gloated	9	35	1153	2	gloated
glued	7	51	1836	2	glued
gnawed	11	42	783	2	gnawed
goaded	9	49	1371	2	goaded
goaled	8	50	1436	2	goaled
goatee	7	32	1953	2	goatee
goateed	9	30	706	2	goateed
gored	7	52	2708	2	gored
graced	10	52	1790	2	graced
graded	9	49	1955	2	graded
grafted	12	41	1022	2	grafted
granted	9	47	1510	2	granted
grate	6	49	3288	2	grate_
grater	7	46	2544	2	grater
grates	7	54	2989	2	grates
graved	11	48	1881	2	graved
grayed	11	54	1564	2	grayed
grazed	17	41	1591	2	grazed
greed	7	51	2569	2	greed
gusted	8	43	1672	2	gusted
gutted	8	47	1636	2	gutted
guyed	10	4	989	2	guyed
gybed	12	58	1102	2	gybed
gyrated	12	42	841	2	gyrated
gyred	10	51	1409	2	gyred
gyved	13	56	874	2	gyved
haded	10	52	2762	2	haded
haed	8	63	3858	2	ha_ed
hafted	13	47	1383	2	hafted
haled	9	53	3582	2	haled
halted	10	50	1960	2	halted
hanted	10	41	2431	2	hanted
hared	9	57	4218	2	hared
hasted	10	51	2528	2	hasted
hate	7	84	5017	2	hate_
hater	8	50	3475	2	hater
hates	8	67	4257	2	hates
hatred	10	48	1433	2	hatred
hatted	10	49	2151	2	hatted
hawed	12	60	2542	2	hawed
hayed	12	58	2201	2	hayed
hazed	18	52	2220	2	hazed
heated	10	45	2559	2	heated
jaded	14	44	1703	2	jaded
japed	15	62	1763	2	japed
jawed	16	55	1737	2	jawed
kited	10	51	2009	2	kited
laced	8	71	3264	2	laced
laded	7	42	3261	2	laded
laked	10	57	3112	2	laked
lamed	8	52	3529	2	lamed
lased	6	51	3234	2	lased
lasted	7	43	2360	2	lasted
late	4	75	6048	2	late_
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lathed	10	47	1846	2	lathed
laved	9	50	2859	2	laved
lawed	9	60	2832	2	lawed
layed	9	51	2738	2	layed
lazed	15	49	2584	2	lazed
legated	9	25	1398	2	legated
ligated	9	24	1414	2	ligated
luted	6	48	2614	2	luted
maced	10	85	2869	2	maced
malted	9	48	1986	2	malted
maned	8	66	3410	2	maned
marted	9	44	2521	2	marted
masted	9	40	2580	2	masted
mate	6	51	5422	2	mate_
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
matted	9	45	2141	2	matted
mawed	11	58	2474	2	mawed
maxed	15	58	2119	2	maxed
mayed	11	55	2240	2	mayed
mazed	17	55	2387	2	mazed
meated	9	42	2240	2	meated
meted	8	54	2443	2	meted
moated	9	48	1900	2	moated
muted	8	50	2338	2	muted
naked	10	53	2085	2	naked
naled	6	55	2505	2	naled
named	8	52	2306	2	named
nates	5	52	3833	2	nates
negated	9	34	1323	2	negated
noted	6	51	2384	2	noted
oared	6	50	3065	2	oared
oaten	5	52	2240	2	oaten
oater	5	54	3373	2	oater
opted	8	49	1427	2	opted
orated	7	42	2150	2	orated
outed	6	54	2906	2	outed
paced	10	69	3168	2	paced
paged	9	59	2678	2	paged
paled	8	55	3872	2	paled
paned	8	54	3718	2	paned
panted	9	50	2482	2	panted
pared	8	69	4676	2	pared
parted	9	42	2868	2	parted
pasted	9	44	2690	2	pasted
pate	6	53	5046	2	pate_
paten	7	48	2734	2	paten
pater	7	47	4072	2	pater
pates	7	60	4789	2	pates
patted	9	47	2468	2	patted
paved	11	55	2526	2	paved
pawed	11	57	2561	2	pawed
payed	11	59	2593	2	payed
plated	9	52	2577	2	plated
prated	9	49	2492	2	prated
raced	8	76	3531	2	raced
rafted	10	47	1470	2	rafted
raged	7	48	2945	2	raged
raked	10	58	3142	2	raked
ranted	7	43	2470	2	ranted
raped	8	53	3462	2	raped
rared	6	57	3832	2	rared
rased	6	50	3393	2	rased
rate	4	54	5876	2	rate_
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
ratted	7	49	2334	2	ratted
raved	9	49	3143	2	raved
raxed	13	56	2266	2	raxed
rayed	9	51	2750	2	rayed
razed	15	50	2798	2	razed
sabed	8	65	2681	2	sabed
salted	7	41	2120	2	salted
saned	6	56	3627	2	saned
sate	4	55	5610	2	sate_
satem	7	60	2146	2	satem
sates	5	49	4932	2	sates
sauted	7	41	1960	2	sauted
saved	9	51	2711	2	saved
sawed	9	56	2840	2	sawed
sayed	9	61	2714	2	sayed
seated	7	51	3106	2	seated
sited	6	51	3074	2	sited
skated	11	44	1488	2	skated
slated	7	50	2831	2	slated
stated	7	54	2783	2	stated
tamed	8	55	2851	2	tamed
taped	8	53	2742	2	taped
tared	6	93	4005	2	tared
tarted	7	49	2337	2	tarted
tasted	7	41	2397	2	tasted
tate	4	47	4860	2	tate_
tater	5	41	3861	2	tater
tates	5	54	4498	2	tates
tatted	7	49	2053	2	tatted
tauted	7	53	1711	2	tauted
tawed	9	59	2619	2	tawed
taxed	13	56	2029	2	taxed
teated	7	49	2402	2	teated
ted	4	64	4656	2	__ted
togated	9	44	1066	2	togated
toted	6	49	2948	2	toted
ungated	9	27	1721	2	ungated
vaned	9	46	2242	2	vaned
vatted	10	42	1473	2	vatted
voted	9	39	1914	2	voted
waded	10	60	2475	2	waded
wafted	13	40	1214	2	wafted
waged	10	48	2278	2	waged
waited	10	38	1977	2	waited
waked	13	56	2675	2	waked
waled	9	43	3099	2	waled
waned	9	58	3178	2	waned
wanted	10	43	1972	2	wanted
wared	9	63	3987	2	wared
warted	10	42	2323	2	warted
wasted	10	44	2302	2	wasted
water	8	47	3331	2	water
waved	12	52	2358	2	waved
waxed	16	60	1848	2	waxed
wited	9	47	2714	2	wited
wyted	12	52	947	2	wyted
yawed	12	60	2245	2	yawed

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	53800	0.313	570897.8
2	DLD Change Limit	53800	356	1.453	37026.8
3	Display Results	356	356	0.110	3236.4
	(SQL Overall)	178691	356	1.876	95251.1