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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

108 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
clapt	9	80	2717	(None)
chapt	12	58	2764	1	chapt
clap	8	64	2904	1	clap_
claps	9	56	2618	1	claps
claspt	10	45	1341	1	claspt
clast	7	60	3058	1	clast
clept	9	57	2577	1	clept
clipt	9	63	2427	1	clipt
coapt	9	61	3152	1	coapt
adapt	8	12	1855	2	adapt
alant	5	57	4229	2	alant
apt	5	73	5254	2	__apt
blast	7	65	3257	2	blast
blat	6	65	5095	2	bla_t
cant	6	63	6202	2	c_ant
cap	7	67	5898	2	c_ap_
cape	8	72	4278	2	c_ape
caph	11	66	2329	2	c_aph
capo	8	58	2921	2	c_apo
caps	8	71	4789	2	c_aps
caput	9	8	2397	2	c_aput
cart	6	65	7034	2	c_art
cast	6	71	5990	2	c_ast
cat	5	82	8234	2	c_a_t
chant	10	59	3269	2	chant
chap	11	49	2849	2	chap_
chape	12	52	2114	2	chape
chaps	12	53	2606	2	chaps
chart	10	50	3828	2	chart
chat	9	55	4613	2	cha_t
clach	12	46	1782	2	clach
clack	13	47	2017	2	clack
clad	7	62	2582	2	cla_d
clade	8	58	2101	2	clade
clads	8	57	2273	2	clads
clag	7	59	2457	2	cla_g
clags	8	56	2112	2	clags
claim	9	56	1691	2	claim
clam	8	63	3229	2	cla_m
clamp	11	55	1765	2	clamp
clamps	12	45	1508	2	clamps
clams	9	51	2767	2	clams
clan	6	56	3392	2	cla_n
clang	8	60	1931	2	clang
clank	11	47	1952	2	clank
clans	7	50	3101	2	clans
claret	8	40	2657	2	claret
claro	7	50	1869	2	claro
clary	10	57	1961	2	clary
clash	10	62	1903	2	clash
clasp	9	55	1719	2	clasp
clasps	10	45	1209	2	clasps
class	7	55	2548	2	class
clasts	8	48	1729	2	clasts
clave	10	54	2015	2	clave
clavi	10	49	1292	2	clavi
claw	9	56	2434	2	cla_w
claws	10	60	2083	2	claws
clay	9	59	2741	2	cla_y
clays	10	55	2133	2	clays
cleat	7	63	3506	2	cleat
cleft	10	62	2285	2	cleft
clepe	9	46	1738	2	clepe
clift	10	64	2219	2	clift
clip	8	69	2400	2	clip_
clips	9	60	1830	2	clips
cloot	7	61	2705	2	cloot
clop	8	69	2989	2	clop_
clops	9	59	2485	2	clops
clot	6	65	4242	2	cl_ot
clout	7	53	3046	2	clout
coact	9	61	3057	2	coact
coapts	10	46	1400	2	coapts
coast	7	52	3626	2	coast
coat	6	75	5834	2	coa_t
compt	11	63	2822	2	compt
coopt	9	59	2985	2	coopt
craft	10	53	2766	2	craft
crap	8	57	3184	2	crap_
crape	9	61	2844	2	crape
craps	9	53	2864	2	craps
crept	9	51	2589	2	crept
crypt	12	37	1523	2	crypt
eclat	7	5	2360	2	ecla_t
flap	9	61	2870	2	flap_
flaps	10	56	2138	2	flaps
flat	7	71	4782	2	fla_t
inapt	7	35	2269	2	inapt
lap	5	85	6527	2	_lap_
laps	6	68	4887	2	_laps
last	4	62	6032	2	_last
lat	3	75	9340	2	_la_t
leapt	7	50	2747	2	leapt
lept	6	64	4088	2	_lept
plait	7	56	3157	2	plait
plant	7	54	3711	2	plant
plat	6	60	4887	2	pla_t
rapt	6	72	4531	2	_rapt
slant	5	52	3870	2	slant
slap	6	64	3404	2	slap_
slaps	7	60	2571	2	slaps
slat	4	69	5902	2	sla_t
slept	7	57	2810	2	slept
slipt	7	66	2748	2	slipt
trapt	7	64	3339	2	trapt
unapt	7	104	2159	2	unapt
wrapt	10	51	2318	2	wrapt
yclept	13	3	601	2	yclept

Search took 5 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	53800	0.186	960704.3
2	DLD Change Limit	53800	108	2.670	20149.8
3	Display Results	108	108	0.033	3272.7
	(SQL Overall)	178691	108	2.889	61852.2