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

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

176 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
camper	12	47	2221	(None)
camber	12	44	1848	1	camber
camped	13	47	2023	1	camped
campers	13	42	2029	1	campers
campier	13	33	1327	1	campier
caper	9	48	3162	1	ca_per
capper	12	44	2198	1	capper
carper	10	49	2363	1	carper
champer	16	38	1341	1	champer
clamper	13	40	1299	1	clamper
damper	11	41	1775	1	damper
hamper	13	45	1865	1	hamper
pamper	12	43	1666	1	pamper
scamper	13	46	1316	1	scamper
tamper	10	46	1851	1	tamper
vamper	13	42	1265	1	vamper
amber	9	45	2321	2	_amber
ameer	7	56	1898	2	_ameer
amped	10	48	2051	2	_amped
ampere	10	5	1441	2	_ampere
ampler	10	43	1330	2	_ampler
aper	6	63	3623	2	_a_per
asper	7	55	2043	2	_asper
bumper	12	37	1434	2	bumper
caber	9	51	2683	2	ca_ber
cabler	10	45	1917	2	cabler
cadger	10	50	1391	2	cadger
cager	8	52	2922	2	ca_ger
cagier	9	37	1593	2	cagier
cahier	11	36	1577	2	cahier
cakier	12	31	1524	2	cakier
caliper	11	4	1096	2	caliper
calker	12	49	1708	2	calker
caller	8	51	2548	2	caller
calmer	10	52	1693	2	calmer
cambers	13	40	1744	2	cambers
came	8	76	4875	2	cam_e_
camel	9	68	2280	2	cam_el
cameo	9	59	2499	2	cam_eo
camera	10	3	1369	2	cam_era
cames	9	70	4731	2	cam_es
camlet	10	44	2658	2	camlet
camp	10	63	3645	2	camp__
camphor	16	3	613	2	camphor
campi	11	62	1778	2	camp_i
campo	11	52	1976	2	camp_o
campos	12	52	1795	2	campos
camps	11	63	3026	2	camp_s
campus	12	52	1392	2	campus
campy	14	51	1618	2	camp_y
cancer	10	42	2092	2	cancer
caner	7	53	3477	2	ca_ner
canker	12	44	2252	2	canker
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
cape	8	72	4278	2	ca_pe_
caped	10	49	3180	2	ca_ped
capers	10	54	2814	2	ca_pers
capes	9	54	4192	2	ca_pes
capped	13	47	2185	2	capped
cappers	13	44	1940	2	cappers
carder	9	45	2418	2	carder
career	8	58	2224	2	career
carer	7	49	4233	2	ca_rer
carped	11	59	2376	2	carped
carpel	10	54	1847	2	carpel
carpers	11	45	2125	2	carpers
carpet	10	45	3009	2	carpet
carter	8	49	3227	2	carter
carver	11	44	2015	2	carver
caster	8	52	3257	2	caster
cater	7	48	4072	2	ca_ter
causer	8	41	1778	2	causer
caver	10	56	2906	2	ca_ver
chamber	16	40	1106	2	chamber
chamfer	17	39	986	2	chamfer
champed	17	41	1148	2	champed
champers	17	33	1162	2	champers
chomper	16	38	1007	2	chomper
clamber	13	33	1174	2	clamber
clammer	13	42	1179	2	clammer
clamped	14	40	1204	2	clamped
clampers	14	32	1189	2	clampers
clapper	13	40	1186	2	clapper
clasper	11	38	1186	2	clasper
comber	12	51	1850	2	comber
comer	9	58	3269	2	com_er
comped	13	59	1987	2	comped
compeer	13	38	1155	2	compeer
compel	12	44	1289	2	compel
compere	13	46	1662	2	compere
cooper	10	42	2112	2	cooper
coper	9	53	3609	2	c_oper
copper	12	43	2189	2	copper
crammer	13	40	1096	2	crammer
cramped	14	47	1218	2	cramped
crampier	14	28	890	2	crampier
crapper	13	39	1319	2	crapper
crimper	13	65	1042	2	crimper
cumber	12	40	1670	2	cumber
cummer	12	44	1459	2	cummer
cupper	12	43	1386	2	cupper
dammer	11	43	1793	2	dammer
damner	9	52	1343	2	damner
damped	12	43	1558	2	damped
dampen	11	43	1059	2	dampen
dampers	12	39	1569	2	dampers
dapper	11	40	1663	2	dapper
dumper	11	46	1521	2	dumper
gamer	8	49	2894	2	gam_er
gamier	9	36	1793	2	gamier
gammer	11	123	1833	2	gammer
gaper	8	61	2512	2	ga_per
gasper	9	45	1554	2	gasper
gawper	12	49	969	2	gawper
hammer	13	81	2003	2	hammer
hampers	14	36	1695	2	hampers
harper	11	50	1840	2	harper
humper	13	41	1588	2	humper
jammer	17	40	1413	2	jammer
japer	14	62	1888	2	ja_per
jasper	15	46	1038	2	jasper
jimper	17	38	986	2	jimper
jumper	17	36	1237	2	jumper
lamber	10	44	1849	2	lamber
lamer	7	52	3370	2	lam_er
lamped	11	40	1754	2	lamped
lampers	11	38	1733	2	lampers
lapper	10	43	1995	2	lapper
limper	10	41	1785	2	limper
lumper	10	38	1665	2	lumper
mammer	9	42	1886	2	mammer
mamzer	19	45	983	2	mamzer
mapper	12	45	1609	2	mapper
mumper	12	35	1352	2	mumper
namer	7	56	2210	2	nam_er
napper	10	37	1828	2	napper
pampero	13	32	809	2	pampero
pampers	13	36	1593	2	pampers
paper	9	51	2866	2	pa_per
pauper	10	35	1194	2	pauper
pumper	12	44	1555	2	pumper
rammer	10	35	1965	2	rammer
ramped	11	46	1790	2	ramped
raper	7	49	3275	2	ra_per
rapper	10	46	2157	2	rapper
rasper	8	39	1733	2	rasper
romper	10	42	1368	2	romper
sampler	11	32	1201	2	sampler
sapper	10	38	2235	2	sapper
scalper	11	39	1292	2	scalper
scammer	13	36	1197	2	scammer
scamped	14	47	1196	2	scamped
scampers	14	36	1103	2	scampers
scarper	11	48	1482	2	scarper
scauper	11	37	946	2	scauper
simper	10	36	1629	2	simper
stamper	11	37	1440	2	stamper
swamper	14	34	931	2	swamper
tamer	7	52	3010	2	tam_er
tamped	11	43	1704	2	tamped
tampers	11	35	1674	2	tampers
taper	7	48	2977	2	ta_per
tapper	10	44	1961	2	tapper
temper	10	39	1409	2	temper
tramper	11	38	1216	2	tramper
vamped	14	42	1101	2	vamped
vampers	14	31	1162	2	vampers
vampier	14	30	823	2	vampier
warper	11	40	1558	2	warper
yammer	13	37	1318	2	yammer
yapper	13	37	1451	2	yapper
yauper	11	36	854	2	yauper
yawper	14	43	795	2	yawper
zapper	19	34	1402	2	zapper

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	176	2.250	36689.3
3	Display Results	176	176	0.063	2793.7
	(SQL Overall)	178691	176	2.656	67278.2