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

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

41 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
brambles	14	30	897	(None)
brabbles	11	34	975	1	brabbles
bramble	13	37	1003	1	bramble_
brambled	15	31	673	1	brambled
rambles	11	31	1831	1	_rambles
ambles	10	51	2186	2	__ambles
arables	9	18	1497	2	ara_bles
babbles	10	44	1632	2	b_abbles
baubles	11	36	1186	2	b_aubles
brabble	10	34	997	2	brabble_
brabbled	12	33	763	2	brabbled
brabbler	11	39	737	2	brabbler
brabblers	12	33	556	2	brabblers
brailles	10	3	949	2	brailles
bramblier	15	4	350	2	bramblier
brambliest	16	4	377	2	brambliest
brambly	16	29	625	2	brambl_y
brattles	10	19	933	2	brattles
brumbies	14	3	653	2	brumbies
bumbles	13	40	1684	2	b_umbles
crambes	13	3	996	2	cramb_es
cramboes	14	3	654	2	cramboes
crumbles	14	32	968	2	crumbles
drabbles	13	30	852	2	drabbles
drumbles	13	27	772	2	drumbles
gambles	12	40	1620	2	_gambles
grabbles	13	33	989	2	grabbles
grumbles	13	28	887	2	grumbles
preambles	15	4	533	2	preambles
rabbles	11	35	1797	2	_rabbles
ramblas	11	27	1026	2	_ramblas
ramble	10	45	1997	2	_ramble_
rambled	12	39	1352	2	_rambled
rambler	11	33	1326	2	_rambler
ramblers	12	40	1037	2	_ramblers
rumbles	11	40	1839	2	_rumbles
scrambles	15	14	638	2	scrambles
shambles	15	15	904	2	shambles
tramples	12	26	1020	2	tramples
trembles	12	3	735	2	trembles
wambles	14	37	1402	2	_wambles

Search took 4 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	41	3.296	36729.1
3	Display Results	41	41	0.016	2562.5
	(SQL Overall)	178691	41	3.702	48268.8