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

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

291 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
private	12	15	1326	(None)
primate	11	15	1628	1	primate
privater	13	15	853	1	privater
privates	13	18	1237	1	privates
derivate	12	3	1120	2	derivate
frigate	11	3	1106	2	frigate
pirate	8	23	2288	2	p_irate
plicate	11	3	1451	2	plicate
prate	7	51	3598	2	pr__ate
predate	10	6	1689	2	predate
prelate	9	5	1969	2	prelate
primage	12	16	914	2	primage
primates	12	15	1593	2	primates
priorate	10	4	1173	2	priorate
privacy	17	4	423	2	privacy
privateer	14	13	415	2	privateer
privately	17	4	489	2	privately
privatest	14	19	673	2	privatest
privatise	14	16	776	2	privatise
privative	17	18	829	2	privative
privatize	23	16	704	2	privatize
privet	11	38	2134	2	privet_
privets	12	29	1005	2	privets
privity	15	26	831	2	privity
probate	11	4	1448	2	probate
prolate	9	4	1979	2	prolate
pronate	9	4	1887	2	pronate
prorate	9	4	1873	2	prorate
pyruvate	16	4	307	2	pyruvate
rivage	10	3	884	2	_rivage
urinate	7	3	1536	2	urinate
activate	13	5	1037	3	activate
agitate	8	3	1206	3	agitate
airdate	8	3	1132	3	airdate
amirate	9	11	1595	3	amirate
animate	9	16	1721	3	animate
arcuate	9	3	1196	3	arcuate
ariette	7	3	1237	3	ariette
arillate	8	4	1299	3	arillate
aristae	7	3	1253	3	aristae
aristate	8	3	1213	3	aristate
aviate	9	3	1520	3	avi_ate
binate	8	4	1977	3	_binate
brigade	11	3	649	3	brigade
bromate	11	3	1355	3	bromate
captivate	16	4	592	3	captivate
carinate	10	33	2024	3	carinate
cirrate	9	24	1349	3	cirrate
clavate	12	3	871	3	clavate
climate	11	3	1283	3	climate
crate	7	65	3740	3	cr__ate
cravat	11	3	1444	3	cravat_
cravats	12	3	740	3	cravats
create	8	51	2638	3	cr_eate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
crinite	9	5	1363	3	crinite
crispate	12	4	691	3	crispate
cristae	9	3	1061	3	cristae
cristate	10	3	1060	3	cristate
derivates	13	3	1009	3	derivates
deviate	11	3	1271	3	deviate
dilate	7	32	2069	3	_dilate
drivable	14	3	802	3	drivable
drive	9	53	1800	3	driv__e
elevate	10	11	1037	3	elevate
emirate	9	10	1583	3	emirate
epilate	9	3	1428	3	epilate
ergate	7	3	1514	3	er_gate
estivate	11	10	1000	3	estivate
fixate	16	3	873	3	_fixate
frigates	12	3	1093	3	frigates
gradate	9	5	1123	3	gradate
grate	6	49	3288	3	gr__ate
grimace	12	5	508	3	grimace
grivet	10	35	1782	3	grivet_
grivets	11	35	797	3	grivets
imitate	9	3	1087	3	imitate
irate	5	56	2798	3	__irate
irrigate	9	6	763	3	irrigate
irritate	8	6	787	3	irritate
ligate	7	25	1925	3	_ligate
loricate	10	3	1066	3	loricate
marinate	10	30	1778	3	marinate
misate	8	12	2269	3	_misate
motivate	13	4	769	3	motivate
muriate	9	3	1336	3	muri_ate
muricate	12	3	1111	3	muricate
naivete	10	5	566	3	naivete
nervate	10	3	953	3	nervate
nidate	7	3	1378	3	_nidate
obovate	12	3	546	3	obovate
obviate	12	3	578	3	obviate
opiate	8	5	1346	3	opi_ate
oppilate	12	4	586	3	oppilate
orate	5	51	3330	3	or__ate
ordinate	9	3	1025	3	ordinate
ornate	6	3	1514	3	or_nate
ovate	8	42	1439	3	__ovate
oxidate	15	3	702	3	oxidate
paginate	11	40	1244	3	paginate
palate	8	42	2678	3	p_alate
paleate	9	41	2000	3	paleate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
paravane	13	4	810	3	paravane
passivate	14	4	568	3	passivate
pate	6	53	5046	3	p___ate
patinate	10	30	1631	3	patinate
patriate	10	3	1193	3	patri_ate
pavane	11	41	1344	3	p_avane
pectate	11	22	1469	3	pectate
pedate	9	31	1776	3	p_edate
peltate	9	20	1377	3	peltate
pennate	9	33	1403	3	pennate
periodate	12	4	834	3	periodate
permeate	12	3	1161	3	permeate
perorate	10	4	1792	3	perorate
pervade	13	3	702	3	pervade
phenate	12	4	1220	3	phenate
phonate	12	4	1181	3	phonate
phorate	12	4	1336	3	phorate
picante	11	3	1052	3	p_icante
picrate	11	20	1414	3	picrate
pikake	11	11	580	3	p_ikake
pileate	9	38	1592	3	pileate
pinata	8	38	1722	3	p_inata
pinite	8	3	2124	3	p_inite
pinnate	9	36	1374	3	pinnate
pipage	11	9	914	3	p_ipage
pirated	10	25	1561	3	p_irated
pirates	9	30	2033	3	p_irates
piste	7	58	2460	3	p_i_ste
pivot	10	65	2387	3	p_ivot_
pivoted	13	3	651	3	p_ivoted
pivots	11	51	1190	3	p_ivots
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
plate	7	46	3511	3	p__late
plicae	10	4	1095	3	plica_e
plicated	13	3	1064	3	plicated
plumate	11	4	980	3	plumate
pointe	8	46	1931	3	poi_nte
prase	7	61	2875	3	pr__ase
prat	6	59	5204	3	pr__at_
prated	9	49	2492	3	pr__ated
prater	8	48	2535	3	pr__ater
prates	8	46	3316	3	pr__ates
prats	7	63	3339	3	pr__ats
prebade	12	3	1028	3	prebade
prebake	15	3	909	3	prebake
predated	12	5	1327	3	predated
predates	11	6	1581	3	predates
predicate	14	4	1178	3	predicate
preface	14	5	1092	3	preface
prefade	13	3	901	3	prefade
pregame	12	3	955	3	pregame
preinvite	14	8	544	3	preinvite
prelates	10	4	1857	3	prelates
premade	12	3	1144	3	premade
prename	11	4	1264	3	prename
prepare	11	19	1362	3	prepare
prepaste	12	13	908	3	prepaste
prepave	14	22	887	3	prepave
prerace	11	4	1412	3	prerace
presage	10	3	1229	3	presage
presale	9	4	1635	3	presale
pretape	11	35	1162	3	pretape
pretaste	10	13	952	3	pretaste
prevail	12	3	824	3	prevail
prevalue	13	4	507	3	prevalue
previse	12	37	1379	3	previse
prevue	11	7	916	3	prev_ue
priapi	10	3	792	3	pri_api
price	9	37	2541	3	pri__ce
pricket	15	36	1644	3	pricket
prickle	15	36	1101	3	prickle
pride	8	47	2473	3	pri__de
priest	8	41	2542	3	priest_
priested	11	3	839	3	priested
priests	9	38	1086	3	priests
prima	9	50	1934	3	prima__
primacy	16	3	560	3	primacy
primages	13	15	927	3	primages
primal	10	40	1462	3	prima_l
primary	14	3	770	3	primary
primas	10	44	1810	3	prima_s
primatal	12	4	713	3	primatal
prime	9	65	2560	3	pri__me
primine	11	32	1482	3	primine
primsie	11	3	754	3	primsie
prince	10	41	1476	3	pri_nce
print	7	48	3746	3	pri_nt_
printed	10	40	1637	3	pri_nted
printer	9	39	1730	3	pri_nter
prints	8	43	2010	3	pri_nts
priorates	11	4	1076	3	priorates
prise	7	46	3261	3	pri__se
prisere	9	3	1094	3	prisere
pristane	10	3	1034	3	pristane
prithee	12	3	993	3	prithee
privacies	16	4	680	3	privacies
privateers	15	16	306	3	privateers
privation	14	3	1117	3	privation
privatised	16	13	499	3	privatised
privatises	15	18	740	3	privatises
privatism	16	17	693	3	privatism
privatist	14	22	878	3	privatist
privatives	18	18	647	3	privatives
privatized	25	19	564	3	privatized
privatizes	24	15	681	3	privatizes
privier	12	29	1045	3	privier
privies	12	24	1426	3	privies
privily	15	20	762	3	privily
privities	14	3	1204	3	privities
privy	13	43	983	3	priv__y
prize	16	47	1894	3	pri__ze
probated	13	4	1086	3	probated
probates	12	4	1428	3	probates
proette	9	3	1236	3	proette
profane	12	21	1186	3	profane
promote	11	3	1314	3	promote
pronated	11	4	1405	3	pronated
pronates	10	4	1837	3	pronates
propane	11	27	1615	3	propane
prorated	11	5	1371	3	prorated
prorates	10	4	1807	3	prorates
prostate	10	3	1453	3	prostate
provable	15	3	909	3	provable
prove	10	48	2319	3	prov__e
provide	13	3	985	3	provide
provoke	16	7	612	3	provoke
proximate	20	4	577	3	proximate
pulsate	9	5	1023	3	pulsate
pupate	10	42	1312	3	p_upate
pyrite	11	9	1331	3	pyri__te
pyruvates	17	4	313	3	pyruvates
quinate	16	5	1157	3	quinate
ramate	8	39	2168	3	_ramate
rate	4	54	5876	3	_r__ate
ravage	10	3	930	3	_ravage
rebate	8	44	2411	3	_rebate
redate	7	41	2468	3	_redate
relate	6	40	3363	3	_relate
remate	8	44	2868	3	_remate
revote	9	49	1745	3	_revote
riata	5	46	1802	3	_ri_ata
rite	4	58	4945	3	_ri__te
rivages	11	3	887	3	_rivages
rival	8	52	1650	3	_riva_l
rivaled	11	3	893	3	_rivaled
rivals	9	42	1318	3	_rivals
rive	7	55	3772	3	_riv__e
rivet	8	56	3636	3	_rivet_
riveted	11	25	857	3	_riveted
riveter	10	20	875	3	_riveter
rivets	9	44	1711	3	_rivets
rotate	6	33	2034	3	_rotate
rugate	7	58	1381	3	_rugate
ruinate	7	3	1283	3	ruinate
salivate	11	3	1001	3	salivate
savate	9	3	1378	3	_savate
seriate	7	37	2247	3	seri_ate
solvate	10	27	1021	3	solvate
spicate	11	32	1419	3	spicate
spinate	9	31	1481	3	spinate
sprite	8	44	2177	3	spri__te
striate	7	42	1895	3	stri_ate
suricate	10	3	1261	3	suricate
titivate	11	4	680	3	titivate
triage	7	28	1289	3	tri_age
tribade	10	3	729	3	tribade
tribute	9	3	731	3	tribute
tristate	8	3	1103	3	tristate
triste	6	38	1864	3	tri_ste
trite	5	47	3003	3	tri__te
trivalve	14	4	394	3	trivalve
trivet	9	37	2188	3	trivet_
trivets	10	39	1158	3	trivets
uprate	8	39	1654	3	upr__ate
urate	5	54	3216	3	ur__ate
urinated	9	3	1161	3	urinated
urinates	8	3	1413	3	urinates
urticate	10	4	986	3	urticate
valvate	13	37	1081	3	valvate
variate	10	13	1643	3	vari_ate
virgate	11	3	873	3	virgate
vivace	14	3	655	3	_vivace
volvate	13	31	799	3	volvate
vulvate	13	38	832	3	vulvate
write	8	55	2283	3	wri__te

Search took 8 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	291	6.983	19193.3
3	Display Results	291	291	0.110	2645.5
	(SQL Overall)	178691	291	7.499	23828.6