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

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

151 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
camping	14	31	1897	(None)
amping	11	43	1757	1	_amping
campings	15	40	1020	1	campings
campong	14	31	812	1	campong
capping	14	38	1967	1	capping
carping	12	35	2108	1	carping
champing	18	36	1093	1	champing
clamping	15	40	1115	1	clamping
comping	14	35	1859	1	comping
cramping	15	34	1185	1	cramping
damping	13	34	1400	1	damping
lamping	12	31	1600	1	lamping
ramping	12	33	1687	1	ramping
scamping	15	35	1019	1	scamping
tamping	12	28	1581	1	tamping
vamping	15	28	1023	1	vamping
aping	8	73	2723	2	_a_ping
bamming	14	46	1181	2	bamming
bumping	14	38	1249	2	bumping
cabbing	14	36	1315	2	cabbing
cabling	12	40	1755	2	cabling
caching	15	63	1750	2	caching
cadging	12	36	1097	2	cadging
caging	10	53	2102	2	ca_ging
caking	13	46	2467	2	ca_king
calking	14	46	1778	2	calking
calling	10	38	2677	2	calling
calming	12	39	1597	2	calming
calving	13	41	1350	2	calving
cameoing	13	7	906	2	cameoing
campaign	15	4	421	2	campaign
camphine	17	3	837	2	camphine
campi	11	62	1778	2	campi__
campier	13	33	1327	2	campier
campily	16	3	827	2	campily
campion	13	30	1141	2	campion
campions	14	35	1129	2	campions
campongs	15	35	612	2	campongs
campusing	16	5	491	2	campusing
caning	9	41	2862	2	ca_ning
canning	10	36	2013	2	canning
canting	10	47	2590	2	canting
cappings	15	36	949	2	cappings
carding	11	39	2243	2	carding
caring	9	51	3799	2	ca_ring
carking	14	43	2285	2	carking
carling	10	37	2706	2	carling
carpings	13	38	1238	2	carpings
carting	10	42	2828	2	carting
carving	13	39	1677	2	carving
cashing	13	50	2255	2	cashing
casing	9	48	2910	2	ca_sing
casking	14	43	1735	2	casking
casting	10	46	2834	2	casting
catling	10	48	1979	2	catling
catting	10	39	2264	2	catting
causing	10	36	1441	2	causing
caving	12	48	2261	2	ca_ving
cawing	12	43	2261	2	ca_wing
chapping	18	37	1072	2	chapping
chomping	18	33	988	2	chomping
chumping	18	34	906	2	chumping
clamming	15	32	937	2	clamming
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
cleping	12	33	1042	2	cleping
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
coaming	12	38	1832	2	coam_ing
combing	14	37	1473	2	combing
coming	11	42	2545	2	com_ing
compting	15	30	1360	2	compting
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
cramming	15	33	943	2	cramming
craping	12	40	1871	2	craping
crapping	15	39	1145	2	crapping
creping	12	29	1365	2	creping
crimping	15	29	978	2	crimping
crumping	15	31	990	2	crumping
cupping	14	43	1238	2	cupping
cymling	15	3	627	2	cymling
damming	13	38	1274	2	damming
damning	11	42	1163	2	damning
dampings	14	37	752	2	dampings
dapping	13	37	1479	2	dapping
decamping	17	3	494	2	decamping
dumping	13	37	1291	2	dumping
encamping	16	4	523	2	encamping
faming	12	49	2297	2	fam_ing
gaming	10	46	2204	2	gam_ing
gamming	13	31	1262	2	gamming
gaping	10	56	1892	2	ga_ping
gapping	13	42	1478	2	gapping
gasping	11	37	1436	2	gasping
gawping	14	41	846	2	gawping
gimping	13	37	1076	2	gimping
hamming	15	30	1409	2	hamming
happing	15	38	1723	2	happing
harping	13	41	1838	2	harping
hasping	13	44	1490	2	hasping
humping	15	32	1307	2	humping
imping	11	43	1535	2	_imping
jambing	19	32	853	2	jambing
jamming	19	32	979	2	jamming
japing	16	50	1357	2	ja_ping
jauping	17	30	719	2	jauping
jumping	19	31	980	2	jumping
kampong	16	29	493	2	kampong
lambing	12	34	1241	2	lambing
laming	9	45	2836	2	lam_ing
lamming	12	30	1458	2	lamming
lapping	12	41	1702	2	lapping
limping	12	46	1411	2	limping
lumping	12	33	1464	2	lumping
mapping	14	34	1399	2	mapping
mumping	14	34	1163	2	mumping
naming	9	39	1789	2	nam_ing
napping	12	35	1418	2	napping
palping	12	41	1287	2	palping
pimping	14	38	1212	2	pimping
pumping	14	42	1355	2	pumping
ramming	12	31	1506	2	ramming
raping	9	48	2985	2	ra_ping
rapping	12	36	1910	2	rapping
rasping	10	43	1625	2	rasping
romping	12	31	1303	2	romping
sampling	13	5	1064	2	sampling
sapping	12	35	1931	2	sapping
scalping	13	34	1045	2	scalping
scamming	15	32	854	2	scamming
scaping	12	37	1569	2	sca_ping
scarping	13	33	1246	2	scarping
stamping	13	33	1096	2	stamping
swamping	16	30	792	2	swamping
taming	9	40	2343	2	tam_ing
taping	9	42	2239	2	ta_ping
tapping	12	33	1713	2	tapping
temping	12	27	1069	2	temping
tramping	13	27	1127	2	tramping
tumping	12	31	1424	2	tumping
umping	11	48	1533	2	_umping
wapping	15	35	1460	2	wapping
warping	13	37	1518	2	warping
wimping	15	39	1101	2	wimping
yapping	15	34	1261	2	yapping
yauping	13	35	724	2	yauping
yawping	16	35	733	2	yawping
zapping	21	32	1147	2	zapping

Search took 7 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.203	880251.2
2	DLD Change Limit	107671	151	6.623	16257.1
3	Display Results	151	151	0.110	1372.7
	(SQL Overall)	178691	151	6.936	25762.8