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

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

257 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
prepave	14	22	887	(None)
prepare	11	19	1362	1	prepare
prepaved	16	17	723	1	prepaved
prepaves	15	18	919	1	prepaves
repave	11	48	1387	1	_repave
greave	10	46	1149	2	gre_ave
preaver	12	10	1161	2	pre_aver
prebade	12	3	1028	2	prebade
prebake	15	3	909	2	prebake
precava	14	4	509	2	precava
precavae	15	4	481	2	precavae
predate	10	6	1689	2	predate
predive	13	5	1108	2	predive
preface	14	5	1092	2	preface
prefade	13	3	901	2	prefade
pregame	12	3	955	2	pregame
prelate	9	5	1969	2	prelate
premade	12	3	1144	2	premade
prename	11	4	1264	2	prename
prepack	17	5	764	2	prepack
prepaid	12	3	1013	2	prepaid
prepared	13	22	1087	2	prepared
preparer	12	16	964	2	preparer
prepares	12	20	1416	2	prepares
prepaste	12	13	908	2	prepaste
prepay	13	3	1031	2	prepa_y
prepays	14	3	748	2	prepays
preplace	14	8	898	2	preplace
preppie	10	5	809	2	preppie
prepuce	13	3	783	2	prepuce
prerace	11	4	1412	2	prerace
presage	10	3	1229	2	presage
presale	9	4	1635	2	presale
pretape	11	35	1162	2	pretape
propane	11	27	1615	2	propane
reave	8	45	2802	2	_re_ave
regave	10	47	1338	2	_regave
repaved	13	33	1113	2	_repaved
repaves	12	35	1365	2	_repaves
areae	5	52	2974	3	are_a_e
arepa	7	56	1556	3	arepa__
arepas	8	55	1570	3	arepa_s
behave	14	20	901	3	_behave
bereave	12	5	835	3	bereave
brave	10	49	2550	3	br__ave
breve	10	53	1705	3	bre__ve
brewage	13	4	718	3	brewage
cleave	11	42	1251	3	cle_ave
crave	10	56	2631	3	cr__ave
crease	8	55	1957	3	cre_ase
create	8	51	2638	3	cre_ate
creepage	13	4	434	3	creepage
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
crepe	9	55	2072	3	crep__e
deave	9	50	2233	3	_de_ave
deprave	13	3	707	3	_deprave
drave	9	52	1927	3	dr__ave
eave	7	57	3358	3	__e_ave
grave	9	46	2487	3	gr__ave
grease	7	54	1623	3	gre_ase
greaved	12	40	891	3	gre_aved
greaves	11	33	1144	3	gre_aves
grenade	9	3	841	3	grenade
heave	11	45	2181	3	_he_ave
leave	8	47	2372	3	_le_ave
palpate	11	32	1392	3	palpate
pareve	11	46	1301	3	pare__ve
pave	9	61	3389	3	___pave
peace	9	50	2608	3	p_e_ace
peage	8	47	2357	3	p_e_age
pease	7	52	3111	3	p_e_ase
peavey	14	39	879	3	p_e_avey
peavy	13	50	1484	3	p_e_avy
pedate	9	31	1776	3	p_edate
peerage	10	8	980	3	peerage
peeve	10	49	1525	3	p_e_eve
pelage	9	5	1536	3	p_elage
percale	11	3	1409	3	percale
pervade	13	3	702	3	pervade
pesade	9	3	1110	3	p_esade
phenate	12	4	1220	3	phenate
pipage	11	9	914	3	p_ipage
pipeage	12	3	620	3	pipeage
please	8	43	1573	3	ple_ase
prase	7	61	2875	3	pr__ase
prate	7	51	3598	3	pr__ate
preach	13	36	1392	3	pre_ach
preact	10	32	2039	3	pre_act
preaged	11	6	1233	3	pre_aged
preamp	12	3	899	3	pre_amp
prearm	10	45	1235	3	pre_arm
preavers	13	9	1026	3	pre_avers
prebaked	17	3	717	3	prebaked
prebakes	16	3	901	3	prebakes
precast	11	3	1485	3	precast
precative	16	3	1257	3	precative
precaval	15	4	472	3	precaval
precede	12	3	965	3	precede
precipe	13	30	1212	3	precipe
precise	11	35	1817	3	precise
precode	12	3	1185	3	precode
precure	11	3	1255	3	precure
predated	12	5	1327	3	predated
predates	11	6	1581	3	predates
predawn	13	3	535	3	predawn
pree	6	70	4473	3	pre___e
preemie	11	3	1056	3	preemie
prefab	13	3	624	3	prefa_b
prefabs	14	3	516	3	prefabs
prefaced	16	3	842	3	prefaced
prefacer	15	3	798	3	prefacer
prefaces	15	3	1106	3	prefaces
prefaded	15	3	782	3	prefaded
prefades	14	3	953	3	prefades
prefile	12	34	1318	3	prefile
prefire	12	40	1281	3	prefire
preflame	15	4	591	3	preflame
pregames	13	3	900	3	pregames
prelacy	14	3	758	3	prelacy
prelates	10	4	1857	3	prelates
prelaw	11	3	910	3	prela_w
prelife	12	7	995	3	prelife
prelives	13	3	1038	3	prelives
prelude	10	3	801	3	prelude
preman	10	41	1745	3	prema_n
premie	10	36	1799	3	pre_mie
premise	11	38	1855	3	premise
premune	11	3	893	3	premune
prenames	12	3	1164	3	prenames
prep	8	64	2767	3	prep___
prepacked	20	15	565	3	prepacked
prepacks	18	3	658	3	prepacks
preparers	13	19	767	3	preparers
prepasted	14	13	767	3	prepasted
prepastes	13	12	882	3	prepastes
prepaving	17	8	723	3	prepaving
prepense	12	23	894	3	prepense
prepill	11	4	758	3	prepill
preplaced	16	7	648	3	preplaced
preplaces	15	7	875	3	preplaces
preplan	11	4	995	3	preplan
preplans	12	4	961	3	preplans
preplant	12	7	1291	3	preplant
prepped	11	32	990	3	prepped
preppier	11	5	664	3	preppier
preppies	11	4	969	3	preppies
preppy	12	3	552	3	prep_py
prepreg	12	16	596	3	prepreg
preprice	14	8	887	3	preprice
preps	9	62	2069	3	prep__s
prepubes	14	3	605	3	prepubes
prepuces	14	3	858	3	prepuces
prepupa	10	6	402	3	prepupa
prepupae	11	4	464	3	prepupae
presa	7	43	1904	3	presa__
presaged	12	3	881	3	presaged
presager	11	3	844	3	presager
presages	11	3	1220	3	presages
presales	10	3	1526	3	presales
prese	7	52	2838	3	pre__se
preserve	13	10	880	3	preserve
preshape	15	3	753	3	preshape
preside	10	7	1561	3	preside
presolve	13	4	707	3	presolve
presume	11	3	1030	3	presume
pretaped	13	33	913	3	pretaped
pretapes	12	28	1153	3	pretapes
pretaste	10	13	952	3	pretaste
pretax	15	23	1019	3	preta_x
pretravel	14	4	412	3	pretravel
pretype	14	38	748	3	pretype
prevail	12	3	824	3	prevail
prevalue	13	4	507	3	prevalue
previse	12	37	1379	3	previse
prevue	11	7	916	3	pre_vue
prewar	11	47	1258	3	prewa_r
prewarm	14	47	961	3	prewarm
prewarn	12	44	1015	3	prewarn
prewash	15	3	521	3	prewash
prewire	12	43	1114	3	prewire
primage	12	16	914	3	primage
primate	11	15	1628	3	primate
private	12	15	1326	3	private
probate	11	4	1448	3	probate
profane	12	21	1186	3	profane
prolate	9	4	1979	3	prolate
pronate	9	4	1887	3	pronate
propanes	12	24	1582	3	propanes
propene	11	27	1604	3	propene
prophage	16	4	943	3	prophage
prophase	15	4	1024	3	prophase
propine	11	30	2021	3	propine
propone	11	27	1630	3	propone
propose	11	27	1484	3	propose
prorate	9	4	1873	3	prorate
prove	10	48	2319	3	pr__ove
pupae	9	65	1564	3	p_upa_e
pupate	10	42	1312	3	p_upate
rave	7	55	4209	3	_r__ave
reaved	10	45	2392	3	_re_aved
reaver	9	45	2473	3	_re_aver
reaves	9	41	2757	3	_re_aves
rebate	8	44	2411	3	_rebate
recane	8	30	2287	3	_recane
redate	7	41	2468	3	_redate
reeve	8	41	2132	3	_re_eve
reface	11	36	1635	3	_reface
regale	7	48	2145	3	_regale
regive	10	48	1432	3	_regive
reive	8	55	2294	3	_re_ive
relace	8	31	2215	3	_relace
relate	6	40	3363	3	_relate
releve	9	51	1640	3	_releve
relive	9	51	2078	3	_relive
remade	9	43	1698	3	_remade
remake	12	40	1611	3	_remake
remate	8	44	2868	3	_remate
remove	11	61	1557	3	_remove
rename	8	27	1881	3	_rename
repack	14	24	1216	3	_repack
repaid	9	47	1632	3	_repaid
repair	8	40	1146	3	_repair
repand	9	53	1606	3	_repand
repanel	9	3	996	3	_repanel
repaper	11	3	1002	3	_repaper
repark	12	35	1171	3	_repark
repass	8	41	1470	3	_repass
repast	8	35	2063	3	_repast
repay	10	48	1845	3	_repa_y
repays	11	38	1397	3	_repays
repine	8	56	2781	3	_repine
replace	11	32	1428	3	_replace
replate	9	34	2005	3	_replate
repose	8	41	2141	3	_repose
reprove	12	29	1107	3	_reprove
repute	8	47	1609	3	_repute
resale	6	40	2554	3	_resale
reshave	13	3	860	3	_reshave
respace	11	3	1091	3	_respace
respade	10	3	957	3	_respade
retake	10	47	1853	3	_retake
retape	8	39	1768	3	_retape
revive	12	49	1482	3	_revive
rewake	13	52	1846	3	_rewake
reweave	13	3	677	3	_reweave
rewove	12	64	2008	3	_rewove
seepage	10	3	754	3	seepage
sheave	12	45	1400	3	she_ave
sleave	9	47	1415	3	sle_ave
trave	8	52	2303	3	tr__ave
trepan	8	25	1167	3	trepa_n
trepang	10	25	729	3	trepang
trepans	9	23	1159	3	trepans
upheave	15	4	402	3	uphe_ave
urease	6	45	1699	3	ure_ase
weave	11	52	1853	3	_we_ave

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	134027	0.406	440125.6
2	DLD Change Limit	134027	257	5.970	22450.1
3	Display Results	257	257	0.093	2763.4
	(SQL Overall)	178691	257	6.469	27622.7