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

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

72 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
rambler	11	33	1326	(None)
ambler	10	49	1645	1	_ambler
gambler	12	36	1268	1	gambler
rabbler	11	35	1409	1	rabbler
ramble	10	45	1997	1	ramble_
rambled	12	39	1352	1	rambled
ramblers	12	40	1037	1	ramblers
rambles	11	31	1831	1	rambles
rumbler	11	35	1411	1	rumbler
abler	7	56	2431	2	_a_bler
ambeer	10	45	1160	2	_ambeer
amber	9	45	2321	2	_amb_er
amble	9	59	2464	2	_amble_
ambled	11	51	1637	2	_ambled
amblers	11	52	1356	2	_amblers
ambles	10	51	2186	2	_ambles
ampler	10	43	1330	2	_ampler
babbler	10	40	1282	2	babbler
brabbler	11	39	737	2	brabbler
bramble	13	37	1003	2	bramble_
brambled	15	31	673	2	brambled
brambles	14	30	897	2	brambles
bramblier	15	4	350	2	bramblier
bumbler	13	40	1323	2	bumbler
cabler	10	45	1917	2	ca_bler
camber	12	44	1848	2	camb_er
dabbler	12	40	1215	2	dabbler
fabler	11	61	1581	2	fa_bler
fumbler	14	36	1081	2	fumbler
gabbler	12	40	1330	2	gabbler
gambier	12	47	1197	2	gambier
gamble	11	54	1718	2	gamble_
gambled	13	41	1216	2	gambled
gamblers	13	36	973	2	gamblers
gambles	12	40	1620	2	gambles
garbler	10	40	1256	2	garbler
grabbler	13	37	769	2	grabbler
grumbler	13	86	668	2	grumbler
humbler	14	34	1194	2	humbler
jumbler	18	39	1027	2	jumbler
lamber	10	44	1849	2	lamb_er
lambier	11	36	1164	2	lambier
marbler	11	35	1167	2	marbler
mumbler	13	35	1091	2	mumbler
nimbler	11	35	806	2	nimbler
rabble	10	38	1824	2	rabble_
rabbled	12	35	1442	2	rabbled
rabblers	12	38	1085	2	rabblers
rabbles	11	35	1797	2	rabbles
raffler	13	33	922	2	raffler
railer	6	45	2493	2	ra_iler
rambla	10	35	1093	2	rambl_a
ramblas	11	27	1026	2	ramblas
rammer	10	35	1965	2	ram_mer
rammier	11	28	1102	2	rammier
rattler	7	40	1274	2	rattler
raveler	10	42	1246	2	raveler
rumble	10	37	1881	2	rumble_
rumbled	12	45	1459	2	rumbled
rumblers	12	36	1074	2	rumblers
rumbles	11	40	1839	2	rumbles
sampler	11	32	1201	2	sampler
scrambler	15	16	504	2	scrambler
trampler	12	27	801	2	trampler
trembler	12	3	536	2	trembler
tumbler	11	34	1282	2	tumbler
wabbler	14	35	1192	2	wabbler
wamble	13	44	1575	2	wamble_
wambled	15	36	1075	2	wambled
wambles	14	37	1402	2	wambles
wamblier	15	27	573	2	wamblier
warbler	12	32	1146	2	warbler

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.360	496363.9
2	DLD Change Limit	107671	72	3.516	30623.2
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.906	45747.8