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

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

313 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
apers	7	66	2913	(None)
agers	6	50	2785	1	agers
aper	6	63	3623	1	aper_
apery	10	65	1790	1	apery
apes	6	60	4743	1	ape_s
apres	7	54	2640	1	apres
aspers	8	62	2031	1	aspers
avers	8	51	2731	1	avers
capers	10	54	2814	1	capers
gapers	9	45	2047	1	gapers
japers	15	46	1617	1	japers
papers	10	51	2532	1	papers
rapers	8	43	2718	1	rapers
tapers	8	40	2581	1	tapers
abets	7	56	2167	2	abets
acerb	9	3	1276	2	acerb
aces	6	76	4509	2	ace_s
acres	7	63	2776	2	acres
adders	8	43	1570	2	adders
aero	4	54	3534	2	a_ero
aery	7	72	3168	2	a_ery
afars	8	57	1651	2	afars
afters	9	47	1707	2	afters
agars	6	61	2064	2	agars
ager	5	59	3584	2	ager_
ages	5	58	4459	2	age_s
aggers	8	58	1779	2	aggers
aiders	7	45	2463	2	aiders
aimers	8	46	2191	2	aimers
airers	6	49	2231	2	airers
airs	4	64	4742	2	a_irs
aivers	9	48	2232	2	aivers
akees	9	61	1924	2	akees
alders	7	42	1842	2	alders
alecs	7	66	2073	2	alecs
alefs	8	73	1966	2	alefs
alert	5	47	4065	2	alert
alerts	6	44	1822	2	alerts
ales	4	70	6710	2	ale_s
alters	6	49	2422	2	alters
ambers	10	45	1958	2	ambers
ameers	8	40	1557	2	ameers
amens	7	56	2484	2	amens
amirs	7	59	2492	2	amirs
ampere	10	5	1441	2	ampere
amperes	11	3	1398	2	amperes
anears	6	37	1718	2	anears
anes	4	52	5593	2	ane_s
angers	7	52	2254	2	angers
apart	7	43	3067	2	apart
ape	5	72	5118	2	ape__
apeak	11	55	1345	2	apeak
aped	7	85	3815	2	ape_d
apeek	11	47	1187	2	apeek
apercu	10	5	738	2	apercu
apercus	11	3	657	2	apercus
aperies	9	4	2320	2	aperies
apex	13	72	2021	2	ape_x
apexes	15	3	913	2	apexes
aphis	10	59	1713	2	aphis
apneas	8	32	1138	2	apneas
apods	8	63	1634	2	apods
aport	7	54	3217	2	aport
apos	6	54	3382	2	ap_os
appears	11	30	895	2	appears
appels	10	43	1279	2	appels
apps	8	63	1969	2	ap_ps
apses	7	68	2391	2	apses
apsis	7	57	1829	2	apsis
apter	7	61	2020	2	apter_
areas	5	59	3577	2	areas
ares	4	58	7102	2	are_s
armers	8	55	2027	2	armers
arpens	8	48	1482	2	arpens
ars	3	76	7093	2	a__rs
askers	10	59	1540	2	askers
aspens	8	50	1335	2	aspens
asper	7	55	2043	2	asper_
asperse	9	42	1066	2	asperse
asters	6	56	3160	2	asters
ates	4	50	4792	2	ate_s
augers	7	38	1870	2	augers
aures	5	51	3709	2	aures
avens	8	64	1933	2	avens
aver	7	59	3188	2	aver_
averse	9	58	1118	2	averse
avert	8	60	2949	2	avert
averts	9	57	1524	2	averts
aves	7	61	4260	2	ave_s
awes	7	60	3755	2	awe_s
axels	12	63	1363	2	axels
axes	11	73	3785	2	axe_s
ayes	7	65	4351	2	aye_s
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
beers	7	56	2839	2	beers
biers	7	62	2522	2	biers
cabers	10	50	2392	2	cabers
cagers	9	56	2419	2	cagers
campers	13	42	2029	2	campers
caners	8	46	2920	2	caners
caper	9	48	3162	2	caper_
capes	9	54	4192	2	cape_s
cappers	13	44	1940	2	cappers
carers	8	51	3396	2	carers
carpers	11	45	2125	2	carpers
caters	8	53	3650	2	caters
cavers	11	50	2684	2	cavers
copers	10	46	2984	2	copers
dampers	12	39	1569	2	dampers
darers	7	59	2187	2	darers
daters	7	48	2737	2	daters
deers	6	49	3052	2	deers
diapers	10	47	1391	2	diapers
doers	6	52	2571	2	doers
dopers	9	55	2248	2	dopers
drapers	10	53	1335	2	drapers
dupers	9	46	1560	2	dupers
dyers	9	66	1713	2	dyers
eagers	7	45	2368	2	eagers
eaters	6	55	3595	2	eaters
egers	6	51	2037	2	egers
epees	7	52	1983	2	epees
ers	3	60	4628	2	__ers
ewers	8	60	1882	2	ewers
eyers	8	65	2133	2	eyers
facers	11	55	1944	2	facers
faders	10	51	1746	2	faders
fakers	13	42	1953	2	fakers
farers	9	59	2405	2	farers
gagers	8	40	2133	2	gagers
gamers	9	44	2083	2	gamers
gaper	8	61	2512	2	gaper_
gapes	8	60	3082	2	gape_s
gaspers	10	50	1413	2	gaspers
gaters	7	47	2864	2	gaters
gawpers	13	44	831	2	gawpers
gazers	16	45	1630	2	gazers
goers	6	55	2025	2	goers
halers	9	49	2691	2	halers
hampers	14	36	1695	2	hampers
harpers	12	49	1620	2	harpers
haters	9	49	3040	2	haters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
heapers	12	36	1667	2	heapers
hers	7	58	4487	2	_hers
hoers	8	57	2492	2	hoers
hopers	11	42	2297	2	hopers
hypers	14	48	1191	2	hypers
jagers	14	44	1572	2	jagers
japer	14	62	1888	2	japer_
japery	18	43	914	2	japery
japes	14	63	2282	2	jape_s
jaspers	16	43	1046	2	jaspers
jeers	12	48	1813	2	jeers
kiers	9	53	2009	2	kiers
lacers	8	52	2525	2	lacers
laders	7	49	2776	2	laders
lagers	7	48	2614	2	lagers
lakers	10	52	2515	2	lakers
lampers	11	38	1733	2	lampers
lapels	8	37	1204	2	lapels
lappers	11	37	1746	2	lappers
lapsers	9	39	1105	2	lapsers
lasers	6	49	2570	2	lasers
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
leapers	9	37	1666	2	leapers
leers	5	48	2898	2	leers
lepers	8	48	1732	2	lepers
liers	5	51	3040	2	liers
lopers	8	44	2414	2	lopers
macers	10	53	2127	2	macers
makers	12	39	2173	2	makers
mappers	13	33	1378	2	mappers
masers	8	46	2345	2	masers
maters	8	50	3239	2	maters
mazers	17	39	1709	2	mazers
mopers	10	42	2037	2	mopers
namers	8	45	1733	2	namers
napery	11	48	981	2	napery
napes	7	48	2846	2	nape_s
nappers	11	42	1486	2	nappers
oaters	6	50	2979	2	oaters
omers	7	69	2319	2	omers
opens	7	61	1855	2	opens
opera	7	3	1357	2	opera
operas	8	3	1245	2	operas
opes	6	59	4261	2	ope_s
overs	8	52	2479	2	overs
oyers	8	76	2088	2	oyers
pacers	10	51	2454	2	pacers
pagers	9	44	2325	2	pagers
pairs	7	53	2583	2	pairs
pampers	13	36	1593	2	pampers
paper	9	51	2866	2	paper_
papery	13	48	1274	2	papery
parers	8	55	3074	2	parers
pares	7	71	6448	2	pares
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	_pars
paters	8	49	3583	2	paters
paupers	11	43	1107	2	paupers
pavers	11	50	2182	2	pavers
pawers	11	48	1878	2	pawers
payers	11	46	2182	2	payers
pears	7	51	3861	2	_pears
peas	6	57	5506	2	_peas
pecs	8	46	3410	2	_pecs
peds	7	58	3524	2	_peds
peers	7	51	3027	2	peers
pees	6	52	5737	2	_pees
pegs	7	55	3176	2	_pegs
pehs	9	56	2576	2	_pehs
pens	6	56	4964	2	_pens
peps	8	51	3451	2	_peps
per	5	63	5309	2	_per_
pere	6	64	5026	2	_pere
peres	7	62	4664	2	_peres
peri	6	56	3697	2	_peri
peris	7	55	3707	2	_peris
perk	10	62	3284	2	_perk
perks	11	53	2580	2	_perks
perm	8	58	3463	2	_perm
perms	9	55	2451	2	_perms
perp	8	90	2989	2	_perp
perps	9	55	2148	2	_perps
perse	7	54	2952	2	_perse
pert	6	67	5932	2	_pert
perv	9	72	2481	2	_perv
pervs	10	51	1737	2	_pervs
pes	5	72	5978	2	_pe_s
pets	6	62	4833	2	_pets
pews	9	57	3153	2	_pews
piers	7	59	2633	2	piers
pipers	10	43	1866	2	pipers
purs	6	56	4104	2	_purs
racers	8	47	2543	2	racers
rakers	10	41	2357	2	rakers
raper	7	49	3275	2	raper_
rapes	7	57	4072	2	rape_s
rapiers	9	50	1287	2	rapiers
rappers	11	36	1844	2	rappers
rasers	6	45	2678	2	rasers
raspers	9	44	1592	2	raspers
raters	6	39	3658	2	raters
ravers	9	46	2818	2	ravers
razers	15	49	1961	2	razers
reapers	9	35	2045	2	reapers
ropers	8	43	2590	2	ropers
ruers	5	150	1941	2	ruers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
sapors	8	41	1881	2	sapors
sappers	11	35	1890	2	sappers
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
seers	5	51	3638	2	seers
sers	4	57	4665	2	_sers
shapers	12	40	1689	2	shapers
soapers	9	37	1592	2	soapers
spars	7	54	3154	2	spars
spears	8	40	1947	2	spears
specs	9	69	1667	2	specs
speers	8	50	1995	2	speers
speirs	8	50	1323	2	speirs
sperm	9	32	1601	2	sperm
sperms	10	25	1260	2	sperms
spews	10	50	1592	2	spews
spiers	8	44	2174	2	spiers
spurs	7	46	2152	2	spurs
suers	5	51	2848	2	suers
supers	8	46	2240	2	supers
tabers	8	46	2157	2	tabers
takers	10	39	2374	2	takers
talers	6	46	2814	2	talers
tamers	8	42	2403	2	tamers
tampers	11	35	1674	2	tampers
taper	7	48	2977	2	taper_
tapes	7	58	3860	2	tape_s
tapirs	8	41	1317	2	tapirs
tappers	11	34	1654	2	tappers
taters	6	49	3220	2	taters
tawers	9	41	1860	2	tawers
taxers	13	40	1528	2	taxers
tiers	5	55	2652	2	tiers
topers	8	50	2532	2	topers
tyers	8	62	2005	2	tyers
uppers	10	29	1229	2	uppers
users	5	58	1757	2	users
vampers	14	31	1162	2	vampers
vapors	11	38	1269	2	vapors
veers	8	45	2136	2	veers
viers	8	56	2195	2	viers
vipers	11	49	1453	2	vipers
waders	10	91	2064	2	waders
wafers	12	43	1614	2	wafers
wagers	10	51	2220	2	wagers
wakers	13	48	2249	2	wakers
walers	9	48	2446	2	walers
warpers	12	34	1358	2	warpers
waters	9	50	3063	2	waters
wavers	12	50	2247	2	wavers
waxers	16	40	1430	2	waxers
wipers	11	54	1608	2	wipers
yagers	10	51	1453	2	yagers
yappers	14	40	1225	2	yappers
yaupers	12	33	766	2	yaupers
yawpers	15	34	685	2	yawpers
zappers	20	39	1163	2	zappers

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	53800	0.296	603685.8
2	DLD Change Limit	53800	313	1.906	28226.7
3	Display Results	313	313	0.080	3912.5
	(SQL Overall)	178691	313	2.282	78304.6