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

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

79 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
spanned	10	41	1122	(None)
panned	9	41	2343	1	_panned
scanned	10	41	1089	1	scanned
spanked	14	31	1173	1	spanked
spanner	9	43	1256	1	spanner
spawned	13	31	680	1	spawned
swanned	11	35	817	1	swanned
banned	9	47	2134	2	_banned
branned	10	43	1169	2	branned
canned	9	50	2206	2	_canned
fanned	10	41	1747	2	_fanned
inspanned	12	4	285	2	inspanned
japanned	18	4	314	2	japanned
manned	9	44	1864	2	_manned
pained	9	56	2285	2	_pained
paned	8	54	3718	2	_pa_ned
panged	10	47	2233	2	_panged
panne	7	66	2365	2	_panne_
panner	8	42	2476	2	_panner
pannes	8	55	2285	2	_pannes
panted	9	50	2482	2	_panted
pawned	12	45	1328	2	_pawned
penned	9	42	1761	2	_penned
pinned	9	48	1838	2	_pinned
planned	10	38	1015	2	planned
punned	9	34	1619	2	_punned
sained	7	54	2424	2	s_ained
sanded	8	49	2061	2	s_anded
saned	6	56	3627	2	s_a_ned
scanner	9	44	1181	2	scanner
scanted	10	41	1439	2	scanted
shanked	15	32	1212	2	shanked
shinned	11	43	1091	2	shinned
shunned	11	41	784	2	shunned
sinned	7	38	1841	2	s_inned
skanked	11	33	810	2	skanked
skinned	12	38	729	2	skinned
slanged	9	41	1285	2	slanged
slanted	8	35	1474	2	slanted
spaced	11	45	1725	2	spa_ced
spaded	10	38	1675	2	spa_ded
spaed	8	55	2227	2	spa__ed
spalled	10	31	1313	2	spalled
spammed	14	34	852	2	spammed
spancel	11	4	736	2	spancel
spandex	17	3	583	2	spandex
spangled	12	3	615	2	spangled
spaniel	9	4	892	2	spaniel
spanker	13	36	1235	2	spanker
spanners	10	37	1077	2	spanners
spared	9	54	2749	2	spa_red
sparged	11	35	1276	2	sparged
sparked	14	35	1314	2	sparked
sparred	10	45	1286	2	sparred
spasmed	12	29	699	2	spasmed
spathed	13	40	1318	2	spathed
spatted	10	40	1414	2	spatted
spavined	14	3	433	2	spavined
spawner	12	34	736	2	spawner
spayed	12	42	1361	2	spa_yed
speaned	10	34	1152	2	speaned
spined	9	54	2394	2	sp_ined
spinner	9	39	1226	2	spinner
spinney	12	43	892	2	spinney
splined	10	50	1311	2	splined
sponged	11	3	795	2	sponged
spooned	10	34	1244	2	spooned
sprained	11	3	843	2	sprained
spunked	14	30	778	2	spunked
spurned	10	33	926	2	spurned
stained	8	42	1534	2	stained
staned	7	48	2464	2	sta_ned
stanged	9	41	1384	2	stanged
stunned	8	35	889	2	stunned
sunned	7	42	1632	2	s_unned
swanked	15	35	954	2	swanked
tanned	7	52	1995	2	_tanned
vanned	10	46	1448	2	_vanned
wanned	10	43	1801	2	_wanned

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.373	479064.3
2	DLD Change Limit	107671	79	2.986	36058.6
3	Display Results	79	79	0.013	6076.9
	(SQL Overall)	178691	79	3.372	52992.6