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

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

348 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
gater	6	45	3365	(None)
cater	7	48	4072	1	cater
dater	6	53	3231	1	dater
eater	5	46	3984	1	eater
gager	7	47	2629	1	gager
gaiter	7	38	1950	1	gaiter
gamer	8	49	2894	1	gamer
gaper	8	61	2512	1	gaper
garter	7	44	2051	1	garter
gaster	7	50	2735	1	gaster
gate	5	57	4657	1	gate_
gated	7	53	2977	1	gated
gaters	7	47	2864	1	gaters
gates	6	59	3951	1	gates
gather	10	41	1585	1	gather
gator	6	44	1603	1	gator
gayer	9	45	1919	1	gayer
gazer	15	57	2007	1	gazer
grater	7	46	2544	1	grater
hater	8	50	3475	1	hater
later	5	48	4392	1	later
mater	7	44	3886	1	mater
oater	5	54	3373	1	oater
pater	7	47	4072	1	pater
rater	5	49	4328	1	rater
tater	5	41	3861	1	tater
water	8	47	3331	1	water
abater	8	55	1812	2	abater
after	8	57	1979	2	after
agate	6	65	2515	2	agate_
agates	7	61	2134	2	agates
ager	5	59	3584	2	_ager
agger	7	64	2089	2	agger
alter	5	48	2850	2	alter
aper	6	63	3623	2	_aper
apter	7	61	2020	2	apter
aster	5	54	3489	2	aster
ate	3	70	5924	2	_ate_
ates	4	50	4792	2	_ates
aver	7	59	3188	2	_aver
baiter	8	44	2255	2	baiter
baker	11	56	2954	2	baker
baler	7	56	3527	2	baler
banter	8	48	2533	2	banter
barer	7	45	3580	2	barer
barter	8	55	2537	2	barter
baser	7	48	2892	2	baser
baster	8	53	3359	2	baster
bate	6	65	5242	2	bate_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bather	11	53	2251	2	bather
batter	8	49	2887	2	batter
beater	8	47	2939	2	beater
biter	7	50	3003	2	biter
boater	8	46	2209	2	boater
caber	9	51	2683	2	caber
cager	8	52	2922	2	cager
caner	7	53	3477	2	caner
canter	8	52	3011	2	canter
caper	9	48	3162	2	caper
carer	7	49	4233	2	carer
carter	8	49	3227	2	carter
caster	8	52	3257	2	caster
cate	6	62	5460	2	cate_
caters	8	53	3650	2	caters
cates	7	59	5189	2	cates
caver	10	56	2906	2	caver
citer	7	48	2733	2	citer
coater	8	43	2957	2	coater
crater	8	50	2664	2	crater
cuter	7	47	2823	2	cuter
dafter	10	48	1334	2	dafter
darer	6	52	3079	2	darer
darter	7	53	2036	2	darter
date	5	64	4332	2	date_
dated	7	55	3099	2	dated
daters	7	48	2737	2	daters
dates	6	56	3915	2	dates
deter	6	50	2804	2	deter
doter	6	54	2862	2	doter
eager	6	55	2697	2	eager
easter	6	50	2798	2	easter
eaten	5	53	2305	2	eaten
eaters	6	55	3595	2	eaters
eatery	9	53	1635	2	eatery
elater	6	47	2420	2	elater
enter	5	47	2638	2	enter
ester	5	47	2771	2	ester
facer	10	55	2505	2	facer
fader	9	44	2151	2	fader
faker	12	48	2459	2	faker
falter	9	45	1905	2	falter
farer	8	67	3314	2	farer
faster	9	46	2577	2	faster
fate	7	54	4428	2	fate_
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
father	12	51	1671	2	father
fatter	9	45	2321	2	fatter
feater	9	52	2405	2	feater
frater	9	45	2059	2	frater
gabber	11	49	1660	2	gabber
gadder	9	37	1471	2	gadder
gae	4	64	5770	2	ga_e_
gaed	6	60	3151	2	ga_ed
gaen	5	73	2960	2	ga_en
gaes	5	63	4803	2	ga_es
gaffer	13	43	1013	2	gaffer
gage	6	59	3610	2	gage_
gaged	8	55	2231	2	gaged
gagers	8	40	2133	2	gagers
gages	7	45	2997	2	gages
gagger	9	50	1651	2	gagger
gagster	9	31	763	2	gagster
gainer	7	41	1749	2	gainer
gaited	8	44	1692	2	gaited
gaiters	8	35	1654	2	gaiters
gale	5	63	4732	2	gale_
galea	6	47	2293	2	galea
galere	7	37	1667	2	galere
gales	6	54	4248	2	gales
game	7	66	4432	2	game_
gamed	9	51	2639	2	gamed
gamers	9	44	2083	2	gamers
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gamier	9	36	1793	2	gamier
gammer	11	123	1833	2	gammer
gander	8	43	2276	2	gander
gane	5	51	4530	2	gane_
ganef	9	63	2246	2	ganef
ganev	9	55	1386	2	ganev
ganger	8	37	2146	2	ganger
gaoler	7	39	1357	2	gaoler
gape	7	51	3451	2	gape_
gaped	9	61	2353	2	gaped
gapers	9	45	2047	2	gapers
gapes	8	60	3082	2	gapes
gar	4	72	5990	2	ga__r
garner	7	39	1700	2	garner
garters	8	42	1823	2	garters
gases	6	56	3399	2	gases
gasher	10	43	2037	2	gasher
gasper	9	45	1554	2	gasper
gasser	7	50	1777	2	gasser
gasted	8	48	2158	2	gasted
gasters	8	56	2429	2	gasters
gat	4	68	8051	2	gat__
gateau	7	7	811	2	gateau
gathers	11	43	1507	2	gathers
gators	7	41	1583	2	gators
gats	5	67	5344	2	gat_s
gauger	8	47	1485	2	gauger
gaunter	8	29	1071	2	gaunter
gaur	5	67	2335	2	ga_ur
gave	8	46	3405	2	gave_
gavel	9	58	1518	2	gavel
gawker	14	55	935	2	gawker
gawper	12	49	969	2	gawper
gazar	15	46	1298	2	gazar
gaze	14	50	3241	2	gaze_
gazed	16	55	2033	2	gazed
gazers	16	45	1630	2	gazers
gazes	15	54	2591	2	gazes
getter	7	41	1761	2	getter
giber	8	54	1770	2	giber
gite	5	54	3861	2	gite_
gites	6	56	3018	2	gites
giver	9	49	2120	2	giver
glazer	16	42	1226	2	glazer
gloater	8	37	1101	2	gloater
gluer	6	51	1677	2	gluer
gnawer	10	38	695	2	gnawer
goatee	7	32	1953	2	goatee
goer	5	68	2710	2	g_oer
gofer	9	48	1428	2	gofer
goiter	7	41	1620	2	goiter
gomer	8	52	2065	2	gomer
goner	6	60	2516	2	goner
grader	8	49	1969	2	grader
grafter	11	42	1115	2	grafter
granter	8	41	1713	2	granter
grate	6	49	3288	2	grate_
grated	8	45	2392	2	grated
graters	8	54	1974	2	graters
grates	7	54	2989	2	grates
graver	10	50	1859	2	graver
grayer	10	60	1454	2	grayer
grazer	16	48	1576	2	grazer
greater	8	44	1649	2	greater
gutter	7	38	1771	2	gutter
hafter	12	48	1588	2	hafter
haler	8	50	3352	2	haler
halter	9	44	2088	2	halter
hate	7	84	5017	2	hate_
hated	9	57	3402	2	hated
haters	9	49	3040	2	haters
hates	8	67	4257	2	hates
hatter	9	47	2487	2	hatter
haver	11	51	2446	2	haver
hayer	11	46	2024	2	hayer
hazer	17	48	2023	2	hazer
heater	9	48	2830	2	heater
inter	5	50	2849	2	inter
irater	6	52	1835	2	irater
jager	13	43	1813	2	jager
japer	14	62	1888	2	japer
kiter	9	55	2321	2	kiter
krater	10	40	1431	2	krater
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
laser	5	46	3332	2	laser
laster	6	48	3063	2	laster
late	4	75	6048	2	late_
lated	6	52	4067	2	lated
laten	5	43	2834	2	laten
latex	12	47	1711	2	latex
lather	9	51	2435	2	lather
latter	6	50	2789	2	latter
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
liter	5	47	3634	2	liter
macer	9	121	2694	2	macer
maker	11	41	2781	2	maker
maser	7	50	2997	2	maser
master	8	48	3134	2	master
mate	6	51	5422	2	mate_
mated	8	55	3778	2	mated
maters	8	50	3239	2	maters
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
matier	8	43	2152	2	matier
matter	8	43	2534	2	matter
mazer	16	57	2242	2	mazer
meter	7	51	3032	2	meter
miter	7	57	3479	2	miter
muter	7	45	2554	2	muter
namer	7	56	2210	2	namer
nates	5	52	3833	2	nates
natter	6	44	2074	2	natter
neater	6	44	2431	2	neater
negater	8	37	1196	2	negater
niter	5	50	2897	2	niter
noter	5	50	2564	2	noter
oaten	5	52	2240	2	oaten
oaters	6	50	2979	2	oaters
ofter	8	41	1687	2	ofter
otter	5	44	2397	2	otter
outer	5	56	3330	2	outer
oxter	12	34	1409	2	oxter
pacer	9	61	3161	2	pacer
pager	8	47	2820	2	pager
paler	7	54	3693	2	paler
palter	8	44	2326	2	palter
paper	9	51	2866	2	paper
parer	7	58	3990	2	parer
paster	8	57	3437	2	paster
pate	6	53	5046	2	pate_
pated	8	52	3784	2	pated
paten	7	48	2734	2	paten
paters	8	49	3583	2	paters
pates	7	60	4789	2	pates
patter	8	46	2826	2	patter
patzer	17	31	1164	2	patzer
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
peter	7	44	2759	2	peter
plater	8	44	2769	2	plater
prater	8	48	2535	2	prater
racer	7	52	3302	2	racer
rafter	9	45	1758	2	rafter
raker	9	45	2979	2	raker
ranter	6	38	2682	2	ranter
raper	7	49	3275	2	raper
rarer	5	47	3170	2	rarer
raser	5	56	3341	2	raser
raster	6	47	3144	2	raster
rate	4	54	5876	2	rate_
rated	6	54	4138	2	rated
ratel	5	42	2488	2	ratel
raters	6	39	3658	2	raters
rates	5	53	5201	2	rates
rather	9	43	1974	2	rather
ratter	6	43	2631	2	ratter
raver	8	56	3149	2	raver
rawer	8	46	2373	2	rawer
razer	14	48	2427	2	razer
saber	7	53	3024	2	saber
safer	8	47	2181	2	safer
sager	6	54	3205	2	sager
saker	9	51	3202	2	saker
salter	6	43	2508	2	salter
saner	5	43	3432	2	saner
sate	4	55	5610	2	sate_
sated	6	62	3853	2	sated
satem	7	60	2146	2	satem
sates	5	49	4932	2	sates
satyr	8	4	848	2	satyr
saver	8	48	3125	2	saver
sawer	8	50	2621	2	sawer
sayer	8	49	2655	2	sayer
seater	6	45	3416	2	seater
skater	10	50	1549	2	skater
slater	6	44	2918	2	slater
stater	6	44	2756	2	stater
taber	7	38	2582	2	taber
taker	9	52	2900	2	taker
taler	5	60	3486	2	taler
tamer	7	52	3010	2	tamer
taper	7	48	2977	2	taper
tarter	6	40	2356	2	tarter
taster	6	49	3057	2	taster
tatar	5	61	2206	2	tatar
tate	4	47	4860	2	tate_
taters	6	49	3220	2	taters
tates	5	54	4498	2	tates
tatter	6	40	2457	2	tatter
tauter	6	43	1802	2	tauter
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
titer	5	54	3061	2	titer
toter	5	59	3213	2	toter
utter	5	42	1876	2	utter
vaster	9	45	2102	2	vaster
voter	8	51	2105	2	voter
wader	9	53	2536	2	wader
wafer	11	44	1764	2	wafer
wafter	12	41	1461	2	wafter
wager	9	59	2505	2	wager
waiter	9	43	2125	2	waiter
waker	12	55	2659	2	waker
waler	8	42	2926	2	waler
wanter	9	44	2305	2	wanter
waster	9	52	2894	2	waster
waters	9	50	3063	2	waters
watery	12	39	1449	2	watery
watter	9	32	2198	2	watter
waver	11	50	2570	2	waver
waxer	15	43	1748	2	waxer
yager	9	56	1675	2	yager
yarer	8	43	2157	2	yarer
yatter	9	41	1621	2	yatter

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.330	541487.9
2	DLD Change Limit	53800	348	1.640	32804.9
3	Display Results	348	348	0.093	3741.9
	(SQL Overall)	178691	348	2.063	86617.1