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

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

86 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
gabbled	13	41	1245	(None)
babbled	11	36	1286	1	babbled
dabbled	13	37	1207	1	dabbled
gabbed	12	52	1689	1	gabb_ed
gabble	11	38	1572	1	gabble_
gabbler	12	40	1330	1	gabbler
gabbles	12	44	1541	1	gabbles
gabled	10	55	1845	1	ga_bled
gambled	13	41	1216	1	gambled
garbled	11	45	1280	1	garbled
gobbled	13	40	1025	1	gobbled
grabbled	14	32	737	1	grabbled
rabbled	12	35	1442	1	rabbled
wabbled	15	33	1144	1	wabbled
abled	8	69	2683	2	_a_bled
ambled	11	51	1637	2	_ambled
babble	9	40	1711	2	babble_
babbler	10	40	1282	2	babbler
babbles	10	44	1632	2	babbles
bobbled	11	38	1183	2	bobbled
brabbled	12	33	763	2	brabbled
bubbled	11	36	1212	2	bubbled
cabbed	13	54	1626	2	cabb_ed
cabled	11	48	1987	2	ca_bled
cobbled	14	34	1163	2	cobbled
dabbed	12	44	1614	2	dabb_ed
dabble	11	45	1519	2	dabble_
dabbler	12	40	1215	2	dabbler
dabbles	12	45	1477	2	dabbles
dibbled	13	35	1084	2	dibbled
drabbled	14	36	705	2	drabbled
fabled	12	42	1638	2	fa_bled
gabbard	13	3	655	2	gabbard
gabber	11	49	1660	2	gabb_er
gabbier	12	37	963	2	gabbier
gabblers	13	41	1008	2	gabblers
gabelled	12	31	758	2	gabelled
gable	8	53	2552	2	ga_ble_
gables	9	42	2233	2	ga_bles
gaggled	11	35	991	2	gaggled
galled	8	46	2286	2	ga_lled
gamble	11	54	1718	2	gamble_
gambler	12	36	1268	2	gambler
gambles	12	40	1620	2	gambles
gamboled	14	3	587	2	gamboled
gaoled	8	48	1450	2	ga_oled
garbed	10	48	1566	2	garb_ed
garble	9	41	1845	2	garble_
garbler	10	40	1256	2	garbler
garbles	10	40	1692	2	garbles
gargled	10	42	1067	2	gargled
gaveled	12	39	913	2	gaveled
gibbed	12	45	1235	2	gibb_ed
gobbed	12	46	1388	2	gobb_ed
gobble	11	35	1298	2	gobble_
gobbler	12	33	1002	2	gobbler
gobbles	12	35	1258	2	gobbles
grabbed	13	36	864	2	grabb_ed
grabble	12	33	964	2	grabble_
grabbler	13	37	769	2	grabbler
grabbles	13	33	989	2	grabbles
hobbled	15	33	1078	2	hobbled
jabbed	18	42	1348	2	jabb_ed
kibbled	16	36	798	2	kibbled
labeled	10	25	1056	2	labeled
marbled	12	32	1211	2	marbled
nabbed	11	51	1361	2	nabb_ed
nibbled	12	38	907	2	nibbled
nobbled	12	35	1128	2	nobbled
pebbled	14	4	540	2	pebbled
rabble	10	38	1824	2	rabble_
rabbler	11	35	1409	2	rabbler
rabbles	11	35	1797	2	rabbles
rambled	12	39	1352	2	rambled
rubbled	12	46	1162	2	rubbled
sabbed	11	45	1808	2	sabb_ed
scabbled	15	15	630	2	scabbled
tabbed	11	42	1536	2	tabb_ed
tabbied	12	29	779	2	tabbied
tabled	9	40	2004	2	ta_bled
wabble	13	37	1484	2	wabble_
wabbler	14	35	1192	2	wabbler
wabbles	14	40	1399	2	wabbles
wambled	15	36	1075	2	wambled
warbled	13	32	1216	2	warbled
wobbled	15	34	959	2	wobbled

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	86	3.233	33303.7
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	3.642	49064.0