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

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

74 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
humbles	14	32	1580	(None)
bumbles	13	40	1684	1	bumbles
fumbles	14	35	1441	1	fumbles
humble	13	36	1505	1	humble_
humbled	15	37	1181	1	humbled
humbler	14	34	1194	1	humbler
humblers	15	37	980	1	humblers
humblest	15	28	828	1	humblest
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
bubbles	10	43	1596	2	bubbles
bumble	12	42	1689	2	bumble_
bumbled	14	41	1304	2	bumbled
bumbler	13	40	1323	2	bumbler
bumblers	14	37	1073	2	bumblers
burbles	11	49	1680	2	burbles
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
hobbles	14	33	1378	2	hobbles
hombres	14	36	987	2	hombres
hubbies	14	32	1156	2	hubbies
huckles	16	36	1262	2	huckles
huddles	12	37	1257	2	huddles
humates	12	28	1319	2	humates
humbly	16	40	1052	2	humbl_y
humbugs	15	3	424	2	humbugs
humpless	15	22	633	2	humpless
humuses	12	3	759	2	humuses
humvees	15	3	468	2	humvees
hurdles	11	36	1337	2	hurdles
hurtles	10	39	1375	2	hurtles
hustles	10	34	1417	2	hustles
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
shambles	15	15	904	2	shambles
stumbles	12	3	749	2	stumbles
thimbles	15	3	602	2	thimbles
thumbless	16	4	343	2	thumbless
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.390	458182.1
2	DLD Change Limit	107671	74	3.140	34290.1
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	3.563	50151.8