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

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

371 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
appear	10	37	934	(None)
appeal	10	39	1161	1	appeal
appears	11	30	895	1	appears
anear	5	54	2032	2	a_near
apeak	11	55	1345	2	a_peak
aper	6	63	3623	2	a_pe_r
apnea	7	34	1341	2	apnea_
apneal	8	34	1112	2	apneal
apneas	8	32	1138	2	apneas
appal	9	53	1522	2	app_al
appealer	12	4	574	2	appealer
appeals	11	37	867	2	appeals
appeared	13	3	614	2	appeared
appease	11	3	791	2	appease
appeaser	12	4	595	2	appeaser
appel	9	46	1589	2	appe_l
appels	10	43	1279	2	appels
append	11	3	827	2	append
apter	7	61	2020	2	apte_r
arrear	6	3	1025	2	arrear
asper	7	55	2043	2	aspe_r
capper	12	44	2198	2	cappe_r
coappear	14	4	289	2	coappear
dapper	11	40	1663	2	dappe_r
lapper	10	43	1995	2	lappe_r
mapper	12	45	1609	2	mappe_r
napper	10	37	1828	2	nappe_r
paper	9	51	2866	2	pape_r
pear	6	97	4523	2	__pear
rapper	10	46	2157	2	rappe_r
reappear	12	4	262	2	reappear
sapper	10	38	2235	2	sappe_r
spear	7	58	2106	2	_spear
tapper	10	44	1961	2	tappe_r
upbear	10	9	649	2	upbear
upper	9	37	1426	2	uppe_r
uprear	8	16	879	2	uprear
uptear	8	9	678	2	uptear
yapper	13	37	1451	2	yappe_r
zapper	19	34	1402	2	zappe_r
abeam	9	3	1653	3	a_beam
abler	7	56	2431	3	able_r
acinar	8	3	1048	3	acinar
adder	7	54	1959	3	adde_r
afar	7	67	2078	3	a__far
afeard	10	5	826	3	a_feard
after	8	57	1979	3	afte_r
agar	5	87	2641	3	a__gar
ager	5	59	3584	3	a_ge_r
agger	7	64	2089	3	agge_r
agleam	9	15	862	3	agleam
ahead	9	68	1705	3	a_head
aider	6	54	3113	3	aide_r
aimer	7	59	2682	3	aime_r
airer	5	49	2789	3	aire_r
aiver	8	57	2516	3	aive_r
ajar	11	62	1770	3	a__jar
alar	4	63	4007	3	a__lar
alder	6	54	2191	3	alde_r
alegar	7	3	928	3	alegar
almemar	11	4	430	3	almemar
alpha	10	4	965	3	alpha_
alphas	11	3	951	3	alphas
altar	5	55	2064	3	a_ltar
alter	5	48	2850	3	alte_r
alular	6	3	1135	3	alular
ambeer	10	45	1160	3	ambeer
amber	9	45	2321	3	ambe_r
ameer	7	56	1898	3	a_meer
amped	10	48	2051	3	ampe_d
ampere	10	5	1441	3	ampere
ampler	10	43	1330	3	ampler
anears	6	37	1718	3	a_nears
anger	6	62	2588	3	ange_r
anneal	6	48	1230	3	anneal
antbear	9	3	506	3	antbear
antiar	6	3	1717	3	antiar
apart	7	43	3067	3	a_p_art
ape	5	72	5118	3	a_pe__
aped	7	85	3815	3	a_pe_d
apeek	11	47	1187	3	a_peek
apers	7	66	2913	3	a_pers
apery	10	65	1790	3	a_pery
apes	6	60	4743	3	a_pe_s
apex	13	72	2021	3	a_pe_x
apian	7	50	1833	3	a_pian
apiary	11	39	1038	3	a_piary
apical	10	9	1390	3	apical
apiece	10	5	1008	3	apiece
apneic	10	7	862	3	apneic
apnoea	8	6	709	3	apnoea_
apnoeal	9	5	619	3	apnoeal
apnoeas	9	4	635	3	apnoeas
apocarp	13	5	513	3	apocarp
apodal	9	28	983	3	apodal
apogeal	10	4	562	3	apogeal
apogean	10	4	544	3	apogean
app	7	68	2760	3	app___
appall	10	37	974	3	appall
appals	10	48	1294	3	appals
apparat	11	7	1171	3	apparat
apparel	11	4	600	3	app_arel
appealed	13	3	560	3	appealed
appealers	13	4	506	3	appealers
appearing	14	3	689	3	appear~~ing~~
appeased	13	3	579	3	appeased
appeasers	13	4	526	3	appeasers
appeases	12	3	866	3	appeases
appellor	12	4	357	3	appellor
appends	12	3	639	3	appends
appestat	12	4	671	3	appestat
applaud	12	9	390	3	applaud
apple	9	45	1767	3	app_le
applecart	15	5	360	3	applecart
apples	10	43	1576	3	apples
applet	10	59	1743	3	applet
applets	11	57	1006	3	applets
applier	11	3	790	3	applier
apply	12	51	1139	3	app_ly
appose	10	4	1199	3	appose
apposer	11	4	748	3	apposer
apps	8	63	1969	3	app__s
apres	7	54	2640	3	apre_s
apse	6	77	2538	3	apse__
apses	7	68	2391	3	apse_s
apteral	9	3	1152	3	apteral
aptest	8	29	1751	3	aptest
area	4	58	4339	3	a_rea_
areae	5	52	2974	3	a_reae
areal	5	59	2873	3	a_real
areas	5	59	3577	3	a_reas
arepa	7	56	1556	3	arepa_
arepas	8	55	1570	3	arepas
armer	7	69	2444	3	arme_r
arpen	7	44	1804	3	arpe_n
arpens	8	48	1482	3	arpens
arpent	8	48	2209	3	arpent
arrears	7	3	884	3	arrears
asea	4	63	2718	3	a_sea_
ashlar	9	33	819	3	ashlar
asker	9	64	1878	3	aske_r
aspect	10	6	1282	3	aspect
aspen	7	52	1609	3	aspe_n
aspens	8	50	1335	3	aspens
aspers	8	62	2031	3	aspers
aster	5	54	3489	3	aste_r
attar	5	65	1669	3	a_ttar
auger	6	49	2247	3	auge_r
aurar	5	44	2025	3	a_urar
auteur	6	10	795	3	auteur
avatar	9	3	752	3	avatar
aver	7	59	3188	3	a_ve_r
aweary	12	3	730	3	a_weary
bear	6	68	4464	3	__bear
blear	7	59	1868	3	_blear
bopper	12	38	1383	3	boppe_r
camper	12	47	2221	3	campe_r
caper	9	48	3162	3	cape_r
capped	13	47	2185	3	cappe_d
cappers	13	44	1940	3	cappers
carper	10	49	2363	3	carpe_r
clapper	13	40	1186	3	clappe_r
clear	7	62	1905	3	_clear
coappears	15	4	295	3	coappears
coper	9	53	3609	3	cope_r
copper	12	43	2189	3	coppe_r
crapper	13	39	1319	3	crappe_r
cupper	12	43	1386	3	cuppe_r
damper	11	41	1775	3	dampe_r
dapped	12	45	1676	3	dappe_d
dapperer	13	3	576	3	dapperer
dear	5	53	4360	3	__dear
dipper	11	40	1779	3	dippe_r
disappear	14	4	249	3	~~dis~~appear
dogear	8	3	819	3	dogear
doper	8	61	2839	3	dope_r
drear	6	50	1690	3	_drear
duper	8	55	1900	3	dupe_r
ear	3	68	6788	3	___ear
endear	7	41	1001	3	endear
fear	7	53	3779	3	__fear
flapper	14	35	920	3	flappe_r
gaper	8	61	2512	3	gape_r
gapped	12	42	1712	3	gappe_d
gappier	12	36	984	3	gappier
gasper	9	45	1554	3	gaspe_r
gawper	12	49	969	3	gawpe_r
gear	5	59	3497	3	__gear
gipper	11	42	1530	3	gippe_r
gypper	14	34	729	3	gyppe_r
hamper	13	45	1865	3	hampe_r
happed	14	48	2010	3	happe_d
happen	13	48	1219	3	happe_n
happens	14	35	917	3	happens
happier	14	33	1204	3	happier
harper	11	50	1840	3	harpe_r
hear	7	61	4388	3	__hear
hepper	13	34	1266	3	heppe_r
hipper	13	38	1802	3	hippe_r
hoper	10	58	2914	3	hope_r
hopper	13	42	1848	3	hoppe_r
hyper	13	52	1390	3	hype_r
impearl	11	5	445	3	impearl
japer	14	62	1888	3	jape_r
jasper	15	46	1038	3	jaspe_r
kappa	13	46	974	3	kapp_a_
kappas	14	44	1036	3	kapp_as
kipper	14	34	1421	3	kippe_r
knapper	15	38	715	3	knappe_r
lapped	11	43	2003	3	lappe_d
lappers	11	37	1746	3	lappers
lappet	10	38	1773	3	lappe_t
lappets	11	32	913	3	lappets
lapser	8	41	1314	3	lapse_r
lear	4	70	4595	3	__lear
leper	7	48	2074	3	lepe_r
linear	6	51	1334	3	linear
lipper	10	42	1963	3	lippe_r
loper	7	51	2923	3	lope_r
lopper	10	37	1720	3	loppe_r
mapped	13	40	1588	3	mappe_d
mappers	13	33	1378	3	mappers
moper	9	49	2592	3	mope_r
mopper	12	62	1500	3	moppe_r
nappa	9	85	1186	3	napp_a_
nappas	10	55	1161	3	napp_as
nappe	9	61	1499	3	nappe__
napped	11	42	1816	3	nappe_d
nappers	11	42	1486	3	nappers
nappes	10	45	1562	3	nappe_s
nappier	11	44	1117	3	nappier
near	4	52	3650	3	__near
nipper	10	37	1571	3	nippe_r
opera	7	3	1357	3	_opera
pacer	9	61	3161	3	pace_r
paean	7	72	2272	3	_paean
pager	8	47	2820	3	page_r
palea	7	50	2866	3	palea_
paleae	8	48	2029	3	paleae
paleal	8	47	1667	3	paleal
paler	7	54	3693	3	pale_r
palmar	10	41	1346	3	palmar
pampean	13	3	554	3	pampean
pamper	12	43	1666	3	pampe_r
papa	8	58	2714	3	pap_a_
papal	9	58	2067	3	pap_al
papas	9	49	2749	3	pap_as
papaw	12	51	1249	3	pap_aw
paperer	11	31	1190	3	paperer
papers	10	51	2532	3	papers
papery	13	48	1274	3	papery
pappier	10	35	1160	3	pappier
papular	11	29	976	3	papular
par	5	74	6702	3	__p_ar
parer	7	58	3990	3	pare_r
pater	7	47	4072	3	pate_r
pauper	10	35	1194	3	paupe_r
paver	10	42	2583	3	pave_r
pawer	10	44	2297	3	pawe_r
payer	10	51	2572	3	paye_r
pea	5	66	5724	3	__pea_
peag	7	54	3134	3	__peag
peak	10	65	3520	3	__peak
peal	6	86	4810	3	__peal
pean	6	61	4717	3	__pean
pearl	7	53	2446	3	__pearl
pears	7	51	3861	3	__pears
peart	7	64	4075	3	__peart
peas	6	57	5506	3	__peas
peat	6	59	6793	3	__peat
peer	6	62	3835	3	__peer
pepper	9	35	1294	3	peppe_r
per	5	63	5309	3	__pe_r
pier	6	60	3529	3	_pie_r
pilar	7	52	2150	3	_pilar
piper	9	65	2319	3	pipe_r
plea	6	68	3060	3	_plea_
plead	8	58	1846	3	_plead
pleas	7	56	2703	3	_pleas
pleat	7	47	3447	3	_pleat
polar	7	56	2345	3	_polar
poplar	10	36	1111	3	poplar
popper	9	36	1596	3	poppe_r
prearm	10	45	1235	3	_prearm
prewar	11	47	1258	3	_prewar
raper	7	49	3275	3	rape_r
rapier	8	40	1999	3	rapie_r
rapped	11	41	2268	3	rappe_d
rappee	10	36	1867	3	rappe_e
rappees	11	36	1145	3	rappees
rappel	10	42	1195	3	rappe_l
rappels	11	44	880	3	rappels
rappen	10	35	1271	3	rappe_n
rappers	11	36	1844	3	rappers
rasper	8	39	1733	3	raspe_r
reappears	13	4	285	3	reappears
rear	4	56	4455	3	__rear
redear	7	35	1517	3	redear
regear	7	35	1274	3	regear
rehear	9	37	1322	3	rehear
repeal	8	47	1829	3	repeal
repeat	8	51	2721	3	repeat
retear	6	31	1548	3	retear
rewear	9	30	1200	3	rewear
riper	7	43	2840	3	ripe_r
ripper	10	35	1865	3	rippe_r
roper	7	54	3191	3	rope_r
saphead	13	5	777	3	saphead
sapped	11	44	2201	3	sappe_d
sappers	11	35	1890	3	sappers
sappier	11	36	1312	3	sappier
sear	4	73	5384	3	__sear
shear	8	54	2483	3	_shear
shmear	11	7	693	3	shmear
sipper	10	39	2099	3	sippe_r
slapper	11	35	1247	3	slappe_r
smear	7	44	1639	3	_smear
snapper	11	35	1207	3	snappe_r
spar	6	54	3330	3	_sp_ar
speak	11	46	1867	3	_speak
spean	7	46	2051	3	_spean
spears	8	40	1947	3	_spears
speer	7	46	2390	3	_speer
speir	7	53	1536	3	_speir
spier	7	57	2803	3	spie_r
spread	9	3	1253	3	spread
super	7	49	2448	3	supe_r
supper	10	41	1543	3	suppe_r
swapper	14	35	970	3	swappe_r
swear	8	53	1685	3	_swear
tamper	10	46	1851	3	tampe_r
taper	7	48	2977	3	tape_r
tapped	11	38	2005	3	tappe_d
tappers	11	34	1654	3	tappers
tappet	10	38	2011	3	tappe_t
tappets	11	36	1001	3	tappets
tear	4	52	4288	3	__tear
tipper	10	39	1841	3	tippe_r
toper	7	52	3102	3	tope_r
topper	10	38	1760	3	toppe_r
trappean	12	4	439	3	trappean
trapper	11	39	1280	3	trappe_r
typebar	14	4	299	3	typebar
unbear	8	8	916	3	unbear
upbears	11	9	542	3	upbears
upbeat	10	9	1151	3	upbeat
upheap	13	10	521	3	upheap
upleap	10	10	684	3	upleap
upped	10	37	1516	3	uppe_d
uppers	10	29	1229	3	uppers
uprears	9	10	749	3	uprears
uproar	8	10	693	3	uproar
upsoar	8	10	568	3	upsoar
uptears	9	10	645	3	uptears
vamper	13	42	1265	3	vampe_r
viper	10	50	1730	3	vipe_r
wapped	14	44	1647	3	wappe_d
warper	11	40	1558	3	warpe_r
wear	7	58	3672	3	__wear
whapper	17	34	827	3	whappe_r
wiper	10	54	2129	3	wipe_r
wrapper	14	36	833	3	wrappe_r
yapped	14	44	1514	3	yappe_d
yappers	14	40	1225	3	yappers
yauper	11	36	854	3	yaupe_r
yawper	14	43	795	3	yawpe_r
year	7	65	3425	3	__year
zapped	20	42	1352	3	zappe_d
zappers	20	39	1163	3	zappers
zappier	20	45	837	3	zappier
zipper	19	38	1312	3	zippe_r

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	112716	0.390	458182.1
2	DLD Change Limit	112716	371	5.780	19501.0
3	Display Results	371	371	0.126	2944.4
	(SQL Overall)	178691	371	6.296	28381.7