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

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

341 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
caper	9	48	3162	(None)
aper	6	63	3623	1	_aper
caber	9	51	2683	1	caber
cager	8	52	2922	1	cager
camper	12	47	2221	1	camper
caner	7	53	3477	1	caner
cape	8	72	4278	1	cape_
caped	10	49	3180	1	caped
capers	10	54	2814	1	capers
capes	9	54	4192	1	capes
capper	12	44	2198	1	capper
carer	7	49	4233	1	carer
carper	10	49	2363	1	carper
cater	7	48	4072	1	cater
caver	10	56	2906	1	caver
coper	9	53	3609	1	coper
gaper	8	61	2512	1	gaper
japer	14	62	1888	1	japer
paper	9	51	2866	1	paper
raper	7	49	3275	1	raper
taper	7	48	2977	1	taper
ager	5	59	3584	2	_ager
ape	5	72	5118	2	_ape_
aped	7	85	3815	2	_aped
apers	7	66	2913	2	_apers
apery	10	65	1790	2	_apery
apes	6	60	4743	2	_apes
apex	13	72	2021	2	_apex
apter	7	61	2020	2	_apter
asper	7	55	2043	2	asper
aver	7	59	3188	2	_aver
baker	11	56	2954	2	baker
baler	7	56	3527	2	baler
barer	7	45	3580	2	barer
baser	7	48	2892	2	baser
cabers	10	50	2392	2	cabers
cabler	10	45	1917	2	cabler
cade	7	64	4391	2	cade_
cades	8	54	4073	2	cades
cadet	8	53	3934	2	cadet
cadger	10	50	1391	2	cadger
cadre	8	54	1902	2	cadre
cafe	9	52	3032	2	cafe_
cafes	10	64	2692	2	cafes
cage	7	53	3906	2	cage_
caged	9	54	2636	2	caged
cagers	9	56	2419	2	cagers
cages	8	59	3601	2	cages
cagey	11	59	1782	2	cagey
cagier	9	37	1593	2	cagier
cahier	11	36	1577	2	cahier
cake	10	54	3996	2	cake_
caked	12	61	2862	2	caked
cakes	11	60	3767	2	cakes
cakey	14	55	1727	2	cakey
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
camber	12	44	1848	2	camber
came	8	76	4875	2	came_
camel	9	68	2280	2	camel
cameo	9	59	2499	2	cameo
camera	10	3	1369	2	camera
cames	9	70	4731	2	cames
camped	13	47	2023	2	camped
campers	13	42	2029	2	campers
campier	13	33	1327	2	campier
cancer	10	42	2092	2	cancer
cane	6	66	5312	2	cane_
caned	8	58	3809	2	caned
caners	8	46	2920	2	caners
canes	7	53	5037	2	canes
canker	12	44	2252	2	canker
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
cap	7	67	5898	2	cap__
capered	12	30	1404	2	capered
caperer	11	30	1340	2	caperer
caph	11	66	2329	2	cap_h
caphs	12	45	1537	2	caphs
capiz	18	5	1456	2	capiz
caplet	10	42	2681	2	caplet
capo	8	58	2921	2	cap_o
capon	9	52	2187	2	capon
capos	9	48	2607	2	capos
capped	13	47	2185	2	capped
cappers	13	44	1940	2	cappers
caps	8	71	4789	2	cap_s
captor	10	49	1460	2	captor
caput	9	8	2398	2	caput
car	5	91	6556	2	ca__r
carder	9	45	2418	2	carder
care	6	69	6837	2	care_
cared	8	60	5009	2	cared
career	8	58	2224	2	career
carers	8	51	3396	2	carers
cares	7	73	6918	2	cares
caret	7	53	6056	2	caret
carex	14	48	2230	2	carex
carped	11	59	2376	2	carped
carpel	10	54	1847	2	carpel
carpers	11	45	2125	2	carpers
carpet	10	45	3009	2	carpet
carr	6	54	3470	2	ca_rr
carter	8	49	3227	2	carter
carver	11	44	2015	2	carver
case	6	58	4808	2	case_
cased	8	60	3241	2	cased
casern	8	47	1331	2	casern
cases	7	50	4838	2	cases
caster	8	52	3257	2	caster
cate	6	62	5460	2	cate_
caters	8	53	3650	2	caters
cates	7	59	5189	2	cates
causer	8	41	1778	2	causer
cave	9	59	4126	2	cave_
caved	11	62	2756	2	caved
cavern	11	53	1245	2	cavern
cavers	11	50	2684	2	cavers
caves	10	56	3970	2	caves
cawed	11	66	2706	2	cawed
ceder	8	53	2224	2	ceder
cepe	8	49	2665	2	cepe_
cepes	9	44	2446	2	cepes
chafer	14	47	1457	2	chafer
champer	16	38	1341	2	champer
chape	12	52	2114	2	chape_
chapel	13	49	1137	2	chapel
chapes	13	54	2187	2	chapes
chapter	14	42	1385	2	chapter
chaser	11	49	1838	2	chaser
chawer	14	43	1441	2	chawer
cheaper	14	40	1058	2	cheaper
cheer	10	54	2038	2	cheer
cider	8	47	2331	2	cider
cipher	13	37	1026	2	cipher
citer	7	48	2733	2	citer
clamper	13	40	1299	2	clamper
clapper	13	40	1186	2	clapper
clasper	11	38	1186	2	clasper
claver	11	38	1697	2	claver
clawer	11	45	1278	2	clawer
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
coder	8	61	3422	2	coder
comer	9	58	3269	2	comer
cooer	7	48	3101	2	cooer
cooper	10	42	2112	2	cooper
cope	8	68	4738	2	cope_
coped	10	50	3684	2	coped
copen	9	48	2643	2	copen
copers	10	46	2984	2	copers
copes	9	77	4710	2	copes
copier	10	37	2289	2	copier
copper	12	43	2189	2	copper
copter	10	98	2201	2	copter
corer	7	55	3887	2	corer
cover	10	54	3077	2	cover
cower	10	45	3177	2	cower
coyer	10	52	2284	2	coyer
crape	9	61	2844	2	crape_
craped	11	61	2052	2	craped
crapes	10	47	2769	2	crapes
crapper	13	39	1319	2	crapper
crater	8	50	2664	2	crater
craver	11	46	1847	2	craver
crier	7	47	2446	2	crier
cuber	9	52	2253	2	cuber
cupel	9	5	1430	2	cupel
cupper	12	43	1386	2	cupper
curer	7	50	3075	2	curer
cuter	7	47	2823	2	cuter
cyber	12	49	1038	2	cyber
cyder	11	46	1113	2	cyder
cypher	16	30	659	2	cypher
damper	11	41	1775	2	damper
dapper	11	40	1663	2	dapper
darer	6	52	3079	2	darer
dater	6	53	3231	2	dater
diaper	9	45	1311	2	diaper
doper	8	61	2839	2	doper
draper	9	43	1569	2	draper
duper	8	55	1900	2	duper
eager	6	55	2697	2	eager
eater	5	46	3984	2	eater
escaper	11	36	884	2	escaper
facer	10	55	2505	2	facer
fader	9	44	2151	2	fader
faker	12	48	2459	2	faker
farer	8	67	3314	2	farer
gager	7	47	2629	2	gager
gamer	8	49	2894	2	gamer
gape	7	51	3451	2	gape_
gaped	9	61	2353	2	gaped
gapers	9	45	2047	2	gapers
gapes	8	60	3082	2	gapes
gasper	9	45	1554	2	gasper
gater	6	45	3365	2	gater
gawper	12	49	969	2	gawper
gayer	9	45	1919	2	gayer
gazer	15	57	2007	2	gazer
haler	8	50	3352	2	haler
hamper	13	45	1865	2	hamper
harper	11	50	1840	2	harper
hater	8	50	3475	2	hater
haver	11	51	2446	2	haver
hayer	11	46	2024	2	hayer
hazer	17	48	2023	2	hazer
heaper	11	41	1952	2	heaper
hoper	10	58	2914	2	hoper
hyper	13	52	1390	2	hyper
jager	13	43	1813	2	jager
jape	13	49	2342	2	jape_
japed	15	62	1763	2	japed
japers	15	46	1617	2	japers
japery	18	43	914	2	japery
japes	14	63	2282	2	japes
jasper	15	46	1038	2	jasper
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
lapel	7	37	1668	2	lapel
lapper	10	43	1995	2	lapper
lapser	8	41	1314	2	lapser
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
leaper	8	81	1894	2	leaper
leper	7	48	2074	2	leper
loper	7	51	2923	2	loper
macer	9	121	2694	2	macer
maker	11	41	2781	2	maker
mapper	12	45	1609	2	mapper
maser	7	50	2997	2	maser
mater	7	44	3886	2	mater
mazer	16	57	2242	2	mazer
moper	9	49	2592	2	moper
namer	7	56	2210	2	namer
nape	6	52	3080	2	nape_
napery	11	48	981	2	napery
napes	7	48	2846	2	napes
napper	10	37	1828	2	napper
oater	5	54	3373	2	oater
pacer	9	61	3161	2	pacer
pager	8	47	2820	2	pager
paler	7	54	3693	2	paler
pamper	12	43	1666	2	pamper
papers	10	51	2532	2	papers
papery	13	48	1274	2	papery
parer	7	58	3990	2	parer
pater	7	47	4072	2	pater
pauper	10	35	1194	2	pauper
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
per	5	63	5309	2	__per
piper	9	65	2319	2	piper
racer	7	52	3302	2	racer
raker	9	45	2979	2	raker
rape	6	50	4163	2	rape_
raped	8	53	3462	2	raped
rapers	8	43	2718	2	rapers
rapes	7	57	4072	2	rapes
rapier	8	40	1999	2	rapier
rapper	10	46	2157	2	rapper
rarer	5	47	3170	2	rarer
raser	5	56	3341	2	raser
rasper	8	39	1733	2	rasper
rater	5	49	4328	2	rater
raver	8	56	3149	2	raver
rawer	8	46	2373	2	rawer
razer	14	48	2427	2	razer
reaper	8	42	2314	2	reaper
riper	7	43	2840	2	riper
roper	7	54	3191	2	roper
saber	7	53	3024	2	saber
safer	8	47	2181	2	safer
sager	6	54	3205	2	sager
saker	9	51	3202	2	saker
saner	5	43	3432	2	saner
sapor	7	51	1925	2	sapor
sapper	10	38	2235	2	sapper
saver	8	48	3125	2	saver
sawer	8	50	2621	2	sawer
sayer	8	49	2655	2	sayer
scaler	8	43	2160	2	scaler
scalper	11	39	1292	2	scalper
scamper	13	46	1316	2	scamper
scape	9	69	2184	2	scape_
scaped	11	55	1955	2	scaped
scapes	10	51	2226	2	scapes
scarer	8	45	2461	2	scarer
scarper	11	48	1482	2	scarper
scauper	11	37	945	2	scauper
scraper	11	45	1342	2	scraper
shaper	11	41	1993	2	shaper
soaper	8	45	1787	2	soaper
super	7	49	2448	2	super
taber	7	38	2582	2	taber
taker	9	52	2900	2	taker
taler	5	60	3486	2	taler
tamer	7	52	3010	2	tamer
tamper	10	46	1851	2	tamper
tape	6	45	3814	2	tape_
taped	8	53	2742	2	taped
tapers	8	40	2581	2	tapers
tapes	7	58	3860	2	tapes
tapir	7	59	1706	2	tapir
tapper	10	44	1961	2	tapper
tater	5	41	3861	2	tater
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
toper	7	52	3102	2	toper
upper	9	37	1426	2	upper
vamper	13	42	1265	2	vamper
vapor	10	40	1309	2	vapor
viper	10	50	1730	2	viper
wader	9	53	2536	2	wader
wafer	11	44	1764	2	wafer
wager	9	59	2505	2	wager
waker	12	55	2659	2	waker
waler	8	42	2926	2	waler
warper	11	40	1558	2	warper
water	8	47	3331	2	water
waver	11	50	2570	2	waver
waxer	15	43	1748	2	waxer
wiper	10	54	2129	2	wiper
yager	9	56	1675	2	yager
yapper	13	37	1451	2	yapper
yarer	8	43	2157	2	yarer
yauper	11	36	854	2	yauper
yawper	14	43	795	2	yawper
zapper	19	34	1402	2	zapper

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	341	1.453	37026.8
3	Display Results	341	341	0.096	3552.1
	(SQL Overall)	178691	341	1.859	96122.1