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

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

301 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
preppy	12	3	552	(None)
peppy	11	43	1036	1	p_eppy
prepay	13	3	1031	1	prepay
crappy	15	44	680	2	crappy
creepy	13	41	880	2	creepy
crepey	13	51	1093	2	crepey
crepy	12	48	1270	2	cre_py
drippy	14	44	565	2	drippy
grippy	14	44	776	2	grippy
pappy	11	47	1380	2	p_appy
poppy	11	48	1319	2	p_oppy
preapply	14	4	330	2	preapply
prebuy	13	5	742	2	prebuy
predry	12	3	787	2	predry
preop	9	47	1587	2	preop_
preops	10	49	1194	2	preops
prep	8	64	2767	2	pre_p_
prepays	14	3	748	2	prepays
prepped	11	32	990	2	prepped
preppie	10	5	809	2	preppie
preppily	14	4	459	2	preppily
preps	9	62	2069	2	pre_ps
prepupa	10	6	402	2	prepupa
pretty	11	5	1087	2	pretty
prexy	17	46	1158	2	pre_xy
prey	9	62	2848	2	pre__y
puppy	11	49	1241	2	p_uppy
repay	10	48	1845	2	_repay
reply	10	40	1585	2	_reply
repp	8	54	1874	2	_repp_
repps	9	51	1434	2	_repps
trippy	13	45	780	2	trippy
arepa	7	56	1556	3	are_pa
arepas	8	55	1570	3	arepas
bready	12	45	1118	3	bready
breezy	20	29	585	3	breezy
buppy	14	48	1007	3	_buppy
chippy	18	43	761	3	chippy
choppy	18	37	629	3	choppy
crampy	15	47	1099	3	crampy
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
creep	9	52	1810	3	creep_
creeps	10	42	1362	3	creeps
crepe	9	55	2072	3	cre_pe
creped	11	41	1571	3	creped
crepes	10	54	1934	3	crepes
crepon	10	3	994	3	crepon
crept	9	51	2589	3	cre_pt
cressy	11	43	911	3	cressy
crimpy	15	48	939	3	crimpy
crispy	13	47	856	3	crispy
croupy	13	45	873	3	croupy
cuppy	14	47	1038	3	_cuppy
deeply	12	5	701	3	deeply
dippy	13	51	1154	3	_dippy
drapey	12	50	1058	3	drapey
dreamy	12	50	999	3	dreamy
dreary	10	46	1167	3	dreary
drecky	16	48	633	3	drecky
dreggy	12	36	463	3	dreggy
dressy	10	51	814	3	dressy
droopy	12	45	824	3	droopy
dropsy	12	49	747	3	dropsy
espy	9	6	937	3	__espy
flappy	16	5	448	3	flappy
flippy	16	5	461	3	flippy
floppy	16	5	487	3	floppy
frappe	13	28	695	3	frappe
freaky	16	43	923	3	freaky
freely	12	3	1096	3	freely
frenzy	21	3	588	3	frenzy
fretty	12	4	922	3	fretty
frumpy	16	46	688	3	frumpy
gappy	13	62	1203	3	_gappy
gloppy	14	5	472	3	gloppy
grapey	12	60	1230	3	grapey
grappa	11	39	644	3	grappa
grapy	11	54	1643	3	gr_apy
greasy	10	41	946	3	greasy
greedy	11	51	885	3	greedy
greeny	10	48	1145	3	greeny
gremmy	14	5	447	3	gremmy
grey	8	56	2404	3	gre__y
greyly	13	31	654	3	greyly
gripey	12	41	1120	3	gripey
grippe	11	53	1032	3	grippe
gripy	11	51	1525	3	gr_ipy
grumpy	14	49	815	3	grumpy
guppy	13	52	1127	3	_guppy
happy	15	58	1353	3	_happy
heapy	13	59	1498	3	_heapy
hempy	15	49	1276	3	_hempy
hippy	15	51	1279	3	_hippy
hoppy	15	49	1235	3	_hoppy
kelpy	14	51	1068	3	_kelpy
kreep	11	46	1041	3	kreep_
kreeps	12	42	741	3	kreeps
lippy	12	45	1190	3	_lippy
loppy	12	59	1166	3	_loppy
nappy	12	63	1233	3	_nappy
nippy	12	49	1111	3	_nippy
papery	13	48	1274	3	papery
pappi	8	48	1089	3	p_appi
peaky	14	57	1815	3	p_eaky
peaty	10	57	2569	3	p_eaty
peavy	13	50	1484	3	p_eavy
pecky	16	55	1509	3	p_ecky
peep	8	58	3369	3	p_eep_
peeped	11	39	1539	3	peeped
peeper	10	36	1480	3	peeper
peeps	9	58	2236	3	p_eeps
peepul	10	3	578	3	peepul
peery	10	57	1944	3	p_eery
penny	10	51	1945	3	p_enny
peony	10	57	1756	3	p_eony
pep	7	64	4708	3	p_e_p_
pepla	9	3	1286	3	p_epla
pepo	8	76	2215	3	p_e_po
pepos	9	66	2008	3	p_epos
pepped	10	31	1340	3	p_epped
pepper	9	35	1294	3	p_epper
peppery	13	28	625	3	p_eppery
peppily	13	3	513	3	p_eppily
peps	8	51	3451	3	p_e_ps
perdy	11	54	1733	3	p_erdy
perky	14	53	1948	3	p_erky
peroxy	18	3	825	3	peroxy
perp	8	90	2989	3	p_erp_
perps	9	55	2148	3	p_erps
perry	10	52	2271	3	p_erry
pertly	11	53	1255	3	pertly
pesky	14	59	1156	3	p_esky
pesty	10	64	2171	3	p_esty
petty	10	53	2029	3	p_etty
phrensy	15	3	362	3	phrensy
piety	10	58	1730	3	pie_ty
pimply	15	32	921	3	pimply
pipy	11	54	2151	3	p__ipy
plenty	11	3	1141	3	plenty
poesy	10	50	1406	3	poe_sy
poetry	11	3	938	3	poetry
popery	13	45	1170	3	popery
poppa	8	40	989	3	p_oppa
popsy	12	57	1340	3	p_opsy
pray	9	63	3153	3	pr__ay
preach	13	36	1392	3	preach
preachy	17	30	731	3	preachy
preact	10	32	2039	3	preact
preamp	12	3	899	3	preamp
preamps	13	3	661	3	preamps
prearm	10	45	1235	3	prearm
prebid	11	35	1284	3	prebid
prebuys	14	4	439	3	prebuys
precept	13	31	1251	3	precept
precipe	13	30	1212	3	precipe
precis	10	34	1670	3	precis
precut	10	20	1653	3	precut
pree	6	70	4473	3	pre__e
preed	8	51	2812	3	pre_ed
preempt	13	3	772	3	preempt
preen	7	59	2505	3	pre_en
preens	8	50	2011	3	preens
prees	7	59	3717	3	pre_es
prefab	13	3	624	3	prefab
prefer	11	38	1320	3	prefer
prefix	18	35	685	3	prefix
prelacy	14	3	758	3	prelacy
prelaw	11	3	910	3	prelaw
prelim	10	3	1142	3	prelim
preman	10	41	1745	3	preman
premed	11	46	1776	3	premed
premen	10	50	1780	3	premen
premie	10	36	1799	3	premie
premix	17	37	1033	3	premix
prepack	17	5	764	3	prepack
prepaid	12	3	1013	3	prepaid
prepare	11	19	1362	3	prepare
prepave	14	22	887	3	prepave
prepill	11	4	758	3	prepill
preplan	11	4	995	3	preplan
preppier	11	5	664	3	preppier
preppies	11	4	969	3	preppies
prepping	12	30	976	3	prepping
prepreg	12	16	596	3	prepreg
prepuce	13	3	783	3	prepuce
prepupae	11	4	464	3	prepupae
prepupal	11	6	426	3	prepupal
prepupas	11	4	413	3	prepupas
presa	7	43	1904	3	pre_sa
prese	7	52	2838	3	pre_se
preset	8	44	3098	3	preset
press	7	54	2595	3	pre_ss
prest	7	57	3635	3	pre_st
presto	8	42	1620	3	presto
prests	8	40	2126	3	prests
pretape	11	35	1162	3	pretape
pretax	15	23	1019	3	pretax
pretor	8	3	1575	3	pretor
pretype	14	38	748	3	pretype
prevue	11	7	916	3	prevue
prewar	11	47	1258	3	prewar
prex	13	57	2297	3	pre__x
prexes	15	49	1595	3	prexes
preyed	12	53	1320	3	preyed
preyer	11	44	1373	3	preyer
preys	10	57	1778	3	pre_ys
prez	15	61	2631	3	pre__z
prezes	17	36	1469	3	prezes
priapi	10	3	792	3	priapi
pricey	13	44	1263	3	pricey
pricky	17	42	1034	3	pricky
pricy	12	48	1456	3	pr_icy
primly	13	43	962	3	primly
primp	11	56	1592	3	primp_
primps	12	47	1182	3	primps
priory	11	41	1026	3	priory
prissy	11	34	785	3	prissy
privy	13	43	983	3	pr_ivy
prompt	12	3	1301	3	prompt
prop	8	59	3281	3	pr_op_
propel	10	37	1406	3	propel
proper	10	43	1995	3	proper
propped	11	33	1196	3	propped
props	9	57	2688	3	pr_ops
propyl	13	35	818	3	propyl
prosy	10	63	1925	3	pr_osy
proxy	17	50	1101	3	pr_oxy
pry	8	57	2805	3	pr___y
pulpy	12	46	1236	3	p_ulpy
purely	11	40	1363	3	pure_ly
purply	13	36	905	3	purply
quippy	22	38	426	3	quippy
raspy	10	65	1170	3	_raspy
ready	9	48	2150	3	_ready
reap	6	59	3474	3	_reap_
reapply	14	3	432	3	_reapply
reaps	7	56	2619	3	_reaps
rebuy	10	47	1468	3	_rebuy
recopy	13	3	904	3	_recopy
redly	9	42	1720	3	_redly
redry	9	43	1436	3	_redry
reedy	9	100	2029	3	_reedy
reefy	11	42	1770	3	_reefy
reeky	12	54	1626	3	_reeky
refly	11	39	1456	3	_refly
refry	11	44	1246	3	_refry
reify	11	48	1497	3	_reify
rekey	12	40	1473	3	_rekey
relay	8	44	2467	3	_relay
rely	7	54	2895	3	_re_ly
rep	5	58	4780	3	_re_p_
repays	11	38	1397	3	_repays
repeg	8	40	1505	3	_repeg
repel	7	49	2140	3	_repel
repin	7	53	2470	3	_repin
replay	11	34	1292	3	_replay
repo	6	60	2754	3	_re_po
repos	7	47	2579	3	_repos
repot	7	51	3262	3	_repot
repped	11	46	1672	3	_repped
repro	7	53	1591	3	_repro
reps	6	59	3795	3	_re_ps
resay	8	53	2054	3	_resay
retry	8	47	1808	3	_retry
ripply	13	34	800	3	_ripply
ropey	10	60	2187	3	_ropey
ropy	9	63	2341	3	_r_opy
roupy	10	61	1271	3	_roupy
sappy	12	54	1347	3	_sappy
scrappy	16	23	447	3	scrappy
seepy	10	47	1797	3	_seepy
sepoy	10	3	1430	3	_sepoy
sleepy	11	47	941	3	sleepy
slippy	13	7	584	3	slippy
sloppy	13	9	530	3	sloppy
snappy	13	6	610	3	snappy
snippy	13	7	484	3	snippy
soppy	12	51	1352	3	_soppy
steppe	10	31	987	3	steppe
strappy	14	20	526	3	strappy
stroppy	14	20	509	3	stroppy
sweepy	14	44	745	3	sweepy
tepoy	10	3	1216	3	_tepoy
tippy	12	54	1179	3	_tippy
trampy	13	49	925	3	trampy
treaty	9	44	1435	3	treaty
trebly	11	3	897	3	trebly
trendy	10	46	960	3	trendy
trepan	8	25	1167	3	trepan
trepid	9	3	1008	3	trepid
tressy	9	44	855	3	tressy
trey	7	72	2879	3	tre__y
triply	11	42	1102	3	triply
trophy	14	3	828	3	trophy
weepy	13	42	1259	3	_weepy
whippy	19	38	584	3	whippy
yuppy	15	48	791	3	_yuppy
zappy	21	54	894	3	_zappy
zippy	21	51	874	3	_zippy

Search took 13 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.763	234195.3
2	DLD Change Limit	112716	301	11.050	10200.5
3	Display Results	301	301	0.186	1618.3
	(SQL Overall)	178691	301	11.999	14892.2