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

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

345 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
agas	5	59	3884	(None)
aas	3	109	7539	1	a_as
abas	6	86	4208	1	abas
aga	4	104	4723	1	aga_
agar	5	87	2641	1	agar
agars	6	61	2064	1	agars
ages	5	58	4459	1	ages
aghas	9	70	1487	1	aghas
agmas	8	59	1987	1	agmas
ags	4	75	5166	1	ag_s
alas	4	63	5812	1	alas
algas	6	56	2493	1	algas
amas	6	77	4629	1	amas
anas	4	66	4986	1	anas
angas	6	58	2798	1	angas
avgas	9	69	1213	1	avgas
gas	4	88	7025	1	_gas
ragas	6	53	2606	1	ragas
sagas	6	60	2588	1	sagas
aa	2	191	7995	2	a_a_
aah	6	162	5296	2	a_ah
aahs	7	164	2856	2	aahs
aal	3	90	5867	2	a_al
aals	4	99	4114	2	aals
aba	5	128	5095	2	aba_
abase	7	60	2348	2	abase
abash	10	60	1651	2	abash
abbas	9	59	1864	2	abbas
abos	6	77	3441	2	abos
abs	5	93	5607	2	a_bs
abys	9	72	2188	2	abys
aces	6	76	4509	2	aces
acts	6	69	2986	2	acts
adds	6	76	2245	2	adds
ados	5	76	3351	2	ados
ads	4	97	5573	2	a_ds
aegis	6	3	1678	2	aegis
afar	7	67	2078	2	afar
afars	8	57	1651	2	afars
ag	3	110	6746	2	ag__
again	6	52	1811	2	again
agama	8	58	1557	2	agama
agamas	9	74	1344	2	agamas
agape	8	56	1484	2	agape
agapes	9	52	1241	2	agapes
agate	6	65	2514	2	agate
agates	7	61	2133	2	agates
agave	9	53	1403	2	agave
agaves	10	46	1151	2	agaves
agaze	15	61	1366	2	agaze
age	4	71	5433	2	ag_e
aged	6	73	3425	2	aged
agee	5	62	4149	2	agee
ager	5	59	3584	2	ager
agers	6	50	2785	2	agers
agha	8	74	1730	2	agha
aghast	10	57	1136	2	aghast
agin	5	61	3271	2	agin
agio	5	78	2845	2	agio
agios	6	59	1986	2	agios
agism	8	46	1406	2	agism
agist	6	63	2558	2	agist
agitas	7	3	1059	2	agitas
agly	8	68	2180	2	agly
agma	7	76	2326	2	agma
ago	4	88	4552	2	ag_o
agog	6	80	1900	2	agog
agon	5	65	3188	2	agon
agons	6	64	2378	2	agons
agoras	7	6	1334	2	agoras
agrias	7	43	1539	2	agrias
ague	5	57	2592	2	ague
agues	6	49	1905	2	agues
aha	6	112	4664	2	aha_
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	a_hs
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	a_is
aits	4	63	5553	2	aits
ajar	11	62	1770	2	ajar
ajugas	14	3	526	2	ajugas
ala	3	124	6360	2	ala_
alae	4	56	4375	2	alae
alan	4	68	4408	2	alan
alans	5	56	3617	2	alans
alar	4	63	4007	2	alar
albas	7	59	2539	2	albas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
alfas	8	72	1904	2	alfas
alga	5	79	2760	2	alga_
algae	6	53	1962	2	algae
algal	6	65	1821	2	algal
alias	5	58	3460	2	alias
alls	4	67	4092	2	alls
almas	7	66	2977	2	almas
alms	6	58	3492	2	alms
alps	6	55	2924	2	alps
als	3	66	6302	2	a_ls
alts	4	66	3990	2	alts
ama	5	108	5330	2	ama_
amah	9	89	2748	2	amah
amahs	10	78	1906	2	amahs
amass	7	71	1968	2	amass
amias	7	58	3147	2	amias
amigas	9	59	1216	2	amigas
amis	6	64	4532	2	amis
amps	8	62	3034	2	amps
amus	6	55	2961	2	amus
ana	3	95	5982	2	ana_
anal	4	80	3752	2	anal
ands	5	78	3361	2	ands
anes	4	52	5593	2	anes
anga	5	68	3135	2	anga_
anis	4	57	4646	2	anis
anlas	5	56	2693	2	anlas
annas	5	58	2488	2	annas
anoas	5	72	2649	2	anoas
ansa	4	59	2777	2	ansa
antas	5	54	3203	2	antas
ants	4	72	4347	2	ants
anus	4	71	3111	2	anus
apes	6	60	4743	2	apes
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
aquas	14	24	1261	2	aquas
arak	8	69	2957	2	arak
araks	9	48	2088	2	araks
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
areas	5	59	3577	2	areas
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
argal	6	50	2338	2	argal
argals	7	55	1770	2	argals
argus	6	67	1654	2	argus
arias	5	54	3802	2	arias
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
arras	5	56	2613	2	arras
ars	3	76	7093	2	a_rs
arts	4	96	5026	2	arts
as	2	110	8307	2	__as
asks	8	57	2121	2	asks
asps	6	56	2209	2	asps
ass	3	78	4406	2	a_ss
atap	6	67	2245	2	atap
ataps	7	64	1483	2	ataps
ates	4	50	4792	2	ates
atlas	5	58	2158	2	atlas
atmas	7	57	2101	2	atmas
auks	8	55	2526	2	auks
auras	5	59	3255	2	auras
ava	6	101	3932	2	ava_
avast	8	55	1936	2	avast
aves	7	61	4260	2	aves
avos	7	72	2701	2	avos
awa	6	119	3967	2	awa_
awash	11	66	1316	2	awash
away	10	80	2422	2	away
awes	7	60	3755	2	awes
awls	7	59	2609	2	awls
awns	7	53	2443	2	awns
axal	11	65	2049	2	axal
axes	11	73	3785	2	axes
axis	11	61	2791	2	axis
ayah	10	80	2299	2	ayah
ayahs	11	68	1352	2	ayahs
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	a_ys
azan	13	65	2178	2	azan
azans	14	65	1688	2	azans
baas	6	68	4467	2	baas
babas	9	63	2573	2	babas
bagass	9	3	893	2	bagass
bags	7	66	4550	2	bag_s
balas	7	69	3721	2	balas
bas	5	86	8175	2	_bas
bias	6	47	3816	2	bias
boas	6	61	5083	2	boas
bras	6	57	4645	2	bras
cacas	9	56	2798	2	cacas
cages	8	59	3601	2	cages
camas	9	63	3352	2	camas
casas	7	53	2784	2	casas
dadas	7	58	1986	2	dadas
daggas	9	3	797	2	daggas
dagos	7	64	1944	2	dagos
dags	6	66	4259	2	dag_s
degas	7	51	1916	2	degas
egad	6	42	1541	2	egad
egads	7	46	1092	2	egads
egal	5	51	1943	2	egal
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
eras	4	54	4150	2	eras
etas	4	64	3227	2	etas
eyas	7	64	2743	2	eyas
fags	8	69	3912	2	fag_s
fangas	10	50	1719	2	fangas
fas	6	82	6293	2	_fas
favas	11	56	1859	2	favas
gab	6	71	5599	2	_gab
gabs	7	67	4042	2	gabs
gad	5	75	5665	2	_gad
gads	6	78	4338	2	gads
gae	4	64	5770	2	_gae
gaes	5	63	4803	2	gaes
gag	5	77	5363	2	_gag
gaga	6	66	2555	2	gaga_
gages	7	45	2997	2	gages
gags	6	64	4106	2	gags
gal	4	60	5551	2	_gal
galas	6	57	3164	2	galas
gals	5	79	4650	2	gals
gam	6	70	6006	2	_gam
gamas	8	54	3135	2	gamas
gams	7	66	4888	2	gams
gan	4	80	6012	2	_gan
gap	6	70	5561	2	_gap
gaps	7	60	4297	2	gaps
gar	4	72	5990	2	_gar
gars	5	57	5074	2	gars
gash	8	68	3302	2	_gash
gasp	7	62	2733	2	_gasp
gast	5	60	5256	2	_gast
gat	4	68	8051	2	_gat
gats	5	67	5344	2	gats
gay	7	68	5649	2	_gay
gays	8	73	3802	2	gays
gigas	7	54	1558	2	gigas
goas	5	52	3994	2	goas
gos	4	71	5513	2	_gos
hags	8	67	4084	2	hag_s
hahas	11	71	1844	2	hahas
has	6	73	7265	2	_has
iggs	6	66	1267	2	iggs
jaggs	14	81	1149	2	jaggs
jagras	14	3	846	2	jagras
jags	12	61	3279	2	jag_s
javas	15	59	1542	2	javas
kaas	8	65	3184	2	kaas
kagus	10	58	1203	2	kagus
kakas	8	51	1734	2	kakas
kanas	9	53	2691	2	kanas
kapas	11	60	2173	2	kapas
kas	7	70	5858	2	_kas
katas	9	59	2209	2	katas
kavas	12	59	1995	2	kavas
keas	8	63	3709	2	keas
koas	8	56	3509	2	koas
kvas	11	70	1594	2	kvas
lagan	6	65	2034	2	lagan
lagans	7	57	1778	2	lagans
lags	5	65	4622	2	lag_s
lamas	7	55	3279	2	lamas
las	3	72	8147	2	_las
lavas	8	54	2222	2	lavas
leas	4	59	5418	2	leas
mages	8	50	3602	2	mages
magmas	11	55	1250	2	magmas
mags	7	54	4452	2	mag_s
magus	8	53	1875	2	magus
mamas	9	59	3077	2	mamas
manas	7	62	4042	2	manas
mangas	9	41	2292	2	mangas
maras	7	54	4328	2	maras
mas	5	81	7581	2	_mas
masas	7	56	3041	2	masas
mayas	10	59	2438	2	mayas
moas	6	55	4534	2	moas
nadas	6	63	2081	2	nadas
nags	5	54	3602	2	nag_s
nalas	5	55	2836	2	nalas
nanas	5	59	2863	2	nanas
napas	7	59	2435	2	napas
obas	6	57	3093	2	obas
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
ogam	7	51	2003	2	ogam
ogams	8	41	1268	2	ogams
okas	8	52	2539	2	okas
pacas	9	60	2940	2	pacas
pagan	8	61	2116	2	pagan
pagans	9	57	1792	2	pagans
pages	8	52	3507	2	pages
pangas	9	99	2110	2	pangas
papas	9	49	2749	2	papas
paras	7	61	4304	2	paras
pas	5	87	7574	2	_pas
peas	6	57	5506	2	peas
pias	6	65	4255	2	pias
pyas	9	62	2570	2	pyas
raga	5	59	3081	2	raga_
rages	6	45	3944	2	rages
raggs	7	52	1647	2	raggs
ragis	6	63	2560	2	ragis
rags	5	54	4837	2	rag_s
raias	5	46	3112	2	raias
rajas	12	73	1772	2	rajas
ras	3	75	7539	2	_ras
rayas	8	59	2205	2	rayas
rias	4	55	4059	2	rias
ryas	7	72	2461	2	ryas
saga	5	53	3117	2	saga_
sages	6	53	3906	2	sages
sagos	6	61	2387	2	sagos
sags	5	59	4840	2	sag_s
saigas	7	41	1429	2	saigas
sangas	7	52	2265	2	sangas
seas	4	57	5527	2	seas
skas	8	53	2571	2	skas
spas	6	70	3672	2	spas
tags	5	55	4523	2	tag_s
taigas	7	37	1255	2	taigas
takas	9	55	2068	2	takas
talas	5	59	3589	2	talas
tapas	7	46	2771	2	tapas
tas	3	84	7710	2	_tas
teas	4	58	5149	2	teas
togas	6	78	2300	2	togas
twas	7	68	2408	2	twas
ughs	8	54	1097	2	ughs
upas	6	83	2238	2	upas
utas	4	59	2495	2	utas
vagal	9	46	1363	2	vagal
vagus	9	67	1381	2	vagus
varas	8	60	2819	2	varas
vas	6	77	5577	2	_vas
vigas	9	48	1788	2	vigas
wages	9	53	3093	2	wages
wags	8	61	4055	2	wag_s
was	6	87	6756	2	_was
yagis	9	54	1657	2	yagis
yags	8	66	3229	2	yag_s
yeas	7	86	3842	2	yeas
yogas	9	66	1560	2	yogas
yugas	9	50	1206	2	yugas
zags	14	68	2668	2	zag_s
zas	12	69	4683	2	_zas

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.076	2351197.4
2	DLD Change Limit	29872	345	0.830	35990.4
3	Display Results	345	345	0.076	4539.5
	(SQL Overall)	178691	345	0.982	181966.4