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

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

265 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
alans	5	56	3617	(None)
alan	4	68	4408	1	alan_
aland	6	55	2641	1	aland
alands	7	54	1837	1	alands
alane	5	61	3561	1	alane
alang	6	60	2351	1	alang
alant	5	57	4229	1	alant
alants	6	77	2202	1	alants
alas	4	63	5812	1	ala_s
azans	14	65	1688	1	azans
clans	7	50	3101	1	clans
elans	5	55	2775	1	elans
flans	8	53	2797	1	flans
glans	6	51	2583	1	glans
plans	7	57	3127	1	plans
ulans	5	49	2130	1	ulans
aahs	7	164	2856	2	a_ahs
aals	4	99	4114	2	a_als
aas	3	109	7539	2	a_a_s
abas	6	86	4208	2	aba_s
ablins	8	3	1619	2	ablins
aeons	5	76	2465	2	aeons
afars	8	57	1651	2	afars
agars	6	61	2064	2	agars
agas	5	59	3884	2	aga_s
agons	6	64	2378	2	agons
ains	4	61	5888	2	a_ins
airns	5	55	2103	2	airns
ala	3	124	6360	2	ala__
alack	11	48	2006	2	alack
alae	4	56	4375	2	ala_e
alamo	7	4	1814	2	alamo
alamos	8	4	1500	2	alamos
alanin	6	3	1727	2	alanin
alanins	7	3	1580	2	alanins
alanyl	9	5	548	2	alanyl
alanyls	10	8	435	2	alanyls
alar	4	63	4007	2	ala_r
alarm	7	66	2142	2	alarm
alarms	8	59	1305	2	alarms
alary	8	61	2344	2	alary
alate	5	53	4032	2	alate
alates	6	48	3396	2	alates
albas	7	59	2539	2	albas
albs	6	86	2857	2	al_bs
alecs	7	66	2073	2	alecs
alefs	8	73	1966	2	alefs
ales	4	70	6710	2	al_es
alfas	8	72	1904	2	alfas
algas	6	56	2493	2	algas
algins	7	48	1643	2	algins
alias	5	58	3460	2	alias
aliens	6	56	1921	2	aliens
alifs	8	61	2126	2	alifs
aligns	7	53	1295	2	aligns
aline	5	72	4315	2	aline
alines	6	57	3522	2	alines
alkane	10	43	1332	2	alkane
alkanes	11	38	1293	2	alkanes
allays	9	43	1374	2	allays
alls	4	67	4092	2	al_ls
almahs	11	86	1161	2	almahs
almas	7	66	2977	2	almas
almes	7	51	2654	2	almes
alms	6	58	3492	2	al_ms
aloes	5	49	3367	2	aloes
aloins	6	50	2220	2	aloins
alone	5	57	3296	2	alone
along	6	54	1949	2	along
alps	6	55	2924	2	al_ps
als	3	66	6302	2	al__s
altars	6	45	1815	2	altars
altos	5	58	2295	2	altos
alts	4	66	3990	2	al_ts
alums	7	57	2060	2	alums
always	12	40	913	2	always
amahs	10	78	1906	2	amahs
amas	6	77	4629	2	ama_s
amass	7	71	1968	2	amass
amens	7	56	2484	2	amens
amins	7	55	3432	2	amins
anas	4	66	4986	2	ana_s
anlas	5	56	2693	2	anla_s
annas	5	58	2488	2	annas
araks	9	48	2088	2	araks
asana	5	3	1548	2	asana
asanas	6	5	1411	2	asanas
aslant	6	3	1775	2	aslant
ataps	7	64	1483	2	ataps
atlas	5	58	2158	2	atla_s
atmans	8	44	1396	2	atmans
avant	8	62	2466	2	avant
avens	8	64	1933	2	avens
avians	9	37	1156	2	avians
awns	7	53	2443	2	a_wns
axons	12	55	1793	2	axons
ayahs	11	68	1352	2	ayahs
ayins	8	53	2161	2	ayins
azan	13	65	2178	2	azan_
azlons	15	41	1042	2	azlons
azons	14	65	1825	2	azons
balas	7	69	3721	2	bala_s
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
callans	9	45	1847	2	callans
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
damans	9	47	1598	2	damans
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
galahs	10	55	1267	2	galahs
galas	6	57	3164	2	gala_s
glads	7	56	2061	2	glads
glams	8	58	2293	2	glams
gland	7	52	1771	2	gland
glands	8	53	1440	2	glands
glass	6	55	1813	2	glass
gleans	7	50	1474	2	gleans
glens	6	65	1985	2	glens
grans	6	48	3254	2	grans
guans	6	44	1944	2	guans
halals	9	50	1831	2	halals
halons	9	57	2071	2	halons
hazans	18	34	1165	2	hazans
jalaps	15	29	918	2	jalaps
japans	15	3	982	2	japans
jawans	16	5	784	2	jawans
jeans	12	60	2211	2	jeans
kalams	12	3	1060	2	kalams
kalians	11	3	1018	2	kalians
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
lagans	7	57	1778	2	lagans
lags	5	65	4622	2	_lags
lallans	7	41	1353	2	lallans
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	3738	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
lauans	6	51	1353	2	lauans
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
malars	8	50	2068	2	malars
mans	6	63	5455	2	_mans
means	7	58	3123	2	means
moans	7	46	2437	2	moans
naans	5	58	1525	2	naans
nalas	5	55	2836	2	nala_s
nans	4	61	3940	2	_nans
paeans	8	51	1826	2	paeans
pagans	9	57	1792	2	pagans
palais	8	4	2042	2	palais
pans	6	58	5573	2	_pans
pavans	11	57	1559	2	pavans
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
ratans	6	38	1937	2	ratans
roans	5	49	2644	2	roans
salads	7	53	1696	2	salads
salals	6	51	2008	2	salals
salons	6	38	2369	2	salons
sans	4	51	5336	2	_sans
sarans	6	42	2443	2	sarans
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
talars	6	60	2168	2	talars
talas	5	59	3589	2	tala_s
talons	6	40	1944	2	talons
tans	4	61	5482	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 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.313	570897.8
2	DLD Change Limit	53800	265	1.623	33148.5
3	Display Results	265	265	0.076	3486.8
	(SQL Overall)	178691	265	2.012	88812.6