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

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

79 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
rambled	12	39	1352	(None)
ambled	11	51	1637	1	_ambled
brambled	15	31	673	1	brambled
gambled	13	41	1216	1	gambled
rabbled	12	35	1442	1	rabbled
ramble	10	45	1997	1	ramble_
rambler	11	33	1326	1	rambler
rambles	11	31	1831	1	rambles
rumbled	12	45	1459	1	rumbled
wambled	15	36	1075	1	wambled
abled	8	69	2683	2	_a_bled
amble	9	59	2464	2	_amble_
ambler	10	49	1645	2	_ambler
ambles	10	51	2186	2	_ambles
babbled	11	36	1286	2	babbled
brabbled	12	33	763	2	brabbled
bramble	13	37	1003	2	bramble_
brambles	14	30	897	2	brambles
bumbled	14	41	1304	2	bumbled
cabled	11	48	1987	2	ca_bled
crumbled	15	35	744	2	crumbled
dabbled	13	37	1207	2	dabbled
drabbled	14	36	705	2	drabbled
drumbled	14	26	603	2	drumbled
fabled	12	42	1638	2	fa_bled
fumbled	15	37	1049	2	fumbled
gabbled	13	41	1245	2	gabbled
gabled	10	55	1845	2	ga_bled
gamble	11	54	1718	2	gamble_
gambler	12	36	1268	2	gambler
gambles	12	40	1620	2	gambles
gamboled	14	3	587	2	gamboled
garbled	11	45	1280	2	garbled
grabbled	14	32	737	2	grabbled
grumbled	14	25	675	2	grumbled
humbled	15	37	1181	2	humbled
jambed	18	48	1140	2	jamb_ed
jumbled	19	37	996	2	jumbled
lambed	11	56	1478	2	lamb_ed
mamboed	14	41	762	2	mamboed
marbled	12	32	1211	2	marbled
mumbled	14	30	1076	2	mumbled
preambled	16	4	389	2	preambled
rabble	10	38	1824	2	rabble_
rabbler	11	35	1409	2	rabbler
rabbles	11	35	1797	2	rabbles
raddled	10	38	1222	2	raddled
raffled	14	42	908	2	raffled
railed	7	47	2754	2	ra_iled
rambla	10	35	1093	2	rambl_a
ramblas	11	27	1026	2	ramblas
ramblers	12	40	1037	2	ramblers
rammed	11	31	1730	2	ram_med
ramped	11	46	1790	2	ram_ped
rankled	12	39	1065	2	rankled
rassled	8	33	1045	2	rassled
rattled	8	40	1295	2	rattled
raveled	11	41	1363	2	raveled
rimpled	12	33	1142	2	rimpled
rubbled	12	46	1162	2	rubbled
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
sambaed	12	3	830	2	sambaed
sampled	12	34	1079	2	sampled
scrambled	16	16	481	2	scrambled
shambled	16	15	615	2	shambled
tabled	9	40	2004	2	ta_bled
trameled	11	30	907	2	trameled
trampled	13	24	790	2	trampled
trembled	13	3	525	2	trembled
tumbled	12	34	1224	2	tumbled
wabbled	15	33	1144	2	wabbled
wamble	13	44	1575	2	wamble_
wambles	14	37	1402	2	wambles
warbled	13	32	1216	2	warbled
wimbled	15	29	815	2	wimbled

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.436	409841.7
2	DLD Change Limit	107671	79	3.003	35854.5
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	3.469	51510.8