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

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

80 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
clanged	11	42	1265	(None)
changed	14	42	1414	1	changed
clagged	12	74	923	1	clagged
clanger	10	41	1349	1	clanger
clanked	14	38	1225	1	clanked
clinged	11	33	1009	1	clinged
flanged	12	38	1084	1	flanged
slanged	9	41	1285	1	slanged
banged	10	49	2372	2	_banged
blanked	14	40	1122	2	blanked
blunged	11	43	1013	2	blunged
cadged	11	48	1233	2	c_adged
caged	9	54	2636	2	c_a_ged
caned	8	58	3809	2	c_an_ed
canned	9	50	2206	2	c_anned
canoed	9	46	1895	2	c_anoed
canted	9	48	2578	2	c_anted
chanced	15	41	1321	2	chanced
change	12	41	1675	2	change_
changer	13	42	1554	2	changer
changes	13	45	1758	2	changes
chanted	13	40	1595	2	chanted
charged	14	46	1402	2	charged
clacked	16	41	1360	2	clacked
cladded	12	35	692	2	cladded
claimed	12	29	883	2	claimed
clammed	14	36	996	2	clammed
clamped	14	40	1204	2	clamped
clang	8	60	1931	2	clang__
clangers	11	43	1234	2	clangers
clangor	10	42	668	2	clangor
clangored	13	4	365	2	clangored
clangs	9	51	1361	2	clang_s
clapped	14	35	1117	2	clapped
clashed	13	36	1401	2	clashed
clasped	12	36	1044	2	clasped
classed	10	41	1365	2	classed
clawed	12	51	1507	2	cla_wed
clayed	12	50	1304	2	cla_yed
cleaned	10	35	1200	2	clean_ed
cleansed	11	39	593	2	cleansed
clinger	10	38	1215	2	clinger
clinked	14	40	1164	2	clinked
clogged	12	52	865	2	clogged
cloned	9	45	1880	2	clon_ed
clonked	14	42	956	2	clonked
clunked	14	43	957	2	clunked
cragged	12	47	988	2	cragged
craned	9	61	2165	2	cran_ed
cranked	14	38	1284	2	cranked
cringed	11	33	1240	2	cringed
danged	9	48	1948	2	_danged
fanged	11	43	1822	2	_fanged
flagged	13	45	963	2	flagged
flange	10	34	1197	2	flange_
flanger	11	34	1262	2	flanger
flanges	11	34	1327	2	flanges
flanked	15	37	1064	2	flanked
ganged	9	46	1919	2	_ganged
glanced	11	43	923	2	glanced
hanged	11	42	2239	2	_hanged
lagged	9	55	2013	2	_lagged
lanced	9	37	1772	2	_lanced
landed	8	46	1924	2	_landed
longed	8	71	2137	2	_longed
lunged	8	54	1827	2	_lunged
panged	10	47	2233	2	_panged
planed	9	44	2091	2	plan_ed
planked	14	35	1228	2	planked
planned	10	38	1015	2	planned
planted	10	35	1612	2	planted
plunged	11	43	952	2	plunged
pranged	11	45	1255	2	pranged
ranged	8	48	2431	2	_ranged
slagged	10	43	1277	2	slagged
slanted	8	35	1474	2	slanted
stanged	9	41	1384	2	stanged
tanged	8	46	2249	2	_tanged
twanged	12	38	727	2	twanged
whanged	15	44	761	2	whanged

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	107671	0.143	1249587.4
2	DLD Change Limit	107671	80	2.890	37256.4
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.063	58338.6