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

Here are the results of your fuzzy-string dictionary search for “elands” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 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
elands	7	49	1477	(None)
alands	7	54	1837	1	alands
eland	6	58	2039	1	eland_
elans	5	55	2775	1	elan_s
glands	8	53	1440	1	glands
lands	6	54	2690	1	_lands
relands	8	52	1488	1	relands
aland	6	55	2641	2	aland_
alans	5	56	3617	2	alan_s
alants	6	77	2202	2	alants
ands	5	78	3361	2	__ands
bands	8	52	3343	2	_bands
belauds	10	3	664	2	belauds
bland	8	53	2045	2	bland_
blanks	12	41	1289	2	blanks
blends	9	60	1288	2	blends
blinds	9	51	1161	2	blinds
blonds	9	52	1334	2	blonds
brands	9	51	1894	2	brands
clads	8	57	2273	2	cla_ds
clangs	9	51	1361	2	clangs
clanks	12	46	1518	2	clanks
clans	7	50	3101	2	clan_s
demands	11	43	1141	2	demands
desands	9	48	1016	2	desands
egads	7	46	1092	2	ega_ds
elains	6	49	1985	2	elains
elan	4	67	3424	2	elan__
elapids	10	3	650	2	elapids
elates	6	50	3236	2	elates
elds	5	63	2485	2	el__ds
elints	6	58	1642	2	elints
eluants	7	3	758	2	eluants
emends	9	57	1143	2	emends
ends	5	65	2852	2	e__nds
errands	8	4	760	2	errands
expands	17	19	573	2	expands
fenlands	12	4	518	2	fenlands
flanes	9	45	2242	2	flanes
flanks	13	39	1340	2	flanks
flans	8	53	2797	2	flan_s
gelants	8	26	1144	2	gelants
glads	7	56	2061	2	gla_ds
gland	7	52	1771	2	gland_
glandes	9	54	1383	2	glandes
glans	6	51	2583	2	glan_s
grands	8	42	1824	2	grands
hands	9	53	2738	2	_hands
inlands	8	3	878	2	inlands
islands	8	3	732	2	islands
lads	5	65	4913	2	_la_ds
land	5	63	3731	2	_land_
lanes	5	49	4679	2	_lanes
lards	6	53	3186	2	_lards
lauds	6	56	1848	2	_lauds
leads	6	60	2849	2	lea_ds
leans	5	55	3625	2	lean_s
lends	6	53	2625	2	_lends
llanos	6	10	833	2	llanos
plaids	9	43	1244	2	plaids
planes	8	50	2808	2	planes
planks	12	41	1675	2	planks
plans	7	57	3127	2	plan_s
plants	8	49	2180	2	plants
rands	6	59	3045	2	_rands
reland	7	59	2043	2	reland_
relends	8	40	1325	2	relends
remands	10	49	1488	2	remands
sands	6	52	2858	2	_sands
slangs	7	56	1534	2	slangs
slants	6	48	1908	2	slants
solands	8	44	1234	2	solands
stands	7	51	1805	2	stands
ulans	5	49	2130	2	ulan_s
uplands	10	3	694	2	uplands
viands	10	4	781	2	viands
wands	9	64	2548	2	_wands
wetlands	12	4	476	2	wetlands

Search took 4 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	82551	0.343	520965.0
2	DLD Change Limit	82551	78	2.640	31269.3
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	2.999	59583.5