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

Here are the results of your fuzzy-string dictionary search for “drumly” 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
drumly	12	3	570	(None)
brumby	15	38	595	2	brumby
crumbly	16	34	752	2	crumbly
crumby	15	40	811	2	crumby
crummy	15	36	589	2	crummy
crumply	16	33	609	2	crumply
dimly	11	49	1348	2	d_imly
doubly	12	32	896	2	doubly
dourly	10	32	1043	2	dourly
drably	12	35	1161	2	drably
drawly	13	49	1072	2	drawly
drily	9	58	1652	2	dr_ily
drolly	10	54	1167	2	drolly
drooly	10	49	1107	2	drooly
druggy	12	34	474	2	druggy
drum	7	65	2159	2	drum__
drumble	12	33	789	2	drumble
drumlin	10	4	442	2	drumlin
drums	8	54	1587	2	drum_s
dryly	12	53	845	2	dr_yly
dully	9	49	2163	2	d_ully
duly	8	53	2303	2	d_u_ly
dumbly	14	39	960	2	d_umbly
dumky	15	45	1134	2	d_umky
dummy	13	47	1278	2	d_ummy
dumpy	13	54	1475	2	d_umpy
frumpy	16	46	688	2	frumpy
glumly	12	35	662	2	glumly
grimly	12	45	993	2	grimly
grumbly	15	35	540	2	grumbly
grumpy	14	49	815	2	grumpy
primly	13	43	962	2	primly
ruly	7	63	2314	2	_ru_ly
rumbly	13	44	1216	2	_rumbly
rummy	12	42	1241	2	_rummy
rumply	13	34	857	2	_rumply
trimly	11	44	1089	2	trimly
truly	8	41	1155	2	tru_ly

Search took 3 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	82551	0.360	496363.9
2	DLD Change Limit	82551	38	2.516	32810.4
3	Display Results	38	38	0.013	2923.1
	(SQL Overall)	178691	38	2.889	61852.2