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

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

85 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
clamberer	15	18	527	(None)
clambered	16	14	613	1	clambered
clamberers	16	17	411	1	clamberers
cambered	15	12	900	2	c_ambered
chambered	19	14	599	2	chambered
chamferer	19	15	469	2	chamferer
clabbered	16	18	476	2	clabbered
clamber	13	33	1174	2	clamb__er
clambers	14	42	1129	2	clamber_s
clamorer	12	3	690	2	clam_orer
clatterer	11	18	698	2	clatterer
cumberer	14	26	699	2	c_umberer
limberer	12	18	705	2	_limberer
lumberer	12	17	758	2	_lumberer
slumberer	13	19	480	2	slumberer
ambeer	10	45	1160	3	__ambe_er
blabbered	13	18	459	3	blabbered
blatherer	14	17	671	3	blatherer
blubberer	12	17	345	3	blubberer
camber	12	44	1848	3	c_amb__er
cambers	13	40	1744	3	c_amber_s
caperer	11	30	1340	3	c_a_perer
careerer	10	3	858	3	c_areerer
caterer	9	28	1594	3	c_a_terer
chafferer	20	13	392	3	chafferer
chamber	16	40	1106	3	chamb__er
chambers	17	34	1062	3	chamber_s
chamfered	20	16	506	3	chamfered
chamferers	20	15	395	3	chamferers
charterer	14	19	732	3	charterer
chatterer	14	19	684	3	chatterer
clabber	13	42	1011	3	cla_b_ber
clabbers	14	35	990	3	clabber_s
clambake	18	4	389	3	clambake_
clambakes	19	4	331	3	clambakes
clambering	17	7	616	3	clambering
clammer	13	42	1179	3	clam__mer
clammers	14	35	1069	3	clammer_s
clammier	14	3	584	3	clam_mier
clamored	13	3	694	3	clam_ored
clamorers	13	4	578	3	clam_orers
clamoured	14	4	407	3	clamoured
clamper	13	40	1299	3	clam__per
clampers	14	32	1189	3	clamper_s
clattered	12	17	840	3	clattered
clatterers	12	15	542	3	clatterers
clavered	14	18	763	3	cla_vered
cleverer	13	3	456	3	cl_everer
climber	13	44	913	3	climb__er
climbers	14	31	841	3	climber_s
clobbered	16	16	410	3	clobbered
clumber	13	40	1144	3	clumb__er
clumbers	14	39	1041	3	clumber_s
cumbered	15	15	796	3	c_umbered
cumberers	15	17	600	3	c_umberers
flambee	14	42	1001	3	flambe_e_
flambeed	16	32	438	3	flambe_ed
flatterer	12	18	767	3	flatterer
hammerer	15	27	814	3	_hammerer
hamperer	15	37	909	3	_hamperer
jabberer	19	4	402	3	_jabberer
labeler	9	23	1018	3	_la_beler
laborer	9	24	950	3	_la_borer
lamber	10	44	1849	3	_lamb__er
lambers	11	38	1711	3	_lamber_s
lambert	11	36	1711	3	_lamber_t
lamberts	12	34	879	3	_lamberts
lambier	11	36	1164	3	_lamb_ier
latherer	11	13	1044	3	_latherer
limbered	13	15	812	3	_limbered
lumbered	13	18	823	3	_lumbered
lumberers	13	19	601	3	_lumberers
numberer	12	18	631	3	_numberer
pamperer	14	22	833	3	_pamperer
plasterer	11	7	810	3	plasterer
scamperer	15	4	462	3	scamperer
slabbered	14	16	508	3	slabbered
slanderer	10	4	667	3	slanderer
slaverer	11	19	699	3	sla_verer
slobberer	13	15	344	3	slobberer
slumbered	14	21	559	3	slumbered
slumberers	14	20	368	3	slumberers
stammerer	13	4	406	3	stammerer
tamperer	12	24	889	3	_tamperer
yammerer	15	22	548	3	_yammerer

Search took 7 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	148641	0.436	409841.7
2	DLD Change Limit	148641	85	6.280	23668.9
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	6.749	26476.7