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

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

53 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
spamming	15	31	760	(None)
scamming	15	32	854	1	scamming
shamming	16	28	941	1	shamming
slamming	13	33	1000	1	slamming
spasming	13	22	720	1	spasming
bamming	14	46	1181	2	_bamming
clamming	15	32	937	2	clamming
cramming	15	33	943	2	cramming
damming	13	38	1274	2	_damming
dramming	14	34	756	2	dramming
flamming	16	35	715	2	flamming
gamming	13	31	1262	2	_gamming
hamming	15	30	1409	2	_hamming
jamming	19	32	979	2	_jamming
lamming	12	30	1458	2	_lamming
palming	12	39	1401	2	_palming
psalming	13	7	547	2	psalming
ramming	12	31	1506	2	_ramming
scamping	15	35	1019	2	scamping
scramming	16	3	488	2	scramming
scumming	15	25	679	2	scumming
seaming	10	32	2211	2	sea_ming
shaming	13	30	1674	2	sha_ming
shammying	20	4	295	2	shammying
shimming	16	27	825	2	shimming
skimming	17	28	627	2	skimming
slammings	14	23	412	2	slammings
slimming	13	28	809	2	slimming
slumming	13	27	838	2	slumming
spacing	12	36	1449	2	spa_cing
spading	11	31	1438	2	spa_ding
spaeing	10	34	1354	2	spa_eing
spalling	11	32	1346	2	spalling
spanking	15	39	1197	2	spanking
spanning	11	33	1108	2	spanning
sparging	12	26	1113	2	sparging
sparing	10	48	2387	2	spa_ring
sparking	15	28	1254	2	sparking
sparling	11	27	1453	2	sparling
sparring	11	31	1222	2	sparring
spatting	11	31	1176	2	spatting
spawning	14	29	691	2	spawning
spaying	13	30	1462	2	spa_ying
spuming	12	4	852	2	sp_uming
stamping	13	33	1096	2	stamping
stemming	13	40	820	2	stemming
stumming	13	34	767	2	stumming
summing	12	29	1238	2	s_umming
swamping	16	30	792	2	swamping
swarming	14	5	822	2	swarming
swimming	16	31	632	2	swimming
tramming	13	27	934	2	tramming
whamming	19	27	522	2	whamming

Search took 9 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	53	8.170	14817.5
3	Display Results	53	53	0.046	1152.2
	(SQL Overall)	178691	53	8.372	21343.9