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

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

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.

19 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
barnstorming	17	5	157	(None)
brainstorming	18	6	131	2	brainstorming
barnstorm	13	4	392	3	barnstorm___
barnstormed	16	5	169	3	barnstorm_ed
barnstormer	15	6	171	3	barnstorm_er
barnstormers	16	6	132	3	barnstormers
barnstorms	14	4	294	3	barnstorm__s
brainstormings	19	6	104	3	brainstormings
transforming	18	5	463	3	transforming
ausforming	16	4	250	4	_a_usforming
backstopping	25	5	219	4	backstopping
bantering	12	24	1423	4	ba_n_ter_ing
bartering	12	23	1364	4	bar__ter_ing
pastoring	12	3	1084	4	pa__stor_ing
prestoring	13	3	1028	4	_prestor_ing
ransoming	12	5	650	4	ra_ns_o_ming
restoring	10	3	1460	4	__restor_ing
storming	11	20	942	4	____storming
transporting	15	5	577	4	transporting

Search took 10 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	124790	0.143	1249587.4
2	DLD Change Limit	124790	19	9.216	13540.6
3	Display Results	19	19	0.016	1187.5
	(SQL Overall)	178691	19	9.375	19060.4