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

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

21 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
hummocking	24	10	186	(None)
mammocking	20	5	239	2	mammocking
bemocking	20	3	465	3	_bemocking
gimmicking	22	4	198	3	gimmicking
havocking	22	4	277	3	h_avocking
hocking	17	34	1724	3	h___ocking
humming	15	33	1067	3	humm___ing
hummock	20	6	379	3	hummock___
hummocked	23	4	190	3	hummock_ed
hummocks	21	6	345	3	hummock__s
hummocky	24	7	199	3	hummock__y
humoring	14	5	685	3	hu_mo_ring
humouring	15	4	455	3	hu_mouring
mocking	16	36	1445	3	___mocking
outrocking	17	4	705	3	outrocking
smocking	17	34	910	3	__smocking
summoning	14	11	569	3	summo_ning
summonsing	15	4	309	3	summonsing
uncocking	18	3	623	3	_uncocking
undocking	17	3	565	3	_undocking
unlocking	16	3	607	3	_unlocking

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	140603	0.403	443402.0
2	DLD Change Limit	140603	21	5.296	26548.9
3	Display Results	21	21	0.016	1312.5
	(SQL Overall)	178691	21	5.715	31267.0