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

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

76 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
creping	12	29	1365	(None)
cleping	12	33	1042	1	cleping
craping	12	40	1871	1	craping
creeping	13	33	1010	1	creeping
crewing	13	32	1263	1	crewing
beeping	12	40	1391	2	beeping
brewing	13	34	1115	2	brewing
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
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
clewing	13	35	958	2	clewing
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
cramping	15	34	1185	2	cramping
craning	10	36	2030	2	craning
crapping	15	39	1145	2	crapping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
creaking	15	34	1412	2	creaking
creaming	13	34	1314	2	creaming
creasing	11	33	1444	2	creasing
creating	11	39	2195	2	creating
creeling	11	35	1336	2	creeling
cremini	11	22	906	2	cremini
crepier	11	3	974	2	crepier
crepon	10	3	994	2	crepon_
crepons	11	3	932	2	crepons
cresting	11	40	1704	2	cresting
cretin	8	29	1791	2	cretin_
cretins	9	32	1642	2	cretins
crimping	15	29	978	2	crimping
crisping	13	31	966	2	crisping
cropping	15	32	1088	2	cropping
crowing	13	38	1476	2	crowing
crumping	15	31	990	2	crumping
crying	12	36	1228	2	cr_ying
cueing	9	49	1361	2	cue_ing
cupping	14	43	1238	2	cupping
draping	11	42	1335	2	draping
dreeing	9	43	1118	2	dreeing
freeing	11	37	1391	2	freeing
greeing	9	36	1378	2	greeing
greying	12	41	1089	2	greying
griping	11	30	1206	2	griping
groping	11	33	1310	2	groping
jeeping	17	40	1033	2	jeeping
keeping	14	40	1254	2	keeping
peeping	12	36	1521	2	peeping
preeing	10	38	1767	2	preeing
prepping	12	30	976	2	prepping
preying	13	31	1455	2	preying
raping	9	48	2985	2	_raping
reaping	10	36	2121	2	_reaping
reding	8	38	2556	2	_reding
repin	7	53	2470	2	_repin_
repine	8	56	2781	2	_repine
repins	8	49	2431	2	_repins
repping	12	33	1498	2	_repping
riping	9	38	2161	2	_riping
roping	9	40	2302	2	_roping
scraping	13	33	1086	2	scraping
screwing	14	28	823	2	screwing
seeping	10	38	1791	2	seeping
treeing	8	34	1430	2	treeing
trepang	10	25	729	2	trepang
urping	9	39	1405	2	ur_ping
weeping	13	36	1367	2	weeping

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.390	458182.1
2	DLD Change Limit	107671	76	3.330	32333.6
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	3.750	47650.9