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

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

70 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
clapping	15	38	1060	(None)
capping	14	38	1967	1	c_apping
chapping	18	37	1072	1	chapping
clamping	15	40	1115	1	clamping
clasping	13	33	1026	1	clasping
clipping	15	34	915	1	clipping
clopping	15	35	1108	1	clopping
crapping	15	39	1145	1	crapping
flapping	16	29	815	1	flapping
lapping	12	41	1702	1	_lapping
slapping	13	35	1083	1	slapping
blipping	15	30	680	2	blipping
camping	14	31	1897	2	c_amping
cappings	15	36	949	2	c_appings
carping	12	35	2108	2	c_arping
champing	18	36	1093	2	champing
chipping	18	38	979	2	chipping
chopping	18	37	1026	2	chopping
clacking	17	33	1349	2	clacking
cladding	13	3	714	2	cladding
clagging	13	32	887	2	clagging
claiming	13	27	930	2	claiming
clamming	15	32	937	2	clamming
clanging	12	40	1212	2	clanging
clanking	15	43	1306	2	clanking
clashing	14	38	1219	2	clashing
classing	11	32	1179	2	classing
clawing	13	38	1267	2	cla_wing
claying	13	36	1430	2	cla_ying
cleping	12	33	1042	2	cl_eping
clippings	16	27	375	2	clippings
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
coapting	13	35	1161	2	coapting
copping	14	39	1859	2	c_opping
cramping	15	34	1185	2	cramping
craping	12	40	1871	2	cra_ping
cropping	15	32	1088	2	cropping
cupping	14	43	1238	2	c_upping
dapping	13	37	1479	2	_dapping
elapsing	11	4	671	2	elapsing
flipping	16	30	766	2	flipping
flopping	16	38	877	2	flopping
frapping	16	34	810	2	frapping
gapping	13	42	1478	2	_gapping
glopping	14	30	775	2	glopping
happing	15	38	1723	2	_happing
knapping	17	31	497	2	knapping
lamping	12	31	1600	2	_lamping
lapsing	10	35	1116	2	_lapsing
lapwing	13	30	826	2	_lapwing
lipping	12	30	1607	2	_lipping
lopping	12	38	1522	2	_lopping
mapping	14	34	1399	2	_mapping
napping	12	35	1418	2	_napping
plopping	12	31	870	2	plopping
rapping	12	36	1910	2	_rapping
sapping	12	35	1931	2	_sapping
scrapping	16	3	574	2	scrapping
slipping	13	35	1066	2	slipping
slopping	13	38	1142	2	slopping
snapping	13	34	965	2	snapping
swapping	16	34	867	2	swapping
tapping	12	33	1713	2	_tapping
trapping	13	29	1139	2	trapping
wapping	15	35	1460	2	_wapping
whapping	19	31	711	2	whapping
wrapping	16	29	762	2	wrapping
yapping	15	34	1261	2	_yapping
zapping	21	32	1147	2	_zapping

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	121059	0.143	1249587.4
2	DLD Change Limit	121059	70	3.406	35542.9
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	3.562	50165.9