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

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

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.

66 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
smatters	10	40	1171	(None)
matters	9	44	2175	1	_matters
scatters	10	36	1275	1	scatters
shatters	11	33	1390	1	shatters
smatter	9	36	1333	1	smatter_
spatters	10	39	1470	1	spatters
swatters	11	39	1179	1	swatters
batters	9	46	2601	2	_batters
blatters	10	44	1409	2	blatters
chatters	13	42	1395	2	chatters
clatters	10	33	1391	2	clatters
emitters	10	34	964	2	emitters
flatters	11	38	1420	2	flatters
hatters	10	42	2152	2	_hatters
masters	9	46	2892	2	_masters
maters	8	50	3239	2	_ma_ters
matter	8	43	2534	2	_matter_
mattery	12	38	1071	2	_mattery
mattes	8	56	2453	2	_matte_s
mutters	9	41	1714	2	_mutters
natters	7	37	1806	2	_natters
omitters	10	27	765	2	omitters
patters	9	48	2519	2	_patters
platters	10	34	1528	2	platters
ratters	7	44	2247	2	_ratters
salters	7	36	2225	2	s_alters
scatter	9	38	1517	2	scatter_
scutters	10	33	1102	2	scutters
seaters	7	40	2894	2	sea_ters
setters	7	38	2206	2	s_etters
shatter	10	36	1569	2	shatter_
shutters	11	36	1134	2	shutters
sitters	7	42	2155	2	s_itters
skaters	11	35	1295	2	ska_ters
skitters	12	34	955	2	skitters
slaters	7	31	2373	2	sla_ters
slathers	11	39	1478	2	slathers
slattern	8	3	709	2	slattern
slatterns	9	3	536	2	slatterns
slitters	8	40	1413	2	slitters
slotters	8	40	1240	2	slotters
smackers	16	31	871	2	smackers
smartens	10	28	666	2	smartens
smarter	9	41	1313	2	smarter_
smashers	13	33	959	2	smashers
smattered	12	18	678	2	smattered
smatterer	11	18	581	2	smatterer
smatterers	12	17	487	2	smatterers
smelters	10	33	1051	2	smelters
smiters	9	34	1436	2	sm_iters
smithers	13	36	979	2	smithers
smothers	13	34	993	2	smothers
spatter	9	40	1652	2	spatter_
spitters	10	41	1338	2	spitters
splatters	11	32	754	2	splatters
spotters	10	43	1338	2	spotters
sputters	10	40	1287	2	sputters
squatters	18	3	494	2	squatters
starters	8	37	1477	2	starters
staters	7	39	2234	2	sta_ters
stutters	8	32	1047	2	stutters
swathers	14	45	1208	2	swathers
swatter	10	41	1332	2	swatter_
swotters	11	44	848	2	swotters
tatters	7	45	2048	2	_tatters
yatters	10	39	1462	2	_yatters

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	121059	0.156	1145455.1
2	DLD Change Limit	121059	66	6.923	17486.5
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	7.109	25135.9