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

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

75 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
rubbled	12	46	1162	(None)
bubbled	11	36	1212	1	bubbled
rabbled	12	35	1442	1	rabbled
rubbed	11	45	1508	1	rubb_ed
rubble	10	43	1567	1	rubble_
rubbles	11	37	1511	1	rubbles
rumbled	12	45	1459	1	rumbled
babbled	11	36	1286	2	babbled
bobbled	11	38	1183	2	bobbled
brabbled	12	33	763	2	brabbled
bubble	9	40	1659	2	bubble_
bubbler	10	36	1178	2	bubbler
bubbles	10	43	1596	2	bubbles
bumbled	14	41	1304	2	bumbled
burbled	12	43	1267	2	burbled
cobbled	14	34	1163	2	cobbled
cribbled	15	30	580	2	cribbled
crumbled	15	35	744	2	crumbled
dabbled	13	37	1207	2	dabbled
dibbled	13	35	1084	2	dibbled
drabbled	14	36	705	2	drabbled
dribbled	14	37	659	2	dribbled
drubbed	13	40	698	2	drubb_ed
drumbled	14	26	603	2	drumbled
dubbed	12	41	1321	2	dubb_ed
fribbled	16	30	574	2	fribbled
fubbed	14	47	1124	2	fubb_ed
fumbled	15	37	1049	2	fumbled
gabbled	13	41	1245	2	gabbled
gobbled	13	40	1025	2	gobbled
grabbled	14	32	737	2	grabbled
grubbed	13	40	643	2	grubb_ed
grumbled	14	25	675	2	grumbled
hobbled	15	33	1078	2	hobbled
humbled	15	37	1181	2	humbled
jumbled	19	37	996	2	jumbled
kibbled	16	36	798	2	kibbled
mumbled	14	30	1076	2	mumbled
nibbled	12	38	907	2	nibbled
nobbled	12	35	1128	2	nobbled
nubble	10	38	1371	2	nubble_
nubbles	11	34	1243	2	nubbles
pebbled	14	4	540	2	pebbled
quibbled	22	3	272	2	quibbled
rabble	10	38	1824	2	rabble_
rabbler	11	35	1409	2	rabbler
rabbles	11	35	1797	2	rabbles
rambled	12	39	1352	2	rambled
ribbed	11	40	1437	2	ribb_ed
robbed	11	34	1519	2	robb_ed
rubber	10	47	1579	2	rubb_er
rubbered	13	3	538	2	rubbered
rubbies	11	41	1411	2	rubbies
rubblier	12	4	491	2	rubblier
rubbly	13	37	1061	2	rubbl_y
rubied	9	43	1241	2	ru_bied
ruble	7	45	2125	2	ru_ble_
rubles	8	39	2170	2	ru_bles
ruckled	14	41	1103	2	ruckled
ruddled	10	30	1087	2	ruddled
ruffled	14	36	915	2	ruffled
ruled	6	58	2252	2	ru__led
rumbaed	12	28	749	2	rumbaed
rumble	10	37	1881	2	rumble_
rumbler	11	35	1411	2	rumbler
rumbles	11	40	1839	2	rumbles
rumpled	12	38	1001	2	rumpled
runkled	12	39	901	2	runkled
rustled	8	33	1132	2	rustled
stubbled	13	8	507	2	stubbled
subbed	11	41	1667	2	subb_ed
tubbed	11	47	1222	2	tubb_ed
tumbled	12	34	1224	2	tumbled
wabbled	15	33	1144	2	wabbled
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	75	3.310	32529.0
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	3.719	48048.1