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

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

78 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
garbles	10	40	1692	(None)
gabbles	12	44	1541	1	gabbles
gables	9	42	2233	1	ga_bles
gambles	12	40	1620	1	gambles
garble	9	41	1845	1	garble_
garbled	11	45	1280	1	garbled
garbler	10	40	1256	1	garbler
garblers	11	38	1028	1	garblers
garbless	11	38	825	1	garbless
gargles	9	42	1489	1	gargles
marbles	11	45	1665	1	marbles
warbles	12	32	1556	1	warbles
ables	7	59	3554	2	_a_bles
ambles	10	51	2186	2	_ambles
arables	9	18	1497	2	_arables
argles	7	52	1848	2	_argles
arles	5	67	3574	2	_ar_les
babbles	10	44	1632	2	babbles
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
baubles	11	36	1186	2	baubles
burbles	11	49	1680	2	burbles
cables	10	45	2755	2	ca_bles
carles	8	54	3508	2	car_les
dabbles	12	45	1477	2	dabbles
darbies	10	42	1698	2	darbies
darkles	12	40	1193	2	darkles
dartles	8	40	1413	2	dartles
fables	11	49	2167	2	fa_bles
farles	9	60	2578	2	far_les
gabble	11	38	1572	2	gabble_
gabbled	13	41	1245	2	gabbled
gabbler	12	40	1330	2	gabbler
gabblers	13	41	1008	2	gabblers
gabies	9	38	2073	2	ga_bies
gable	8	53	2552	2	ga_ble_
gabled	10	55	1845	2	ga_bled
gaggles	10	35	1259	2	gaggles
gales	6	54	4248	2	ga__les
gambes	11	63	1831	2	gamb_es
gamble	11	54	1718	2	gamble_
gambled	13	41	1216	2	gambled
gambler	12	36	1268	2	gambler
gamblers	13	36	973	2	gamblers
garages	9	3	1411	2	garages
garbages	12	3	818	2	garbages
garbed	10	48	1566	2	garb_ed
garbs	8	63	2141	2	garb__s
gargle	8	42	1546	2	gargle_
gargled	10	42	1067	2	gargled
gargler	9	37	1026	2	gargler
garglers	10	41	826	2	garglers
garotes	8	6	1456	2	garotes
girdles	9	22	1000	2	girdles
gobbles	12	35	1258	2	gobbles
grabbles	13	33	989	2	grabbles
gurgles	9	43	1287	2	gurgles
marble	10	42	1910	2	marble_
marbled	12	32	1211	2	marbled
marbler	11	35	1167	2	marbler
marblers	12	31	923	2	marblers
parables	12	16	1356	2	parables
parles	8	63	3440	2	par_les
paroles	9	50	2588	2	paroles
rabbles	11	35	1797	2	rabbles
rambles	11	31	1831	2	rambles
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
warble	11	35	1660	2	warble_
warbled	13	32	1216	2	warbled
warbler	12	32	1146	2	warbler
warblers	13	31	910	2	warblers
warsles	10	34	1364	2	warsles

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	107671	0.376	475242.0
2	DLD Change Limit	107671	78	2.906	37051.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.312	53952.6