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

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

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

281 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
campong	14	31	812	(None)
camping	14	31	1897	1	camping
campongs	15	35	612	1	campongs
kampong	16	29	493	1	kampong
among	8	58	1330	2	_am_ong
amping	11	43	1757	2	_amping
cameoing	13	7	906	2	cameoing
camion	10	39	1719	2	camion_
camions	11	39	1613	2	camions
campings	15	40	1020	2	campings
campion	13	30	1141	2	campion_
campions	14	35	1129	2	campions
campo	11	52	1976	2	campo__
campos	12	52	1795	2	campo_s
campout	13	4	1285	2	campout
capon	9	52	2187	2	ca_pon_
capons	10	41	1950	2	ca_pons
capping	14	38	1967	2	capping
carping	12	35	2108	2	carping
champing	18	36	1093	2	champing
clamping	15	40	1115	2	clamping
comping	14	35	1859	2	comping
compone	13	65	1719	2	compone
compony	16	130	1191	2	compony
cramping	15	34	1185	2	cramping
crampon	13	3	694	2	crampon_
crampons	14	3	664	2	crampons
damping	13	34	1400	2	damping
kampongs	17	29	303	2	kampongs
lamping	12	31	1600	2	lamping
ramping	12	33	1687	2	ramping
scamping	15	35	1019	2	scamping
tamping	12	28	1581	2	tamping
tampon	10	29	1123	2	tampon_
tampons	11	27	1156	2	tampons
vamping	15	28	1023	2	vamping
along	6	54	1949	3	_a_long
ammono	10	4	737	3	_ammono
aping	8	73	2723	3	_a_ping
bamming	14	46	1181	3	bamming
barong	9	60	1582	3	ba_rong
bumping	14	38	1249	3	bumping
cabbing	14	36	1315	3	cabbing
cabling	12	40	1755	3	cabling
caching	15	63	1750	3	caching
cadging	12	36	1097	3	cadging
caging	10	53	2102	3	ca_ging
cajon	14	45	1390	3	ca_jon_
caking	13	46	2467	3	ca_king
calking	14	46	1778	3	calking
calling	10	38	2677	3	calling
calming	12	39	1597	3	calming
calving	13	41	1350	3	calving
calzone	18	4	862	3	calzone
cameo	9	59	2499	3	cameo__
cameoed	12	3	838	3	cameoed
cameos	10	58	1800	3	cameo_s
camo	8	57	3175	3	cam_o__
camos	9	59	2761	3	cam_o_s
camp	10	63	3645	3	camp___
campagna	15	4	341	3	campagna
campagne	15	4	441	3	campagne
campaign	15	4	421	3	campaign
camped	13	47	2023	3	camp_ed
camper	12	47	2221	3	camp_er
campers	13	42	2029	3	campers
camphene	17	4	661	3	camphene
camphine	17	3	837	3	camphine
camphol	16	4	579	3	camphol
camphols	17	4	624	3	camphols
camphor	16	3	613	3	camphor
camphors	17	3	705	3	camphors
campi	11	62	1778	3	camp__i
campier	13	33	1327	3	campier
campily	16	3	827	3	campily
camporee	14	4	934	3	camporee
campouts	14	3	682	3	campouts
camps	11	63	3026	3	camp__s
campus	12	52	1392	3	camp_us
campusing	16	5	491	3	campusing
campy	14	51	1618	3	camp__y
caning	9	41	2862	3	ca_ning
canning	10	36	2013	3	canning
cannon	8	45	1444	3	cannon_
cannons	9	44	1288	3	cannons
canon	7	47	2530	3	ca_non_
canons	8	55	2206	3	ca_nons
canting	10	47	2590	3	canting
canton	8	57	2299	3	canton_
cantons	9	52	2120	3	cantons
canyon	11	45	1203	3	canyon_
canyons	12	45	1159	3	canyons
canzona	18	3	607	3	canzona
canzone	18	5	881	3	canzone
canzoni	18	3	615	3	canzoni
capo	8	58	2921	3	ca_po__
capos	9	48	2607	3	ca_po_s
capote	10	3	1573	3	ca_pote
cappings	15	36	949	3	cappings
carbon	10	49	1904	3	carbon_
carbons	11	54	1894	3	carbons
carding	11	39	2244	3	carding
cardon	9	41	2085	3	cardon_
cardons	10	45	1994	3	cardons
caring	9	51	3799	3	ca_ring
carking	14	43	2285	3	carking
carling	10	37	2706	3	carling
carpings	13	38	1239	3	carpings
carpool	11	3	922	3	carpool
carport	11	3	1603	3	carport
carting	10	42	2828	3	carting
carton	8	45	2266	3	carton_
cartons	9	41	2247	3	cartons
carving	13	39	1677	3	carving
cashing	13	50	2255	3	cashing
casing	9	48	2910	3	ca_sing
casking	14	43	1735	3	casking
casting	10	46	2834	3	casting
cation	8	39	2550	3	cation_
cations	9	45	2414	3	cations
catjang	17	3	392	3	catjang
catling	10	48	1979	3	catling
catting	10	39	2264	3	catting
causing	10	36	1441	3	causing
caving	12	48	2261	3	ca_ving
cawing	12	43	2261	3	ca_wing
champion	17	27	635	3	champion_
champions	18	87	578	3	champions
chapping	18	37	1072	3	chapping
chomping	18	33	988	3	chomping
chumping	18	34	906	3	chumping
clamming	15	32	937	3	clamming
clapping	15	38	1060	3	clapping
clasping	13	33	1026	3	clasping
cleping	12	33	1042	3	cleping
clomping	15	32	965	3	clomping
clumping	15	31	988	3	clumping
coaming	12	38	1832	3	coam_ing
combing	14	37	1473	3	combing
coming	11	42	2545	3	com_ing
common	12	3	1080	3	common_
commons	13	3	1104	3	commons
company	16	197	1114	3	company
compend	14	40	1030	3	compend
compo	11	53	1857	3	compo__
comport	13	36	1684	3	comport
compos	12	48	1880	3	compo_s
compose	13	57	1666	3	compose
composing	16	17	984	3	composing
compost	13	45	1535	3	compost
compote	13	56	1646	3	compote
compound	15	5	599	3	compound
compting	15	30	1360	3	compting
cooping	12	39	1893	3	cooping
coping	11	39	2766	3	c_oping
copping	14	39	1859	3	copping
couping	12	43	1702	3	couping
coupon	10	28	1099	3	coupon_
coupons	11	27	1056	3	coupons
cramming	15	33	943	3	cramming
crampoon	14	4	454	3	crampoon
crampoons	15	4	406	3	crampoons
craping	12	40	1871	3	craping
crapping	15	39	1145	3	crapping
creping	12	29	1365	3	creping
crepon	10	3	994	3	crepon_
crepons	11	3	932	3	crepons
crimping	15	29	978	3	crimping
crumping	15	31	990	3	crumping
cupping	14	43	1238	3	cupping
cymling	15	3	627	3	cymling
damming	13	38	1274	3	damming
damning	11	42	1163	3	damning
dampen	11	43	1059	3	dampen_
dampens	12	34	856	3	dampens
dampings	14	37	752	3	dampings
damson	9	3	806	3	damson_
damsons	10	3	801	3	damsons
dapping	13	37	1479	3	dapping
daylong	12	3	397	3	daylong
decamping	17	3	494	3	decamping
dumping	13	37	1291	3	dumping
encamping	16	4	523	3	encamping
faming	12	49	2297	3	fam_ing
gaming	10	46	2204	3	gam_ing
gamming	13	31	1262	3	gamming
gammon	11	3	890	3	gammon_
gammons	12	3	797	3	gammons
gaping	10	56	1892	3	ga_ping
gapping	13	42	1478	3	gapping
gasping	11	37	1436	3	gasping
gawping	14	41	846	3	gawping
gimping	13	37	1076	3	gimping
hambone	14	3	931	3	hambone
hamming	15	30	1409	3	hamming
happing	15	38	1723	3	happing
harping	13	41	1838	3	harping
hasping	13	44	1490	3	hasping
humping	15	32	1307	3	humping
imping	11	43	1535	3	_imping
impone	10	30	1186	3	_impone
jambing	19	32	853	3	jambing
jamming	19	32	979	3	jamming
japing	16	50	1357	3	ja_ping
jauping	17	30	719	3	jauping
jumping	19	31	980	3	jumping
kalong	11	7	770	3	ka_long
lambing	12	34	1241	3	lambing
laming	9	45	2836	3	lam_ing
lamming	12	30	1458	3	lamming
lampion	11	27	830	3	lampion_
lampions	12	27	797	3	lampions
lampoon	11	26	719	3	lampoon
lampoons	12	26	687	3	lampoons
lapping	12	41	1702	3	lapping
limping	12	46	1411	3	limping
lumping	12	33	1464	3	lumping
mahjong	20	4	227	3	mahjong
mamboing	15	3	597	3	mamboing
mammon	9	3	964	3	mammon_
mammons	10	4	851	3	mammons
mapping	14	34	1399	3	mapping
mumping	14	34	1163	3	mumping
naming	9	39	1789	3	nam_ing
napping	12	35	1418	3	napping
palping	12	41	1287	3	palping
pimping	14	38	1212	3	pimping
pompon	12	3	894	3	pompon_
pompons	13	3	855	3	pompons
pong	7	62	3114	3	___pong
pumping	14	42	1355	3	pumping
ramming	12	31	1506	3	ramming
ramona	8	4	1241	3	ram_ona
rampant	11	3	1217	3	rampant
rampion	11	29	858	3	rampion_
rampions	12	24	802	3	rampions
rampole	11	3	969	3	rampole
ramson	8	3	1046	3	ramson_
ramsons	9	3	956	3	ramsons
raping	9	48	2985	3	ra_ping
rapping	12	36	1910	3	rapping
rasping	10	43	1625	3	rasping
romping	12	31	1303	3	romping
sampan	10	25	1189	3	sampan_
sampans	11	24	1100	3	sampans
sampling	13	5	1064	3	sampling
sapping	12	35	1931	3	sapping
sarong	7	39	1487	3	sa_rong
scalping	13	34	1045	3	scalping
scamming	15	32	854	3	scamming
scammony	17	4	302	3	scammony
scaping	12	37	1569	3	sca_ping
scarping	13	33	1246	3	scarping
stamping	13	33	1096	3	stamping
swamping	16	30	792	3	swamping
taming	9	40	2343	3	tam_ing
tampan	10	25	1232	3	tampan_
tampans	11	33	1098	3	tampans
tampion	11	29	866	3	tampion_
tampions	12	35	812	3	tampions
tamponed	13	3	602	3	tamponed
tamponing	14	4	599	3	tamponing
taping	9	42	2239	3	ta_ping
tapping	12	33	1713	3	tapping
tarpon	8	28	1280	3	tarpon_
tarpons	9	26	1221	3	tarpons
temping	12	27	1069	3	temping
tramping	13	27	1127	3	tramping
tumping	12	31	1424	3	tumping
umping	11	48	1533	3	_umping
wapping	15	35	1460	3	wapping
warping	13	37	1518	3	warping
wimping	15	39	1101	3	wimping
yapon	10	46	1358	3	ya_pon_
yapons	11	44	1177	3	ya_pons
yapping	15	34	1261	3	yapping
yauping	13	35	724	3	yauping
yaupon	11	34	549	3	yaupon_
yaupons	12	34	568	3	yaupons
yawping	16	35	733	3	yawping
zapping	21	32	1147	3	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	134027	0.406	440125.6
2	DLD Change Limit	134027	281	5.796	23124.1
3	Display Results	281	281	0.093	3021.5
	(SQL Overall)	178691	281	6.295	28386.2