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

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

77 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
clatteringly	18	5	246	(None)
flatteringly	19	5	256	1	flatteringly
clattering	13	10	923	2	clattering__
glitteringly	17	5	186	2	glitteringly
scatteringly	18	7	249	2	scatteringly
shatteringly	19	6	238	2	shatteringly
banteringly	17	4	387	3	_banteringly
blattering	13	10	871	3	blattering__
blisteringly	18	5	229	3	blisteringly
blusteringly	18	5	203	3	blusteringly
chattering	16	10	864	3	chattering__
cluttering	13	10	683	3	cluttering__
falteringly	18	4	314	3	_falteringly
flattering	14	9	874	3	flattering__
potteringly	17	6	294	3	_potteringly
slatternly	13	4	223	3	slatter_n_ly
totteringly	15	5	255	3	_totteringly
unflatteringly	21	6	115	3	unflatteringly
battering	12	27	1514	4	_battering__
blathering	16	10	758	4	blathering__
blunderingly	19	5	164	4	blunderingly
cantering	12	24	1737	4	c_antering__
catering	11	20	1990	4	c_a_tering__
chaptering	18	10	796	4	chaptering__
chartering	16	10	925	4	chartering__
chittering	16	10	718	4	chittering__
clabbering	17	10	458	4	clabbering__
clambering	17	7	616	4	clambering__
clankingly	20	4	330	4	cla__nkingly
clattery	13	37	819	4	clatter____y
clavering	15	3	837	4	cla_vering__
clustering	13	11	681	4	clustering__
cratering	12	3	1265	4	cra_tering__
craterings	13	4	600	4	cra_tering_s
cuttingly	15	4	536	4	c_utt__ingly
flaringly	16	4	625	4	fla___ringly
flattening	14	11	510	4	flattening__
fleeringly	17	4	372	4	fl__eeringly
flickeringly	25	6	123	4	flickeringly
flittering	14	8	650	4	flittering__
fluttering	14	10	629	4	fluttering__
glaringly	14	4	582	4	gla___ringly
glittering	12	9	600	4	glittering__
hearteningly	19	7	243	4	hearteningly
lastingly	13	3	723	4	_last__ingly
lathering	13	9	1225	4	_lathering__
latterly	11	3	606	4	_latter___ly
leeringly	13	4	596	4	_l__eeringly
lettering	10	21	1207	4	_lettering__
letterings	11	22	600	4	_lettering_s
lingeringly	16	5	316	4	_lingeringly
littering	10	24	1198	4	_littering__
mattering	12	23	1405	4	_mattering__
nattering	10	22	1221	4	_nattering__
pattering	12	23	1442	4	_pattering__
plastering	13	3	924	4	plastering__
plasterings	14	4	474	4	plastering_s
prattlingly	17	5	224	4	pratt_lingly
quaveringly	27	5	219	4	qua_veringly
rattlingly	14	4	364	4	_ratt_lingly
scattering	13	9	801	4	scattering__
scatterings	14	10	397	4	scattering_s
shattering	14	9	828	4	shattering__
slantingly	14	4	514	4	slant__ingly
slathering	14	10	828	4	slathering__
smattering	13	9	758	4	smattering__
smatterings	14	10	384	4	smattering_s
spattering	13	10	779	4	spattering__
splattering	14	5	454	4	splattering__
staggeringly	18	5	136	4	staggeringly
swaggeringly	21	5	119	4	swaggeringly
swelteringly	19	5	173	4	swelteringly
tattering	10	22	1232	4	_tattering__
unfalteringly	20	6	179	4	unfalteringly
waveringly	20	4	372	4	_wa_veringly
witheringly	21	5	252	4	_witheringly
yattering	13	24	1044	4	_yattering__

Search took 8 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.390	458182.1
2	DLD Change Limit	124790	77	7.500	16638.7
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	7.936	22516.5