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

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

60 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
clumber	13	40	1144	(None)
clamber	13	33	1173	1	clamber
climber	13	44	913	1	climber
clubber	13	31	959	1	clubber
clumbers	14	39	1040	1	clumbers
crumber	13	33	964	1	crumber
cumber	12	40	1670	1	c_umber
lumber	10	38	1777	1	_lumber
plumber	13	33	998	1	plumber
slumber	11	38	1100	1	slumber
blubber	10	39	929	2	blubber
camber	12	44	1847	2	c_amber
chamber	16	40	1105	2	chamber
clabber	13	42	1011	2	clabber
clambers	14	42	1128	2	clambers
clammer	13	42	1179	2	clammer
clamper	13	40	1299	2	clamper
climbed	14	33	698	2	climbed
climbers	14	31	840	2	climbers
clobber	13	37	816	2	clobber
clubbed	14	30	745	2	clubbed
clubbers	14	37	858	2	clubbers
clubbier	14	3	483	2	clubbier
clubmen	13	3	425	2	clubmen
clumped	14	36	1066	2	clumped
clumpier	14	3	558	2	clumpier
clumsier	12	3	473	2	clumsier
clunker	13	41	945	2	clunker
cluster	9	40	1333	2	cluster
clutter	9	42	1166	2	clutter
comber	12	51	1850	2	c_omber
crumbed	14	37	847	2	crumbed
crumbers	14	33	823	2	crumbers
crumbier	14	5	636	2	crumbier
cuber	9	52	2253	2	c_u_ber
cucumber	16	4	260	2	cucumber
cumbers	13	45	1540	2	c_umbers
cummer	12	44	1459	2	c_ummer
curber	10	45	1705	2	c_urber
dumber	11	44	1417	2	_dumber
flubber	14	28	771	2	flubber
glummer	12	41	798	2	glummer
lamber	10	44	1849	2	_lamber
limber	10	43	1679	2	_limber
lubber	10	42	1462	2	_lubber
lumbar	10	36	1059	2	_lumbar
lumbers	11	38	1591	2	_lumbers
lumper	10	38	1665	2	_lumper
number	10	39	1322	2	_number
plumbed	14	31	727	2	plumbed
plumbers	14	41	851	2	plumbers
plumbery	17	31	553	2	plumbery
plumier	11	35	1004	2	plumier
plummer	13	29	852	2	plummer
plumper	13	31	877	2	plumper
slubber	11	30	1076	2	slubber
slumbers	12	31	1027	2	slumbers
slumbery	15	29	604	2	slumbery
slummer	11	37	1120	2	slummer
umber	9	46	1759	2	__umber

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.140	1276364.3
2	DLD Change Limit	107671	60	3.686	29210.8
3	Display Results	60	60	0.016	3750.0
	(SQL Overall)	178691	60	3.842	46509.9