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

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

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.

52 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
brainstormers	17	6	143	(None)
brainstormer	16	6	179	1	brainstormer_
barnstormers	16	6	132	2	b_arnstormers
brainstormed	17	6	174	2	brainstorme_d
brainstorms	15	5	248	2	brainstorm__s
barnstormer	15	6	171	3	b_arnstormer_
brainstorm	14	5	283	3	brainstorm___
brainstorming	18	6	132	3	brainstorming
brainstormings	19	6	105	3	brainstormings
rainstorms	12	4	365	3	_rainstorm__s
transformers	17	5	375	3	tra_nsformers
barnstormed	16	5	169	4	b_arnstorme_d
barnstorms	14	4	296	4	b_arnstorm__s
brainpowers	18	5	158	4	brain_po_wers
brainstems	14	4	193	4	brainst___ems
brainteasers	14	5	141	4	brain_teasers
rainstorm	11	4	456	4	_rainstorm___
ransomers	11	4	687	4	_ra_ns_o_mers
transformer	16	5	487	4	tra_nsformer_
transporters	14	5	481	4	tra_nsporters
backstories	19	5	531	5	b_ackstorie_s
banisters	11	18	947	5	b_anist___ers
banterers	11	24	1000	5	b_a_n_ter_ers
barnstorm	13	4	393	5	b_arnstorm___
barnstorming	17	5	158	5	b_arnstorming
biostromes	14	4	402	5	b__iostrome_s
blastomere	14	10	400	5	bla__sto_mere
blastomeres	15	8	376	5	bla__sto_meres
brainpower	17	5	168	5	brain_po_wer_
brainstem	13	5	299	5	brainst___e_m
brainteaser	13	5	170	5	brain_teaser_
brainwashers	20	5	160	5	brain_washers
breaststrokers	20	7	59	5	breaststrokers
brimstones	14	6	438	5	br_imsto_ne_s
brownstones	16	14	284	5	brownsto_ne_s
distorters	11	4	716	5	__di_storters
elastomers	12	4	427	5	ela__sto_mers
hailstorms	15	5	241	5	_hailstorm__s
informers	14	20	613	5	___in_formers
ransomer	10	4	788	5	_ra_ns_o_mer_
reinforcers	16	5	241	5	_rein_forcers
reinsurers	10	4	357	5	_reins_ur_ers
restorers	9	51	1011	5	_r__estor_ers
ripsnorters	13	5	128	5	_r_ipsnorters
roisterers	10	4	511	5	_roi_ster_ers
trainbearers	14	5	173	5	trainbear_ers
traitoress	10	4	362	5	trai__tor_ess
transferrers	15	13	366	5	tra_nsferrers
transformed	17	5	475	5	tra_nsforme_d
transforms	15	4	583	5	tra_nsform__s
transponders	15	6	335	5	tra_nsponders
transporter	13	6	606	5	tra_nsporter_

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.156	1145455.1
2	DLD Change Limit	124790	52	8.800	14180.7
3	Display Results	52	52	0.043	1209.3
	(SQL Overall)	178691	52	8.999	19856.8