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

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

110 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
clangs	9	51	1361	(None)
changs	12	52	1537	1	changs
clags	8	56	2112	1	cla_gs
clang	8	60	1931	1	clang_
clanks	12	46	1518	1	clanks
clans	7	50	3101	1	clan_s
clings	9	57	1621	1	clings
slangs	7	56	1534	1	slangs
alands	7	54	1837	2	alands
alang	6	60	2351	2	alang_
alans	5	56	3617	2	alan_s
alants	6	77	2202	2	alants
bangs	8	56	2778	2	_bangs
bhangs	12	44	966	2	bhangs
blanks	12	41	1289	2	blanks
canes	7	53	5037	2	c_anes
cans	6	50	5085	2	c_an_s
cants	7	70	3694	2	c_ants
chang	11	54	1856	2	chang_
change	12	41	1675	2	change
changes	13	45	1758	2	changes
chants	11	50	2039	2	chants
clachs	13	35	1132	2	clachs
clacks	14	45	1634	2	clacks
clades	9	49	2046	2	clades
clads	8	57	2273	2	cla_ds
clag	7	59	2457	2	cla_g_
claims	10	52	1157	2	claims
clamps	12	45	1508	2	clamps
clams	9	51	2767	2	cla_ms
clan	6	56	3392	2	clan__
clanged	11	42	1265	2	clanged
clanger	10	41	1349	2	clanger
clangers	11	43	1234	2	clangers
clangor	10	42	668	2	clangor
clangors	11	41	700	2	clangors
clank	11	47	1952	2	clan_k
clanky	15	46	907	2	clanky
claps	9	56	2618	2	cla_ps
claros	8	40	1511	2	claros
clasps	10	45	1209	2	clasps
class	7	55	2548	2	cla_ss
clasts	8	48	1729	2	clasts
claves	11	50	2006	2	claves
clavus	11	34	735	2	clavus
claws	10	60	2083	2	cla_ws
clays	10	55	2133	2	cla_ys
cleans	8	58	1705	2	clean_s
clines	8	49	2604	2	clines
cling	8	64	2467	2	cling_
clingy	12	65	906	2	clingy
clinks	12	58	1506	2	clinks
clogs	8	55	1955	2	cl_ogs
clones	8	45	2656	2	clones
clonks	12	50	1347	2	clonks
clons	7	52	2813	2	clon_s
clonus	8	52	1241	2	clonus
clung	8	60	1360	2	clung_
clunks	12	48	1101	2	clunks
crags	8	56	2257	2	cra_gs
cranes	8	43	3075	2	cranes
cranks	12	50	1531	2	cranks
cyans	10	57	1481	2	cyan_s
dangs	7	56	2321	2	_dangs
elands	7	49	1477	2	elands
elans	5	55	2775	2	elan_s
fangs	9	62	2408	2	_fangs
flags	9	53	2128	2	fla_gs
flanes	9	45	2242	2	flanes
flange	10	34	1197	2	flange
flanges	11	34	1327	2	flanges
flanks	13	39	1340	2	flanks
flans	8	53	2797	2	flan_s
flings	10	67	1528	2	flings
flongs	10	50	1049	2	flongs
gangs	7	62	2258	2	_gangs
glands	8	53	1440	2	glands
glans	6	51	2583	2	glan_s
hangs	9	57	2673	2	_hangs
kiangs	11	37	836	2	kiangs
klongs	11	43	660	2	klongs
lags	5	65	4622	2	_la_gs
lands	6	54	2690	2	_lands
lanes	5	49	4679	2	_lanes
lang	5	66	3739	2	_lang_
liangs	7	44	1059	2	liangs
lings	6	71	3577	2	_lings
llanos	6	10	833	2	llanos
longs	6	55	2706	2	_longs
lungs	6	52	2388	2	_lungs
orangs	7	41	1603	2	orangs
pangs	8	46	2867	2	_pangs
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
prangs	9	48	1623	2	prangs
slags	6	65	2590	2	sla_gs
slang	6	63	2402	2	slang_
slangy	10	54	1139	2	slangy
slants	6	48	1908	2	slants
slings	7	46	1801	2	slings
stangs	7	50	1817	2	stangs
tangs	6	50	2836	2	_tangs
twangs	10	35	810	2	twangs
ulans	5	49	2130	2	ulan_s
vangs	9	63	1960	2	_vangs
whangs	13	43	972	2	whangs
wrangs	10	46	1191	2	wrangs
yangs	9	56	1870	2	_yangs

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.360	496363.9
2	DLD Change Limit	82551	110	2.766	29844.9
3	Display Results	110	110	0.030	3666.7
	(SQL Overall)	178691	110	3.156	56619.5