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

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

254 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
glans	6	51	2583	(None)
alans	5	56	3617	1	alans
clans	7	50	3101	1	clans
elans	5	55	2775	1	elans
flans	8	53	2797	1	flans
glads	7	56	2061	1	glads
glams	8	58	2293	1	glams
gland	7	52	1771	1	gland
glands	8	53	1440	1	glands
glass	6	55	1813	1	glass
gleans	7	50	1474	1	gleans
glens	6	65	1985	1	glens
grans	6	48	3254	1	grans
guans	6	44	1944	1	guans
plans	7	57	3127	1	plans
ulans	5	49	2130	1	ulans
alan	4	68	4408	2	alan_
aland	6	55	2641	2	aland
alands	7	54	1837	2	alands
alane	5	61	3561	2	alane
alang	6	60	2351	2	alang
alant	5	57	4229	2	alant
alants	6	77	2202	2	alants
alas	4	63	5812	2	ala_s
azans	14	65	1688	2	azans
bans	6	65	5514	2	_bans
beans	7	57	3469	2	beans
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blains	8	45	1637	2	blains
blams	9	50	2385	2	blams
bland	8	53	2045	2	bland
blank	11	54	1855	2	blank
blanks	12	41	1289	2	blanks
blats	7	51	3250	2	blats
blaws	10	56	2046	2	blaws
brans	7	54	3743	2	brans
cans	6	50	5085	2	_cans
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
clams	9	51	2767	2	clams
clan	6	56	3392	2	clan_
clang	8	60	1931	2	clang
clangs	9	51	1361	2	clangs
clank	11	47	1952	2	clank
clanks	12	46	1518	2	clanks
claps	9	56	2618	2	claps
class	7	55	2548	2	class
claws	10	60	2083	2	claws
clays	10	55	2133	2	clays
cleans	8	58	1705	2	cleans
clons	7	52	2813	2	clons
cyans	10	57	1481	2	cyans
dans	5	67	4815	2	_dans
deans	6	61	3139	2	deans
elains	6	49	1985	2	elains
elan	4	67	3424	2	elan_
eland	6	58	2039	2	eland
elands	7	49	1477	2	elands
fans	7	62	4737	2	_fans
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flams	10	51	2501	2	flams
flan	7	61	3418	2	flan_
flanes	9	45	2242	2	flanes
flank	12	46	1809	2	flank
flanks	13	39	1340	2	flanks
flaps	10	56	2138	2	flaps
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
gabs	7	67	4042	2	g_abs
gads	6	78	4338	2	g_ads
gaes	5	63	4803	2	g_aes
gags	6	64	4106	2	g_ags
gains	6	57	2951	2	gains
galahs	10	55	1268	2	galahs
galas	6	57	3164	2	galas
gales	6	54	4248	2	gales
galls	6	47	2932	2	galls
gals	5	79	4650	2	g_als
gams	7	66	4888	2	g_ams
gan	4	80	6013	2	g_an_
gane	5	51	4530	2	g_ane
gang	6	60	3198	2	g_ang
gangs	7	62	2258	2	g_angs
gaps	7	60	4297	2	g_aps
gars	5	57	5074	2	g_ars
gas	4	88	7025	2	g_a_s
gats	5	67	5344	2	g_ats
gays	8	73	3802	2	g_ays
gears	6	46	2869	2	gears
gelant	7	28	2167	2	gelant
gelants	8	26	1144	2	gelants
gens	5	57	4007	2	g_ens
ghats	9	58	1861	2	ghats
giant	6	54	3059	2	giant
giants	7	47	1350	2	giants
gins	5	55	4395	2	g_ins
girns	6	45	1680	2	girns
glace	8	74	2016	2	glace
glaces	9	42	1803	2	glaces
glacis	9	40	1213	2	glacis
glad	6	56	2401	2	gla_d
glade	7	51	2196	2	glade
glades	8	48	2034	2	glades
glady	10	54	1394	2	glady
glair	6	53	1355	2	glair
glairs	7	52	1133	2	glairs
glam	7	65	2934	2	gla_m
glance	9	43	1231	2	glance
glances	10	41	1314	2	glances
glandes	9	54	1383	2	glandes
glare	6	52	2296	2	glare
glares	7	55	1887	2	glares
glary	9	60	1854	2	glary
glassy	10	52	775	2	glassy
glaze	15	54	1816	2	glaze
glazes	16	53	1564	2	glazes
glazy	18	74	1098	2	glazy
gleams	9	48	1225	2	gleams
glean	6	58	1820	2	glean_
gleds	7	54	1789	2	gleds
glees	6	50	2759	2	glees
glen	5	60	2720	2	glen_
gleys	9	65	1485	2	gleys
glias	6	46	1849	2	glias
glims	8	74	1767	2	glims
glint	6	68	3018	2	glint
glints	7	57	1421	2	glints
gloams	9	52	1066	2	gloams
gloats	7	45	1542	2	gloats
globs	8	56	1640	2	globs
gloms	8	52	1978	2	gloms
glops	8	56	1955	2	glops
gloss	6	43	1962	2	gloss
glows	9	55	1803	2	glows
glucans	10	4	529	2	glucans
glues	6	51	2568	2	glues
glugs	7	52	1428	2	glugs
glums	8	46	2142	2	glums
gluons	7	3	850	2	gluons
gluts	6	61	2013	2	gluts
glycans	13	4	423	2	glycans
gnars	6	67	1885	2	gnars
gnats	6	52	1771	2	gnats
gnaws	9	63	1114	2	gnaws
goads	7	70	2285	2	goads
goals	6	55	2129	2	goals
goas	5	52	3994	2	goa_s
goats	6	55	2730	2	goats
gobans	9	44	1204	2	gobans
goons	6	53	2677	2	goons
gowans	10	55	1229	2	gowans
gowns	9	51	1510	2	gowns
grabs	8	57	1969	2	grabs
grads	7	56	2575	2	grads
grains	7	42	2309	2	grains
grams	8	53	2731	2	grams
gran	5	63	3501	2	gran_
grana	6	57	2209	2	grana
grand	7	51	2269	2	grand
grands	8	42	1824	2	grands
grant	6	48	4002	2	grant
grants	7	37	2247	2	grants
grass	6	61	2520	2	grass
grays	9	56	2133	2	grays
grins	6	54	2722	2	grins
groans	7	48	1506	2	groans
guan	5	53	2558	2	guan_
guano	6	92	1398	2	guano
guanos	7	38	1199	2	guanos
guars	6	50	2105	2	guars
gulags	8	3	754	2	gulags
guns	5	55	3348	2	g_uns
jeans	12	60	2211	2	jeans
khans	12	46	1517	2	khans
koans	9	58	1862	2	koans
labs	6	71	4512	2	_labs
lacs	6	69	4248	2	_lacs
lads	5	65	4913	2	_lads
lags	5	65	4622	2	_lags
lams	6	65	5226	2	_lams
land	5	63	3731	2	_land
lands	6	54	2690	2	_lands
lane	4	51	5333	2	_lane
lanes	5	49	4679	2	_lanes
lang	5	66	3739	2	_lang
lank	8	47	3445	2	_lank
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
lawns	8	52	1542	2	_lawns
laws	7	64	4168	2	_laws
lays	7	60	4325	2	_lays
leans	5	55	3625	2	leans
lens	4	61	4649	2	_lens
lins	4	70	5905	2	_lins
llano	5	9	1060	2	llano
llanos	6	10	833	2	llanos
loans	5	60	2646	2	loans
mans	6	63	5455	2	_mans
means	7	58	3123	2	means
moans	7	46	2437	2	moans
naans	5	58	1525	2	naans
nans	4	61	3940	2	_nans
pans	6	58	5573	2	_pans
peans	7	54	3764	2	peans
pians	7	51	2696	2	pians
plains	8	50	1959	2	plains
plan	6	58	3394	2	plan_
plane	7	49	2914	2	plane
planes	8	50	2808	2	planes
plank	11	52	2114	2	plank
planks	12	41	1675	2	planks
plant	7	54	3711	2	plant
plants	8	49	2180	2	plants
plats	7	55	3137	2	plats
plays	10	63	2077	2	plays
raglans	8	24	1013	2	raglans
roans	5	49	2644	2	roans
sans	4	51	5336	2	_sans
scans	7	46	2510	2	scans
slabs	7	53	2264	2	slabs
slags	6	65	2590	2	slags
slams	7	49	2790	2	slams
slang	6	63	2402	2	slang
slangs	7	56	1534	2	slangs
slank	9	58	2277	2	slank
slant	5	52	3870	2	slant
slants	6	48	1908	2	slants
slaps	7	60	2571	2	slaps
slats	5	54	3690	2	slats
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
solans	6	41	2249	2	solans
spans	7	45	2873	2	spans
swans	8	46	2501	2	swans
tans	4	61	5483	2	_tans
tolans	6	43	1927	2	tolans
trans	5	49	3304	2	trans
uhlans	9	3	757	2	uhlans
ulan	4	65	2739	2	ulan_
ulnas	5	57	1653	2	ulnas
vans	7	62	3673	2	_vans
wans	7	64	5227	2	_wans
weans	8	53	2674	2	weans
xylans	16	3	588	2	xylans
yeans	8	66	2488	2	yeans
yuans	8	46	1332	2	yuans
yulans	9	5	867	2	yulans

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.326	548131.9
2	DLD Change Limit	53800	254	1.516	35488.1
3	Display Results	254	254	0.080	3175.0
	(SQL Overall)	178691	254	1.922	92971.4