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

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

93 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
bumbles	13	40	1684	(None)
bubbles	10	43	1596	1	bubbles
bumble	12	42	1689	1	bumble_
bumbled	14	41	1304	1	bumbled
bumbler	13	40	1323	1	bumbler
bumblers	14	37	1073	1	bumblers
burbles	11	49	1680	1	burbles
fumbles	14	35	1441	1	fumbles
humbles	14	32	1580	1	humbles
jumbles	18	30	1332	1	jumbles
mumbles	13	30	1443	1	mumbles
numbles	11	38	1427	1	numbles
rumbles	11	40	1839	1	rumbles
tumbles	11	38	1602	1	tumbles
umbles	10	38	1749	1	_umbles
ambles	10	51	2186	2	_ambles
babbles	10	44	1632	2	babbles
baubles	11	36	1186	2	baubles
bejumbles	22	12	244	2	bejumbles
bibles	10	46	1764	2	b_ibles
bimboes	13	49	873	2	bimboes
bobbles	10	45	1491	2	bobbles
bombes	12	49	1682	2	bomb_es
bomblet	13	4	1226	2	bomblet
bomblets	14	3	602	2	bomblets
brambles	14	30	897	2	brambles
brumbies	14	3	653	2	brumbies
bubales	11	35	1334	2	bubales
bubbies	10	39	1351	2	bubbies
bubble	9	40	1659	2	bubble_
bubbled	11	36	1212	2	bubbled
bubbler	10	36	1178	2	bubbler
bubblers	11	44	894	2	bubblers
bubblies	11	6	677	2	bubblies
bubkes	14	46	1262	2	bu_bkes
buboes	10	45	1399	2	bu_boes
buckles	15	34	1609	2	buckles
buddles	11	39	1307	2	buddles
bugles	9	48	2244	2	bu_gles
bulbels	11	39	801	2	bulbels
bulblet	11	3	1121	2	bulblet
bulblets	12	5	535	2	bulblets
bundles	10	35	1577	2	bundles
bungles	10	41	1676	2	bungles
burble	10	46	1770	2	burble_
burbled	12	43	1267	2	burbled
burbler	11	44	1242	2	burbler
burblers	12	39	926	2	burblers
burgles	10	56	1596	2	burgles
busbies	11	30	1169	2	busbies
bustles	9	38	1632	2	bustles
butles	8	44	2391	2	bu_tles
crumbles	14	32	968	2	crumbles
drumbles	13	27	772	2	drumbles
fimbles	14	35	1066	2	fimbles
fumble	13	32	1426	2	fumble_
fumbled	15	37	1049	2	fumbled
fumbler	14	36	1081	2	fumbler
fumblers	15	31	871	2	fumblers
gambles	12	40	1620	2	gambles
grumbles	13	28	887	2	grumbles
humble	13	36	1505	2	humble_
humbled	15	37	1181	2	humbled
humbler	14	34	1194	2	humbler
humblers	15	37	980	2	humblers
humblest	15	28	828	2	humblest
jumble	17	40	1265	2	jumble_
jumbled	19	37	996	2	jumbled
jumbler	18	39	1027	2	jumbler
jumblers	19	35	832	2	jumblers
mumble	12	36	1434	2	mumble_
mumbled	14	30	1076	2	mumbled
mumbler	13	35	1091	2	mumbler
mumblers	14	32	876	2	mumblers
nombles	11	32	1234	2	nombles
nubbles	11	34	1243	2	nubbles
rambles	11	31	1831	2	rambles
rubbles	11	37	1511	2	rubbles
rubles	8	39	2170	2	ru_bles
rumble	10	37	1881	2	rumble_
rumbled	12	45	1459	2	rumbled
rumbler	11	35	1411	2	rumbler
rumblers	12	36	1074	2	rumblers
rumples	11	33	1313	2	rumples
scumbles	14	4	702	2	scumbles
stumbles	12	3	749	2	stumbles
tumble	10	32	1564	2	tumble_
tumbled	12	34	1224	2	tumbled
tumbler	11	34	1282	2	tumbler
tumblers	12	31	1062	2	tumblers
umbels	10	45	1059	2	_umbels
wambles	14	37	1402	2	wambles
wimbles	14	30	1085	2	wimbles

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.143	1249587.4
2	DLD Change Limit	107671	93	3.733	28843.0
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	3.906	45747.8