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

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

38 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
drumming	14	26	578	(None)
dramming	14	34	757	1	dramming
brimming	15	19	662	2	brimming
bumming	14	34	1078	2	_bumming
chumming	18	36	620	2	chumming
cramming	15	33	943	2	cramming
crumbing	15	26	781	2	crumbing
crumping	15	31	990	2	crumping
damming	13	38	1274	2	d_amming
degumming	16	4	313	2	degumming
dimming	13	33	959	2	d_imming
dreaming	12	40	1106	2	dreaming
drubbing	14	28	605	2	drubbing
drudging	12	25	623	2	drudging
drugging	12	32	644	2	drugging
drumbling	15	4	403	2	drumbling
drumlin	10	4	442	2	drumlin_
drumlins	11	4	499	2	drumlins
dumbing	13	31	985	2	d_umbing
dummying	17	26	372	2	d_ummying
dumping	13	37	1291	2	d_umping
grumping	14	26	690	2	grumping
gumming	13	38	1019	2	_gumming
humming	15	33	1067	2	_humming
mumming	11	40	1002	2	_mumming
primming	15	26	817	2	primming
ramming	12	31	1506	2	_ramming
rimming	12	34	1107	2	_rimming
scrumming	16	5	402	2	scrumming
scumming	15	25	679	2	scumming
slumming	13	27	838	2	slumming
strumming	14	5	441	2	strumming
stumming	13	34	767	2	stumming
summing	12	29	1238	2	_summing
thrumming	17	4	290	2	thrumming
tramming	13	27	934	2	tramming
trimming	13	31	865	2	trimming
trumping	13	30	873	2	trumping

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.373	479064.3
2	DLD Change Limit	121059	38	3.780	32026.2
3	Display Results	38	38	0.000
	(SQL Overall)	178691	38	4.153	43027.0