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

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

84 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
gabble	11	38	1572	(None)
babble	9	40	1711	1	babble
dabble	11	45	1519	1	dabble
gabbled	13	41	1245	1	gabbled
gabbler	12	40	1330	1	gabbler
gabbles	12	44	1541	1	gabbles
gable	8	53	2552	1	ga_ble
gamble	11	54	1718	1	gamble
garble	9	41	1845	1	garble
gobble	11	35	1298	1	gobble
grabble	12	33	964	1	grabble
rabble	10	38	1824	1	rabble
wabble	13	37	1484	1	wabble
abbe	8	76	2718	2	_abb_e
abele	7	63	2325	2	_abele
able	6	63	4053	2	_a_ble
amble	9	59	2463	2	_amble
babbled	11	36	1286	2	babbled
babbler	10	40	1282	2	babbler
babbles	10	44	1632	2	babbles
bauble	10	38	1321	2	bauble
bobble	9	41	1514	2	bobble
brabble	10	34	997	2	brabble
bubble	9	40	1659	2	bubble
cabbie	12	29	1334	2	cabbie
cable	9	53	2991	2	ca_ble
cobble	12	36	1526	2	cobble
dabbled	13	37	1207	2	dabbled
dabbler	12	40	1215	2	dabbler
dabbles	12	45	1477	2	dabbles
dibble	11	40	1384	2	dibble
drabble	12	23	888	2	drabble
fable	10	58	2475	2	fa_ble
gabbed	12	52	1689	2	gabbed
gabber	11	49	1660	2	gabber
gabbier	12	37	963	2	gabbier
gabblers	13	41	1008	2	gabblers
gabbro	11	11	495	2	gabbro
gabby	13	55	1294	2	gabb_y
gabelle	10	25	921	2	gabelle
gabled	10	55	1845	2	ga_bled
gables	9	42	2233	2	ga_bles
gaggle	9	34	1262	2	gaggle
gale	5	63	4732	2	ga__le
gambe	10	62	1921	2	gamb_e
gambled	13	41	1216	2	gambled
gambler	12	36	1268	2	gambler
gambles	12	40	1620	2	gambles
garbled	11	45	1280	2	garbled
garbler	10	40	1256	2	garbler
garbles	10	40	1692	2	garbles
gargle	8	42	1546	2	gargle
gobbled	13	40	1025	2	gobbled
gobbler	12	33	1002	2	gobbler
gobbles	12	35	1258	2	gobbles
grabbled	14	32	737	2	grabbled
grabbler	13	37	769	2	grabbler
grabbles	13	33	989	2	grabbles
gribble	12	29	727	2	gribble
habile	11	5	1520	2	habile
hobble	13	39	1343	2	hobble
kibble	14	39	1095	2	kibble
labile	8	3	1521	2	labile
marble	10	42	1910	2	marble
nibble	10	37	1328	2	nibble
nobble	10	38	1431	2	nobble
nubble	10	38	1371	2	nubble
pebble	12	3	800	2	pebble
rabbled	12	35	1442	2	rabbled
rabbler	11	35	1409	2	rabbler
rabbles	11	35	1797	2	rabbles
ramble	10	45	1997	2	ramble
rubble	10	43	1567	2	rubble
sable	7	47	3216	2	sa_ble
scabble	13	16	865	2	scabble
table	7	54	2960	2	ta_ble
wabbled	15	33	1144	2	wabbled
wabbler	14	35	1192	2	wabbler
wabbles	14	40	1399	2	wabbles
wabbly	16	34	836	2	wabbly
wamble	13	44	1575	2	wamble
warble	11	35	1660	2	warble
wobble	13	32	1231	2	wobble
yabbie	13	30	865	2	yabbie

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.110	1624463.6
2	DLD Change Limit	82551	84	2.796	29524.7
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	2.936	60862.1