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

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

78 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
bobble	9	41	1514	(None)
babble	9	40	1711	1	babble
bobbled	11	38	1183	1	bobbled
bobbles	10	45	1491	1	bobbles
bubble	9	40	1659	1	bubble
cobble	12	36	1526	1	cobble
gobble	11	35	1298	1	gobble
hobble	13	39	1343	1	hobble
nobble	10	38	1431	1	nobble
wobble	13	32	1231	1	wobble
abubble	10	4	452	2	abubble
babbled	11	36	1286	2	babbled
babbler	10	40	1282	2	babbler
babbles	10	44	1632	2	babbles
bauble	10	38	1321	2	bauble
bible	9	51	1942	2	b_ible
bobbed	10	43	1583	2	bobbed
bobber	9	50	1674	2	bobber
bobbies	10	37	1456	2	bobbies
bobbin	9	34	1073	2	bobbin
bobby	11	48	1466	2	bobb_y
bobsled	12	29	715	2	bobsled
boggle	10	45	1194	2	boggle
bogle	8	58	2168	2	bo_gle
bole	6	64	4869	2	bo__le
bombable	13	3	626	2	bombable
bombe	11	55	1931	2	bomb_e
bomblet	13	4	1226	2	bomblet
boobie	10	40	1529	2	boobie
boodle	9	32	1503	2	boodle
bottle	8	49	1607	2	bottle
boucle	10	37	1278	2	boucle
boule	7	48	2804	2	bo_ule
boulle	8	46	1461	2	boulle
brabble	10	34	997	2	brabble
bubale	10	40	1462	2	bubale
bubbled	11	36	1212	2	bubbled
bubbler	10	36	1178	2	bubbler
bubbles	10	43	1596	2	bubbles
bubbly	12	41	1035	2	bubbly
bumble	12	42	1689	2	bumble
burble	10	46	1770	2	burble
cobbled	14	34	1163	2	cobbled
cobbler	13	33	1182	2	cobbler
cobbles	13	38	1482	2	cobbles
coble	9	48	2317	2	co_ble
dabble	11	45	1519	2	dabble
dibble	11	40	1384	2	dibble
doable	9	31	1524	2	doable
double	9	40	1399	2	double
foible	11	4	1038	2	foible
gabble	11	38	1572	2	gabble
gobbled	13	40	1025	2	gobbled
gobbler	12	33	1002	2	gobbler
gobbles	12	35	1258	2	gobbles
hobbled	15	33	1078	2	hobbled
hobbler	14	37	1040	2	hobbler
hobbles	14	33	1378	2	hobbles
kibble	14	39	1095	2	kibble
lobule	8	29	1006	2	lobule
mobile	10	36	1354	2	mobile
nibble	10	37	1328	2	nibble
nobbled	12	35	1128	2	nobbled
nobbler	11	32	1118	2	nobbler
nobbles	11	40	1452	2	nobbles
noble	7	44	2099	2	no_ble
nubble	10	38	1371	2	nubble
obole	7	59	1714	2	_obole
pebble	12	3	800	2	pebble
rabble	10	38	1824	2	rabble
roble	7	52	2302	2	ro_ble
rouble	8	39	1331	2	rouble
rubble	10	43	1567	2	rubble
wabble	13	37	1484	2	wabble
wobbled	15	34	959	2	wobbled
wobbler	14	32	982	2	wobbler
wobbles	14	34	1243	2	wobbles
wobbly	16	34	709	2	wobbly

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.126	1418182.5
2	DLD Change Limit	82551	78	2.343	35233.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	2.499	71505.0