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

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

89 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
rubbles	11	37	1511	(None)
bubbles	10	43	1596	1	bubbles
nubbles	11	34	1243	1	nubbles
rabbles	11	35	1797	1	rabbles
rubbies	11	41	1411	1	rubbies
rubble	10	43	1567	1	rubble_
rubbled	12	46	1162	1	rubbled
rubles	8	39	2170	1	ru_bles
rumbles	11	40	1839	1	rumbles
babbles	10	44	1632	2	babbles
bobbles	10	45	1491	2	bobbles
brabbles	11	34	975	2	brabbles
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
bumbles	13	40	1684	2	bumbles
burbles	11	49	1680	2	burbles
cobbles	13	38	1482	2	cobbles
crumbles	14	32	968	2	crumbles
cubbies	13	33	1288	2	cubbies
dabbles	12	45	1477	2	dabbles
dibbles	12	40	1333	2	dibbles
drabbles	13	30	852	2	drabbles
dribbles	13	34	839	2	dribbles
drumbles	13	27	772	2	drumbles
fribbles	15	28	771	2	fribbles
fumbles	14	35	1441	2	fumbles
gabbles	12	44	1541	2	gabbles
gobbles	12	35	1258	2	gobbles
grabbles	13	33	989	2	grabbles
gribbles	13	30	736	2	gribbles
grumbles	13	28	887	2	grumbles
hobbles	14	33	1378	2	hobbles
hubbies	14	32	1156	2	hubbies
humbles	14	32	1580	2	humbles
jubiles	16	28	937	2	jubiles
jumbles	18	30	1332	2	jumbles
kibbles	15	35	1025	2	kibbles
mumbles	13	30	1443	2	mumbles
nibbles	11	40	1169	2	nibbles
nobbles	11	40	1452	2	nobbles
nubble	10	38	1371	2	nubble_
numbles	11	38	1427	2	numbles
pebbles	13	3	757	2	pebbles
quibbles	21	3	422	2	quibbles
rabbies	11	34	1605	2	rabbies
rabble	10	38	1824	2	rabble_
rabbled	12	35	1442	2	rabbled
rabbler	11	35	1409	2	rabbler
rabblers	12	38	1085	2	rabblers
rambles	11	31	1831	2	rambles
rebbes	10	3	1353	2	rebb_es
robles	8	53	2169	2	r_obles
roubles	9	34	1351	2	roubles
rubaces	11	3	931	2	rubaces
rubbed	11	45	1508	2	rubb_ed
rubber	10	47	1579	2	rubb_er
rubbers	11	39	1319	2	rubbers
rubblier	12	4	491	2	rubblier
rubbliest	13	5	469	2	rubbliest
rubbly	13	37	1061	2	rubbl_y
rubels	8	41	1299	2	rubel_s
rubes	7	49	2841	2	ru_b_es
rubies	8	44	2034	2	ru_bies
ruble	7	45	2125	2	ru_ble_
ruckles	13	34	1460	2	ruckles
ruddles	9	28	1387	2	ruddles
ruffles	13	35	1227	2	ruffles
rugbies	10	33	935	2	rugbies
rules	5	52	3425	2	ru__les
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
rundles	8	32	1471	2	rundles
runkles	11	41	1194	2	runkles
rustles	7	34	1641	2	rustles
rutiles	7	43	1584	2	rutiles
stubbles	12	3	684	2	stubbles
tubules	9	3	1023	2	tubules
tumbles	11	38	1602	2	tumbles
umbles	10	38	1749	2	_umbles
wabbles	14	40	1399	2	wabbles
wobbles	14	34	1243	2	wobbles

Search took 6 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	89	5.346	20140.5
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	5.766	30990.5