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

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

91 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
umbles	10	38	1749	(None)
ambles	10	51	2186	1	ambles
bumbles	13	40	1684	1	bumbles
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
umbels	10	45	1059	1	umbels
ables	7	59	3554	2	_ables
amble	9	59	2464	2	amble_
ambled	11	51	1637	2	ambled
ambler	10	49	1645	2	ambler
amblers	11	52	1356	2	amblers
amoles	8	41	2219	2	amoles
bibles	10	46	1764	2	bibles
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
cables	10	45	2755	2	cables
cobles	10	46	2288	2	cobles
crumbles	14	32	968	2	crumbles
drumbles	13	27	772	2	drumbles
emblem	12	3	758	2	emblem
emblems	13	3	504	2	emblems
fables	11	49	2167	2	fables
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
gables	9	42	2233	2	gables
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
imbues	10	3	798	2	imbues
jumble	17	40	1265	2	jumble_
jumbled	19	37	996	2	jumbled
jumbler	18	39	1027	2	jumbler
jumblers	19	35	832	2	jumblers
males	7	50	4979	2	_males
miles	7	46	4507	2	_miles
moles	7	47	4792	2	_moles
mules	7	50	3429	2	_mules
mumble	12	36	1434	2	mumble_
mumbled	14	30	1076	2	mumbled
mumbler	13	35	1091	2	mumbler
mumblers	14	32	876	2	mumblers
nobles	8	33	1972	2	nobles
nombles	11	32	1234	2	nombles
nubbles	11	34	1243	2	nubbles
ombres	10	39	1114	2	ombres
rambles	11	31	1831	2	rambles
robles	8	53	2169	2	robles
rubbles	11	37	1511	2	rubbles
rubles	8	39	2170	2	rubles
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
sables	8	50	2669	2	sables
scumbles	14	4	702	2	scumbles
smiles	8	45	2229	2	smiles
stumbles	12	3	749	2	stumbles
tables	8	45	2489	2	tables
tumble	10	32	1564	2	tumble_
tumbled	12	34	1224	2	tumbled
tumbler	11	34	1282	2	tumbler
tumblers	12	31	1062	2	tumblers
umbel	9	36	1284	2	umb_el
umbeled	12	20	819	2	umbeled
umber	9	46	1759	2	umb_er
umbers	10	42	1521	2	umbers
umbones	11	3	801	2	umbones
umbos	9	46	1307	2	umb_os
umbras	10	3	864	2	umbras
unbales	9	29	1486	2	unbales
unblest	9	4	1181	2	unblest
uncles	8	3	1716	2	uncles
wambles	14	37	1402	2	wambles
wimbles	14	30	1085	2	wimbles

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.346	516448.0
2	DLD Change Limit	82551	91	2.123	38884.1
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	2.499	71505.0