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

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

73 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
clamber	13	33	1174	(None)
camber	12	44	1848	1	c_amber
chamber	16	40	1106	1	chamber
clabber	13	42	1011	1	clabber
clambers	14	42	1129	1	clambers
clammer	13	42	1179	1	clammer
clamper	13	40	1299	1	clamper
climber	13	44	913	1	climber
clumber	13	40	1144	1	clumber
lamber	10	44	1849	1	_lamber
amber	9	45	2321	2	__amber
blabber	10	41	892	2	blabber
blamer	10	44	1714	2	blam_er
caber	9	51	2683	2	c_a_ber
caliber	11	3	973	2	caliber
calmer	10	52	1693	2	calm_er
cambers	13	40	1744	2	c_ambers
camper	12	47	2221	2	c_amper
chambers	17	34	1062	2	chambers
chamfer	17	39	986	2	chamfer
champer	16	38	1341	2	champer
clabbers	14	35	990	2	clabbers
clacker	15	38	1377	2	clacker
claimer	11	27	988	2	claimer
clambered	16	14	613	2	clambered
clamberer	15	18	527	2	clamberer
clammed	14	36	996	2	clammed
clammers	14	35	1069	2	clammers
clammier	14	3	584	2	clammier
clamor	10	4	945	2	clam_or
clamorer	12	3	690	2	clamorer
clamour	11	9	633	2	clamour
clamped	14	40	1204	2	clamped
clampers	14	32	1189	2	clampers
clanger	10	41	1349	2	clanger
clapper	13	40	1186	2	clapper
claquer	18	28	735	2	claquer
clasher	12	46	1551	2	clasher
clasper	11	38	1186	2	clasper
classer	9	36	1461	2	classer
clatter	9	40	1497	2	clatter
claver	11	38	1697	2	cla_ver
clavier	12	3	917	2	clavier
clawer	11	45	1278	2	cla_wer
clayier	12	4	832	2	clayier
climbed	14	33	698	2	climbed
climbers	14	31	841	2	climbers
clobber	13	37	816	2	clobber
clubber	13	31	959	2	clubber
clumbers	14	39	1041	2	clumbers
comber	12	51	1850	2	c_omber
crabber	13	38	1073	2	crabber
crambe	12	3	907	2	crambe_
crambes	13	3	996	2	crambes
crammer	13	40	1096	2	crammer
crumber	13	33	964	2	crumber
cumber	12	40	1670	2	c_umber
flambe	13	48	915	2	flambe_
flambee	14	42	1001	2	flambee
flambes	14	41	950	2	flambes
flamer	11	49	1912	2	flam_er
flamier	12	31	1214	2	flamier
lambed	11	56	1478	2	_lambed
lambers	11	38	1711	2	_lambers
lambert	11	36	1711	2	_lambert
lambier	11	36	1164	2	_lambier
lamer	7	52	3370	2	_lam_er
limber	10	43	1679	2	_limber
lumber	10	38	1777	2	_lumber
plumber	13	33	998	2	plumber
slabber	11	33	1139	2	slabber
slammer	11	39	1303	2	slammer
slumber	11	38	1100	2	slumber

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.143	1249587.4
2	DLD Change Limit	107671	73	3.576	30109.3
3	Display Results	73	73	0.016	4562.5
	(SQL Overall)	178691	73	3.735	47842.3