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

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

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.

63 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
splattering	14	5	454	(None)
spattering	13	10	779	1	sp_attering
spluttering	14	6	336	1	spluttering
blattering	13	10	871	2	_blattering
clattering	13	10	923	2	_clattering
flattering	14	9	874	2	_flattering
pattering	12	23	1442	2	_p_attering
plastering	13	3	924	2	_plastering
scattering	13	9	801	2	s_cattering
shattering	14	9	828	2	s_hattering
slathering	14	10	828	2	s_lathering
smattering	13	9	758	2	s_mattering
splatting	12	3	598	2	splatt__ing
splintering	14	4	429	2	splintering
sputtering	13	10	646	2	sp_uttering
squattering	21	4	380	2	squattering
battering	12	27	1514	3	__battering
bespattering	17	5	234	3	besp_attering
betattering	14	4	414	3	betattering
blathering	16	10	758	3	_blathering
chattering	16	10	864	3	_chattering
cluttering	13	10	683	3	_cluttering
flattening	14	11	510	3	_flattening
flittering	14	8	650	3	_flittering
fluttering	14	10	629	3	_fluttering
glittering	12	9	600	3	_glittering
lathering	13	9	1225	3	__lathering
lettering	10	21	1207	3	__lettering
littering	10	24	1198	3	__littering
mattering	12	23	1405	3	__mattering
nattering	10	22	1221	3	__nattering
paltering	12	26	1289	3	_p_altering
patterning	13	4	607	3	_p_atterning
plaistering	14	4	460	3	_plaistering
plasterings	14	4	474	3	_plasterings
platting	11	48	1303	3	_platt__ing
pottering	12	26	1200	3	_p_ottering
puttering	12	26	1164	3	_p_uttering
relettering	12	5	551	3	relettering
replastering	15	5	341	3	replastering
scatterings	14	10	397	3	s_catterings
scuttering	13	8	663	3	s_cuttering
shuttering	14	9	656	3	s_huttering
skittering	15	3	539	3	s_kittering
slabbering	15	10	497	3	s_labbering
slandering	12	3	724	3	s_landering
slattern	8	3	709	3	s_latter_n_
slatterns	9	3	536	3	s_latter_ns
slatting	9	40	1423	3	s_latt__ing
slavering	13	3	872	3	s_la_vering
slithering	14	9	689	3	s_lithering
smatterings	14	10	384	3	s_matterings
spatting	11	31	1176	3	sp_att__ing
splatter	10	34	888	3	splatter___
splattered	13	16	393	3	splatter_ed
splatters	11	32	754	3	splatter__s
splitting	12	3	656	3	splitt__ing
sprattling	13	6	305	3	spratt_ling
stuttering	11	9	635	3	s_tuttering
tattering	10	22	1232	3	__tattering
unflattering	16	7	204	3	unflattering
upgathering	18	4	220	3	upgathering
yattering	13	24	1044	3	__yattering

Search took 6 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	121633	0.390	458182.1
2	DLD Change Limit	121633	63	5.453	22305.7
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	5.873	30425.8