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

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

65 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
cleping	12	33	1042	(None)
clewing	13	35	958	1	clewing
creping	12	29	1365	1	creping
beeping	12	40	1391	2	beeping
bleeping	13	37	793	2	bleeping
camping	14	31	1897	2	camping
capping	14	38	1967	2	capping
carping	12	35	2108	2	carping
ceding	10	40	1480	2	c_eding
celling	10	39	2126	2	celling
cering	9	45	2253	2	c_ering
cheeping	16	32	955	2	cheeping
chefing	16	35	903	2	chefing
chewing	16	39	1114	2	chewing
clamping	15	40	1115	2	clamping
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
clawing	13	38	1267	2	clawing
claying	13	36	1430	2	claying
cleaning	11	31	1238	2	cleaning
clearing	11	30	1488	2	clearing
cleating	11	35	1813	2	cleating
cleaving	14	138	968	2	cleaving
cleeking	15	26	781	2	cleeking
clefting	14	34	758	2	clefting
clerking	15	25	716	2	clerking
cling	8	64	2467	2	cl__ing
clipping	15	34	915	2	clipping
clomping	15	32	965	2	clomping
cloning	10	32	1547	2	cloning
clopping	15	35	1108	2	clopping
closing	10	31	1484	2	closing
cloying	13	35	1175	2	cloying
clueing	10	41	1009	2	clueing
cluing	9	39	1350	2	cl_uing
clumping	15	31	988	2	clumping
comping	14	35	1859	2	comping
cooping	12	39	1893	2	cooping
coping	11	39	2766	2	c_oping
copping	14	39	1859	2	copping
couping	12	43	1702	2	couping
craping	12	40	1871	2	craping
creeping	13	33	1010	2	creeping
crewing	13	32	1263	2	crewing
cueing	9	49	1361	2	cue_ing
cupping	14	43	1238	2	cupping
eloping	10	35	1283	2	eloping
fleeing	11	35	1129	2	fleeing
flexing	18	35	899	2	flexing
fleying	14	32	987	2	fleying
gleying	12	31	843	2	gleying
helping	13	35	1222	2	helping
jeeping	17	40	1033	2	jeeping
keeping	14	40	1254	2	keeping
kelping	14	31	919	2	kelping
leaping	10	32	1599	2	_leaping
loping	9	39	2141	2	_loping
peeping	12	36	1521	2	peeping
seeping	10	38	1791	2	seeping
sleeping	11	38	1205	2	sleeping
slewing	11	33	1135	2	slewing
sliping	10	33	1441	2	sliping
sloping	10	41	1407	2	sloping
weeping	13	36	1367	2	weeping
yelping	13	31	787	2	yelping

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.376	475242.0
2	DLD Change Limit	107671	65	3.376	31893.1
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	3.782	47247.8