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

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

62 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
baubles	11	36	1186	(None)
babbles	10	44	1632	1	babbles
baubees	11	34	871	1	baubees
bauble	10	38	1321	1	bauble_
ables	7	59	3554	2	_a_bles
ambles	10	51	2186	2	_ambles
babble	9	40	1711	2	babble_
babbled	11	36	1286	2	babbled
babbler	10	40	1282	2	babbler
babblers	11	35	1035	2	babblers
babels	10	52	1672	2	ba_bels
babes	9	58	3411	2	ba_b_es
babies	10	61	2365	2	ba_bies
babuls	10	54	1364	2	babul_s
baffles	15	37	1068	2	baffles
bales	7	62	5008	2	ba__les
bangles	10	36	1741	2	bangles
barbels	11	45	1443	2	barbels
barbes	10	45	2623	2	barb_es
barbies	11	45	1959	2	barbies
barbless	12	31	871	2	barbless
barbules	12	3	804	2	barbules
battles	9	45	1768	2	battles
baubee	10	32	1599	2	baub_ee
baulks	12	42	937	2	bau_lks
bawbees	14	33	724	2	bawbees
bibles	10	46	1764	2	b_ibles
bobbles	10	45	1491	2	bobbles
boucles	11	31	1300	2	boucles
boules	8	49	2597	2	bou_les
boulles	9	31	1412	2	boulles
brabbles	11	34	975	2	brabbles
brambles	14	30	897	2	brambles
bubales	11	35	1334	2	b_ubales
bubbles	10	43	1596	2	bubbles
bubkes	14	46	1262	2	b_ubkes
buboes	10	45	1399	2	b_uboes
bugles	9	48	2244	2	b_ugles
bumbles	13	40	1684	2	bumbles
burbles	11	49	1680	2	burbles
butles	8	44	2391	2	b_utles
cables	10	45	2755	2	ca_bles
caudles	10	39	1281	2	caudles
caules	8	59	2725	2	cau_les
dabbles	12	45	1477	2	dabbles
daubes	9	49	1370	2	daub_es
doubles	10	31	1335	2	doubles
fables	11	49	2167	2	fa_bles
gabbles	12	44	1541	2	gabbles
gables	9	42	2233	2	ga_bles
gambles	12	40	1620	2	gambles
garbles	10	40	1692	2	garbles
marbles	11	45	1665	2	marbles
rabbles	11	35	1797	2	rabbles
rambles	11	31	1831	2	rambles
roubles	9	34	1351	2	roubles
rubles	8	39	2170	2	_rubles
sables	8	50	2669	2	sa_bles
tables	8	45	2489	2	ta_bles
wabbles	14	40	1399	2	wabbles
wambles	14	37	1402	2	wambles
warbles	12	32	1556	2	warbles

Search took 8 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	107671	0.750	238254.7
2	DLD Change Limit	107671	62	6.766	15913.5
3	Display Results	62	62	0.046	1347.8
	(SQL Overall)	178691	62	7.562	23630.1