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

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

508 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
gams	7	66	4888	(None)
bams	8	70	4445	1	bams
cams	8	70	4728	1	cams
dams	7	74	4437	1	dams
gabs	7	67	4042	1	gabs
gads	6	78	4338	1	gads
gaes	5	63	4803	1	gaes
gags	6	64	4106	1	gags
gals	5	79	4650	1	gals
gam	6	70	6006	1	gam_
gama	7	70	3552	1	gama
gamas	8	54	3136	1	gamas
gamb	9	63	3184	1	gamb
gambs	10	57	2112	1	gambs
game	7	66	4432	1	game
games	8	62	3855	1	games
gamp	9	88	3321	1	gamp
gamps	10	53	2371	1	gamps
gamy	10	54	2753	1	gamy
gaps	7	60	4297	1	gaps
gars	5	57	5074	1	gars
gas	4	88	7025	1	ga_s
gats	5	67	5344	1	gats
gaums	8	62	1707	1	gaums
gays	8	73	3802	1	gays
gems	7	53	2911	1	gems
glams	8	58	2293	1	glams
grams	8	53	2731	1	grams
gums	7	50	3094	1	gums
gyms	10	75	1459	1	gyms
hams	9	64	4613	1	hams
jams	13	52	3107	1	jams
lams	6	65	5226	1	lams
ogams	8	41	1268	1	ogams
pams	8	56	4176	1	pams
rams	6	59	5077	1	rams
tams	6	72	4793	1	tams
yams	9	53	3073	1	yams
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
ads	4	97	5573	2	_ads
agama	8	58	1558	2	agama
agamas	9	74	1345	2	agamas
agars	6	61	2064	2	agars
agas	5	59	3884	2	agas
ages	5	58	4459	2	ages
agma	7	76	2326	2	agma
agmas	8	59	1987	2	agmas
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
aims	6	77	3818	2	aims
ais	3	90	8357	2	_ais
alms	6	58	3492	2	alms
als	3	66	6302	2	_als
am	4	118	7556	2	_am_
ama	5	108	5330	2	_ama
amas	6	77	4629	2	_amas
ami	5	66	4681	2	_ami
amis	6	64	4532	2	_amis
amp	7	75	4102	2	_amp
amps	8	62	3034	2	_amps
amu	5	82	3732	2	_amu
amus	6	55	2961	2	_amus
arms	6	61	3749	2	arms
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
bags	7	66	4550	2	bags
balms	9	57	2392	2	balms
bals	6	63	5404	2	bals
bam	7	85	6014	2	bam_
bans	6	65	5514	2	bans
baps	8	60	4084	2	baps
barms	9	61	2846	2	barms
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
beams	9	53	2817	2	beams
blams	9	50	2385	2	blams
bums	8	59	3459	2	bums
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
calms	9	52	2235	2	calms
cam	7	80	5898	2	cam_
camas	9	63	3352	2	camas
came	8	76	4875	2	came
cames	9	70	4731	2	cames
camo	8	57	3175	2	camo
camos	9	59	2761	2	camos
camp	10	63	3645	2	camp
camps	11	63	3026	2	camps
cans	6	50	5085	2	cans
caps	8	71	4789	2	caps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
caws	9	60	3611	2	caws
cays	9	54	3767	2	cays
chams	12	60	2850	2	chams
clams	9	51	2767	2	clams
crams	9	62	2915	2	crams
cwms	11	43	957	2	cwms
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4260	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dam	6	74	5704	2	dam_
dame	7	71	4031	2	dame
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn
damns	8	49	1692	2	damns
damp	9	62	2884	2	damp
damps	10	52	2041	2	damps
dans	5	67	4815	2	dans
daps	7	72	3916	2	daps
daws	8	66	3824	2	daws
days	8	76	3713	2	days
dims	7	54	3502	2	dims
doms	7	62	3957	2	doms
drams	8	60	2583	2	drams
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
egads	7	46	1092	2	egads
elms	6	73	2270	2	elms
ems	5	64	3549	2	_ems
exams	14	19	908	2	exams
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fame	9	56	3939	2	fame
fames	10	57	3592	2	fames
fans	7	62	4737	2	fans
farms	10	63	2495	2	farms
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
fems	9	64	2870	2	fems
flams	10	51	2501	2	flams
foams	10	50	1795	2	foams
gab	6	71	5599	2	ga_b
gaby	10	71	2319	2	gaby
gad	5	75	5665	2	ga_d
gadi	6	63	2972	2	gadi
gadis	7	48	2529	2	gadis
gae	4	64	5770	2	ga_e
gaed	6	60	3151	2	gaed
gaen	5	73	2960	2	gaen
gaff	11	48	2815	2	gaff
gaffs	12	49	1465	2	gaffs
gag	5	77	5363	2	ga_g
gaga	6	66	2555	2	gaga
gage	6	59	3610	2	gage
gages	7	45	2997	2	gages
gain	5	60	4216	2	gain
gains	6	57	2951	2	gains
gait	5	61	5019	2	gait
gaits	6	57	2601	2	gaits
gal	4	60	5551	2	ga_l
gala	5	56	3516	2	gala
galas	6	57	3164	2	galas
gale	5	63	4732	2	gale
gales	6	54	4248	2	gales
gall	5	63	3599	2	gall
galls	6	47	2932	2	galls
gamay	11	64	1911	2	gamay
gamays	12	63	1091	2	gamays
gamba	10	60	1851	2	gamba
gambas	11	58	1751	2	gambas
gambe	10	62	1921	2	gambe
gambes	11	63	1831	2	gambes
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
gamers	9	44	2083	2	gamers
gamest	9	49	1993	2	gamest
gamey	11	53	2055	2	gamey
gamic	10	39	1620	2	gamic
gamin	8	44	2300	2	gamin
gamins	9	44	2005	2	gamins
gamma	10	61	1610	2	gamma
gammas	11	57	1469	2	gammas
gammy	13	55	1489	2	gammy
gamut	8	3	2298	2	gamut
gamuts	9	5	878	2	gamuts
gan	4	80	6013	2	ga_n
gane	5	51	4530	2	gane
gang	6	60	3197	2	gang
gangs	7	62	2257	2	gangs
gaol	5	69	2541	2	gaol
gaols	6	67	1757	2	gaols
gap	6	70	5561	2	ga_p
gape	7	51	3451	2	gape
gapes	8	60	3082	2	gapes
gapy	10	63	2091	2	gapy
gar	4	72	5990	2	ga_r
garb	7	53	3267	2	garb
garbs	8	63	2141	2	garbs
gases	6	56	3399	2	gases
gash	8	68	3302	2	gash
gasp	7	62	2733	2	gasp
gasps	8	54	1548	2	gasps
gassy	9	55	1402	2	gassy
gast	5	60	5256	2	gast
gasts	6	66	2863	2	gasts
gat	4	68	8051	2	ga_t
gate	5	57	4657	2	gate
gates	6	59	3951	2	gates
gaud	6	70	2543	2	gaud
gauds	7	57	1772	2	gauds
gaum	7	57	2642	2	gaum
gaun	5	64	2771	2	gaun
gaur	5	67	2335	2	gaur
gaurs	6	63	1799	2	gaurs
gauss	6	56	1345	2	gauss
gave	8	46	3405	2	gave
gawk	12	67	1669	2	gawk
gawks	13	68	1163	2	gawks
gawp	10	76	1863	2	gawp
gawps	11	59	1101	2	gawps
gawsy	12	45	909	2	gawsy
gay	7	68	5649	2	ga_y
gaze	14	50	3241	2	gaze
gazes	15	54	2591	2	gazes
gears	6	46	2869	2	gears
geds	6	67	3081	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gem	6	68	4022	2	gem_
gens	5	57	4007	2	gens
germs	8	51	1887	2	germs
gets	5	54	4248	2	gets
geums	8	54	1411	2	geums
ghats	9	58	1861	2	ghats
ghis	8	50	2016	2	ghis
gibs	7	55	2927	2	gibs
gids	6	59	3374	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gimp	9	61	2404	2	gimp
gimps	10	59	1520	2	gimps
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
glads	7	56	2061	2	glads
glam	7	65	2934	2	glam_
glans	6	51	2583	2	glans
glass	6	55	1813	2	glass
gleams	9	48	1225	2	gleams
glims	8	74	1767	2	glims
gloams	9	52	1066	2	gloams
gloms	8	52	1978	2	gloms
glums	8	46	2142	2	glums
gnars	6	67	1885	2	gnars
gnats	6	52	1771	2	gnats
gnaws	9	63	1114	2	gnaws
gnus	5	65	1800	2	gnus
goads	7	70	2285	2	goads
goals	6	55	2129	2	goals
goas	5	52	3994	2	goas
goats	6	55	2730	2	goats
gobs	7	69	3557	2	gobs
gods	6	54	3804	2	gods
goes	5	56	4409	2	goes
goos	5	76	4491	2	goos
gorms	8	56	1959	2	gorms
gos	4	71	5513	2	g_os
goys	8	63	2841	2	goys
grabs	8	57	1969	2	grabs
grads	7	56	2575	2	grads
gram	7	70	3458	2	gram_
grama	8	56	2028	2	grama
gramas	9	43	1720	2	gramas
gramp	10	62	1832	2	gramp
gramps	11	41	1427	2	gramps
grans	6	48	3254	2	grans
grass	6	61	2520	2	grass
grays	9	56	2133	2	grays
guans	6	44	1944	2	guans
guars	6	50	2105	2	guars
guls	5	59	3085	2	guls
gum	6	74	3953	2	gum_
guns	5	55	3348	2	guns
guts	5	66	3725	2	guts
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
gym	9	57	1906	2	gym_
gyps	10	51	1502	2	gyps
haems	10	55	1701	2	haems
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
halms	10	52	2521	2	halms
ham	8	63	6328	2	ham_
hame	9	70	4313	2	hame
hames	10	61	3870	2	hames
haps	9	64	4346	2	haps
harms	10	68	2901	2	harms
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
hems	9	55	3494	2	hems
hims	9	52	3097	2	hims
hums	9	68	3142	2	hums
iamb	8	66	2373	2	iamb
iambs	9	58	1506	2	iambs
imams	9	15	1111	2	imams
isms	6	62	1347	2	isms
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jam	12	69	4252	2	jam_
jamb	15	55	2385	2	jamb
jambs	16	60	1462	2	jambs
jars	11	73	3835	2	jars
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kame	10	57	2823	2	kame
kames	11	50	2469	2	kames
kami	10	58	2364	2	kami
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lam	5	76	6671	2	lam_
lama	6	66	3529	2	lama
lamas	7	55	3279	2	lamas
lamb	8	68	3214	2	lamb
lambs	9	59	2141	2	lambs
lame	6	68	4929	2	lame
lames	7	54	4554	2	lames
lamp	8	62	3382	2	lamp
lamps	9	56	2483	2	lamps
laps	6	68	4887	2	laps
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
loams	7	56	1986	2	loams
lums	6	57	3424	2	lums
macs	8	67	4251	2	macs
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
maims	9	63	2179	2	maims
malms	9	50	2155	2	malms
mama	8	62	3159	2	mama
mamas	9	59	3077	2	mamas
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
mars	6	62	6187	2	mars
mas	5	81	7582	2	ma_s
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
mems	8	59	3150	2	mems
moms	8	65	3948	2	moms
mums	8	57	3277	2	mums
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nam	5	59	5339	2	nam_
name	6	56	3741	2	name
names	7	48	3336	2	names
nans	4	61	3940	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nays	7	59	3159	2	nays
nims	6	62	2688	2	nims
noms	6	56	3640	2	noms
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
ogam	7	51	2003	2	ogam_
oghams	12	4	585	2	oghams
ohms	9	55	1403	2	ohms
oms	5	63	3751	2	_oms
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
palms	9	49	2175	2	palms
pals	6	69	5135	2	pals
pam	7	78	5839	2	pam_
pans	6	58	5573	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
poms	8	70	3774	2	poms
prams	9	61	2551	2	prams
qats	13	53	3134	2	qats
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
ram	5	68	6727	2	ram_
rami	6	60	3409	2	rami
ramp	8	59	3400	2	ramp
ramps	9	62	2463	2	ramps
ramus	7	64	1828	2	ramus
raps	6	62	4773	2	raps
ras	3	75	7539	2	ra_s
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
reams	7	57	2962	2	reams
rems	6	62	3772	2	rems
rims	6	59	3630	2	rims
roams	7	49	1961	2	roams
roms	6	70	3896	2	roms
rums	6	48	3347	2	rums
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
same	6	52	4564	2	same
samp	8	57	3359	2	samp
samps	9	61	2467	2	samps
sans	4	51	5336	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
scams	9	44	2397	2	scams
seams	7	57	3166	2	seams
shams	10	58	2941	2	shams
sims	6	57	3717	2	sims
slams	7	49	2790	2	slams
soms	6	62	3937	2	soms
spams	9	49	2219	2	spams
sums	6	58	3758	2	sums
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tam	5	86	6342	2	tam_
tame	6	63	4366	2	tame
tames	7	52	4201	2	tames
tamis	7	67	2873	2	tamis
tamp	8	61	3300	2	tamp
tamps	9	55	2408	2	tamps
tans	4	61	5482	2	tans
taos	4	55	4100	2	taos
taps	6	60	5067	2	taps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
teams	7	57	2651	2	teams
toms	6	83	4349	2	toms
trams	7	53	2767	2	trams
vacs	9	62	2620	2	vacs
vamp	11	55	2154	2	vamp
vamps	12	54	1548	2	vamps
vans	7	62	3673	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	va_s
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
vims	9	54	2331	2	vims
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wame	9	50	3548	2	wame
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
wans	7	64	5227	2	wans
waps	9	66	4208	2	waps
warms	10	77	2685	2	warms
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
whams	13	55	1564	2	whams
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yam	8	74	4899	2	yam_
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	za_s

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.313	570897.8
2	DLD Change Limit	29872	508	0.780	38297.4
3	Display Results	508	508	0.126	4031.7
	(SQL Overall)	178691	508	1.219	146588.2