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

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

56 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
clamming	15	32	937	(None)
claiming	13	27	930	1	claiming
clamping	15	40	1115	1	clamping
cramming	15	33	943	1	cramming
flamming	16	35	715	1	flamming
lamming	12	30	1458	1	_lamming
slamming	13	33	1000	1	slamming
alarming	11	3	858	2	alarming
bamming	14	46	1181	2	_bamming
blaming	12	35	1569	2	bla_ming
calming	12	39	1597	2	c_alming
camping	14	31	1897	2	c_amping
chammying	22	4	335	2	chammying
champing	18	36	1093	2	champing
charming	16	30	1203	2	charming
chumming	18	36	620	2	chumming
clacking	17	33	1349	2	clacking
cladding	13	3	714	2	cladding
clagging	13	32	887	2	clagging
clammier	14	3	584	2	clammier
clammily	17	4	363	2	clammily
clamoring	14	7	742	2	clamoring
clanging	12	40	1212	2	clanging
clanking	15	43	1306	2	clanking
clapping	15	38	1060	2	clapping
clashing	14	38	1219	2	clashing
clasping	13	33	1026	2	clasping
classing	11	32	1179	2	classing
clawing	13	38	1267	2	cla_wing
claying	13	36	1430	2	cla_ying
climbing	15	20	598	2	climbing
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
coaming	12	38	1832	2	coa_ming
cramping	15	34	1185	2	cramping
damming	13	38	1274	2	_damming
dramming	14	34	756	2	dramming
flaming	13	42	1644	2	fla_ming
gamming	13	31	1262	2	_gamming
glomming	14	27	592	2	glomming
hamming	15	30	1409	2	_hamming
jamming	19	32	979	2	_jamming
lambing	12	34	1241	2	_lambing
laming	9	45	2836	2	_la_ming
lamping	12	31	1600	2	_lamping
lemming	12	26	939	2	_lemming
ramming	12	31	1506	2	_ramming
scamming	15	32	854	2	scamming
scramming	16	3	488	2	scramming
shamming	16	28	941	2	shamming
slammings	14	23	412	2	slammings
slimming	13	28	809	2	slimming
slumming	13	27	838	2	slumming
spamming	15	31	760	2	spamming
tramming	13	27	934	2	tramming
whamming	19	27	522	2	whamming

Search took 5 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.390	458182.1
2	DLD Change Limit	121059	56	3.890	31120.6
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	4.296	41594.7