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

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

77 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
beclasps	14	4	435	(None)
beclasp	13	3	526	1	beclasp_
reclasps	12	3	505	1	reclasps
becaps	12	38	1140	2	bec_a_ps
beclasped	16	4	374	2	beclasped
bedlamps	15	4	366	2	bedlamps
clasps	10	45	1209	2	__clasps
declass	10	3	873	2	declas_s
enclasps	12	4	513	2	enclasps
inclasps	12	4	435	2	inclasps
reclasp	11	3	664	2	reclasp_
tieclasps	13	4	221	2	tieclasps
unclasps	12	4	457	2	unclasps
balases	9	38	1543	3	b_alases
ballasts	10	3	793	3	ballasts
beasts	8	45	1972	3	be__asts
becalms	13	3	574	3	bec_alms
becap	11	43	1505	3	bec_a_p_
bechalks	19	4	479	3	bechalks
becharms	17	4	534	3	becharms
beclamor	14	8	430	3	beclamor
beclamors	15	7	422	3	beclamors
beclasping	17	13	407	3	beclasping
becloaks	16	4	493	3	becloaks
beclogs	12	3	707	3	becl_ogs
beclouds	13	4	537	3	beclouds
beclowns	15	4	468	3	beclowns
becrawls	15	4	362	3	becrawls
becrusts	12	4	484	3	becrusts
becurses	12	3	672	3	becurses
bedlamp	14	6	451	3	bedlamp_
bedlams	12	3	705	3	bedla_ms
bedless	10	3	970	3	bedles_s
beflags	13	5	549	3	befla_gs
beglads	11	12	726	3	begla_ds
belauds	10	3	664	3	be_lauds
belays	11	43	1385	3	be_la_ys
beleaps	11	3	805	3	be_leaps
bellhops	15	4	487	3	bellhops
bewraps	14	13	540	3	bewra_ps
blasts	8	51	1677	3	b__lasts
bolases	9	33	1500	3	b_olases
burlaps	11	5	625	3	burla_ps
clamps	12	45	1508	3	__clamps
claps	9	56	2618	3	__cla_ps
clasp	9	55	1719	3	__clasp_
claspt	10	45	1341	3	__claspt
class	7	55	2548	3	__clas_s
clasts	8	48	1729	3	__clasts
cyclases	15	3	713	3	cyclases
decamps	14	3	564	3	dec_amps
deceases	11	4	1015	3	deceases
declaims	13	4	582	3	declaims
declares	11	6	1131	3	declares
declasse	11	6	594	3	declasse
declasses	12	4	644	3	declasses
declaws	13	3	625	3	decla_ws
dewlaps	13	3	466	3	dewla_ps
eclairs	9	3	596	3	_eclairs
eclats	8	3	1303	3	_ecla_ts
ectases	9	29	1167	3	_ectases
ectasis	9	24	961	3	_ectasis
enclasp	11	4	584	3	enclasp_
euclases	10	3	922	3	euclases
gelcaps	12	3	520	3	gelca_ps
inclasp	11	4	530	3	inclasp_
pectases	12	24	1119	3	pectases
recaps	10	36	1573	3	rec_a_ps
recasts	9	34	1353	3	rec_asts
reclads	10	4	999	3	recla_ds
reclaims	12	3	611	3	reclaims
reclames	12	3	1089	3	reclames
reclasped	14	4	486	3	reclasped
recluses	10	51	1173	3	recluses
tieclasp	12	4	280	3	tieclasp_
unclamps	14	4	369	3	unclamps
unclasp	11	3	596	3	unclasp_

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.156	1145455.1
2	DLD Change Limit	146162	77	7.703	18974.7
3	Display Results	77	77	0.016	4812.5
	(SQL Overall)	178691	77	7.875	22690.9