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

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

35 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
scatterbrains	17	6	124	(None)
scatterbrain	16	6	131	1	scatterbrain_
scatterbrained	19	7	71	2	scatterbrained
featherbrains	21	13	224	3	featherbrains
scattergrams	17	8	116	3	scattergra_ms
featherbrain	20	12	234	4	featherbrain_
rattlebrains	14	6	143	4	_rattlebrains
scatterations	15	5	254	4	scatterations
scatterers	12	20	504	4	scatterer___s
scattergram	16	8	144	4	scattergra__m
scatterguns	14	5	127	4	scatte__rguns
scattering	13	9	801	4	scatte__r_ing
scatterings	14	10	397	4	scatte__r_ings
afterpains	15	5	351	5	__after_pains
caterans	10	3	1322	5	_ca_te__ra_ns
catteries	11	8	1552	5	_catte__r_ies
featherbrained	23	7	155	5	featherbrained
lamebrains	14	4	338	5	_la_me_brains
rattlebrain	13	6	154	5	_rattlebrain_
sauerbratens	14	6	77	5	s_a_uerbratens
scatteration	14	5	292	5	scatter_ation
scatterer	11	18	629	5	scatterer____
scattergoods	16	6	135	5	scatter_goods
scattergun	13	5	149	5	scatte__rgun_
scatters	10	36	1275	5	scatte__r___s
scuttering	13	8	663	5	scutte__r_ing
seatrains	9	4	760	5	sea_t___rains
shatterers	13	18	572	5	shatterer___s
shattering	14	9	828	5	shatte__r_ing
slatterns	9	3	536	5	slatte__r__ns
smatterers	12	17	487	5	smatterer___s
smattering	13	9	758	5	smatte__r_ing
smatterings	14	10	384	5	smatte__r_ings
spattering	13	10	779	5	spatte__r_ing
terrains	8	4	1032	5	____ter_rains

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.420	425454.8
2	DLD Change Limit	124790	35	9.393	13285.4
3	Display Results	35	35	0.016	2187.5
	(SQL Overall)	178691	35	9.829	18180.0