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

Here are the results of your fuzzy-string dictionary search for “lumberly” with Change Limit: [1] [2] [3] [4]

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.

80 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
lumberly	15	4	468	(None)
limberly	15	4	446	1	limberly
lubberly	15	4	366	1	lubberly
lumber	10	38	1777	2	lumber__
lumbered	13	18	823	2	lumbered
lumberer	12	17	758	2	lumberer
lumbers	11	38	1591	2	lumber_s
plumbery	17	31	553	2	plumber_y
slumbery	15	29	604	2	slumber_y
somberly	15	4	405	2	somberly
summerly	15	27	510	2	summerly
ambery	13	38	1113	3	_amber_y
blubbery	14	29	478	3	blubber_y
blueberry	16	4	277	3	blueberry
clumber	13	40	1144	3	clumber__
clumbers	14	39	1041	3	clumber_s
cumber	12	40	1670	3	cumber__
cumbered	15	15	796	3	cumbered
cumberer	14	26	699	3	cumberer
cumbers	13	45	1541	3	cumber_s
dumber	11	44	1417	3	dumber__
dumbly	14	39	960	3	dumb__ly
flummery	18	3	305	3	flummer_y
humbly	16	40	1052	3	humb__ly
lambency	17	4	320	3	lambency
lambently	16	4	339	3	lambently
lamber	10	44	1849	3	lamber__
lambers	11	38	1711	3	lamber_s
lambert	11	36	1711	3	lamber_t
lamberts	12	34	879	3	lamberts
lamely	11	40	1322	3	lam_e_ly
latterly	11	3	606	3	latterly
lawyerly	17	4	214	3	lawyerly
liberty	12	3	716	3	l_iberty
limber	10	43	1679	3	limber__
limbered	13	15	812	3	limbered
limberer	12	18	705	3	limberer
limbers	11	36	1474	3	limber_s
loverly	13	4	697	3	l_overly
lubber	10	42	1462	3	lubber__
lubbers	11	39	1372	3	lubber_s
lumbar	10	36	1059	3	lumbar__
lumbars	11	28	976	3	lumbar_s
lumberers	13	19	601	3	lumberers
lumbering	14	11	793	3	lumbering
lumberman	15	4	278	3	lumberman
lumbermen	15	4	316	3	lumbermen
lumper	10	38	1665	3	lumper__
lumpers	11	35	1448	3	lumper_s
lumpily	14	7	656	3	lum_pily
mulberry	15	4	256	3	mulberry
mumbly	15	31	946	3	mumb__ly
mummery	13	33	666	3	mummer_y
number	10	39	1322	3	number__
numbered	13	14	714	3	numbered
numberer	12	18	631	3	numberer
numbers	11	37	1124	3	number_s
numbly	13	44	1066	3	numb__ly
plumber	13	33	998	3	plumber__
plumbers	14	41	851	3	plumber_s
puberty	14	4	478	3	pu_berty
queerly	19	3	423	3	qu_eerly
rubbery	14	33	759	3	rubber_y
rumbly	13	44	1216	3	rumb__ly
slumber	11	38	1100	3	slumber__
slumbered	14	21	559	3	slumbered
slumberer	13	19	480	3	slumberer
slumbers	12	31	1027	3	slumber_s
soberly	12	3	694	3	_soberly
sombrely	15	4	370	3	sombrely
summery	14	32	941	3	summer_y
timbery	14	25	689	3	timber_y
tumbrel	11	40	685	3	tumbrel_
tumbrels	12	28	573	3	tumbrels
umbel	9	36	1284	3	_umbe_l_
umbels	10	45	1059	3	_umbe_ls
umber	9	46	1759	3	_umber__
umbered	12	15	1011	3	_umbered
umbers	10	42	1521	3	_umber_s
utterly	10	3	544	3	_utterly

Search took 8 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	146162	0.453	394461.4
2	DLD Change Limit	146162	80	7.423	19690.4
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	7.906	22601.9