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

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

55 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
spawned	13	31	680	(None)
pawned	12	45	1328	1	_pawned
spanned	10	41	1122	1	spanned
spawner	12	34	736	1	spawner
awned	9	66	1595	2	__awned
dawned	11	39	1209	2	_dawned
fawned	13	49	1042	2	_fawned
impawned	16	4	344	2	impawned
pained	9	56	2285	2	_pained
paned	8	54	3718	2	_pa_ned
panned	9	41	2343	2	_panned
pawed	11	57	2561	2	_paw_ed
pawnee	11	31	1540	2	_pawnee
pawner	11	42	1292	2	_pawner
prawned	13	4	674	2	prawned
sained	7	54	2424	2	s_ained
saned	6	56	3627	2	s_a_ned
sawed	9	56	2840	2	s_aw_ed
sawney	12	38	760	2	s_awney
scanned	10	41	1089	2	scanned
seaweed	11	10	881	2	seaweed
shawed	13	48	1723	2	shaw_ed
shawled	14	3	777	2	shawled
snawed	10	48	1373	2	snaw_ed
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
spanked	14	31	1173	2	spanked
spanner	9	43	1256	2	spanner
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
spawn	10	78	1171	2	spawn__
spawners	13	39	649	2	spawners
spawns	11	57	792	2	spawn_s
spayed	12	42	1361	2	spa_yed
speaned	10	34	1152	2	speaned
spewed	12	55	1233	2	spew_ed
spined	9	54	2394	2	sp_ined
splined	10	50	1311	2	splined
spooned	10	34	1244	2	spooned
sprained	11	3	843	2	sprained
sprawled	14	3	452	2	sprawled
spurned	10	33	926	2	spurned
stained	8	42	1534	2	stained
staned	7	48	2464	2	sta_ned
swanned	11	35	817	2	swanned
yawned	13	50	984	2	_yawned

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	55	3.423	31455.2
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	3.812	46875.9