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

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

485 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
opiate	8	5	1346	(None)
opiated	10	3	948	1	opiated
opiates	9	3	1214	1	opiates
aviate	9	3	1520	2	aviate
epilate	9	3	1428	2	epilate
expiate	16	9	1059	2	expiate
foliate	10	5	1353	2	foliate
oblate	8	22	1474	2	oblate
obviate	12	3	578	2	obviate
oleate	6	3	1888	2	oleate
operate	9	6	1573	2	operate
ophite	11	4	1056	2	ophite
opine	7	74	2246	2	opi_ne
oppilate	12	4	586	2	oppilate
orate	5	51	3330	2	o_rate
ornate	6	3	1513	2	ornate
outate	6	29	2340	2	outate
ovate	8	42	1439	2	o_vate
oxidate	15	3	702	2	oxidate
pate	6	53	5046	2	_p_ate
pirate	8	23	2288	2	_pirate
piste	7	58	2460	2	_piste
plate	7	46	3511	2	_plate
pointe	8	46	1931	2	pointe
prate	7	51	3598	2	_prate
sopite	8	49	1771	2	sopi_te
spate	7	47	3158	2	sp_ate
spicate	11	32	1419	2	spicate
spinate	9	31	1481	2	spinate
spite	7	54	3066	2	spi_te
update	9	38	1029	2	update
uprate	8	39	1654	2	uprate
abate	7	66	2784	3	_abate
ablate	8	22	1921	3	ablate
acuate	8	3	1563	3	acuate
adnate	7	29	1348	3	adnate
aerate	6	48	3055	3	aerate
agate	6	65	2515	3	_agate
agitate	8	3	1206	3	agitate
agnate	7	33	1488	3	agnate
alate	5	53	4032	3	_alate
amirate	9	11	1595	3	amirate
animate	9	16	1721	3	animate
ansate	6	45	1786	3	ansate
apace	9	47	1838	3	ap_ace
apian	7	50	1833	3	apia_n
apiary	11	39	1038	3	apiary
apiece	10	5	1008	3	apiece
aplite	8	3	1639	3	aplite
aspirate	10	3	994	3	aspirate
ate	3	70	5924	3	___ate
aurate	6	44	2647	3	aurate
aviated	11	3	1026	3	aviated
aviates	10	3	1306	3	aviates
axite	12	52	1825	3	axi_te
bate	6	65	5242	3	__bate
berate	8	47	2902	3	berate
binate	8	4	1977	3	binate
biopirate	13	7	463	3	biopirate
bite	6	65	4700	3	_bi_te
blate	7	59	3378	3	_blate
blite	7	62	2535	3	bli_te
bloviate	13	8	491	3	bloviate
boite	7	44	2632	3	boi_te
boniato	9	4	728	3	boniato
borate	8	50	2615	3	borate
capitate	12	17	1218	3	capitate
carate	8	47	3400	3	carate
cate	6	62	5460	3	__cate
cerate	8	48	2946	3	cerate
ciliate	9	5	1460	3	ciliate
cite	6	56	4034	3	_ci_te
climate	11	3	1283	3	climate
cogitate	11	4	855	3	cogitate
cognate	10	3	1220	3	cognate
collate	9	29	1968	3	collate
comate	10	41	2484	3	comate
connate	9	3	1575	3	connate
copemate	14	3	999	3	copemate
copihue	14	4	414	3	copihue
copulate	12	26	1411	3	copulate
cordate	10	3	1522	3	cordate
costate	9	40	1927	3	costate
crate	7	65	3740	3	_crate
create	8	51	2637	3	create
curate	8	52	2624	3	curate
date	5	64	4332	3	__date
debate	9	44	1919	3	debate
delate	7	38	2775	3	delate
depilate	11	3	1170	3	depilate
derate	7	45	3123	3	derate
deviate	11	3	1271	3	deviate
dilate	7	32	2069	3	dilate
dite	5	55	4755	3	_di_te
dominate	11	3	1285	3	dominate
donate	7	36	1950	3	donate
elate	5	53	3588	3	_elate
elite	5	62	3018	3	eli_te
eluate	6	23	1543	3	eluate
emirate	9	10	1583	3	emirate
enate	5	44	2814	3	_enate
epidote	10	3	739	3	epidote
epilated	11	3	1075	3	epilated
epilates	10	3	1350	3	epilates
epistle	9	5	789	3	epistle
equate	15	20	1246	3	equate
ergate	7	3	1514	3	ergate
estate	6	47	1976	3	estate
evite	8	53	1768	3	evi_te
expiated	18	16	852	3	expiated
expiates	17	8	1021	3	expiates
fate	7	54	4428	3	__fate
fiat	7	66	4664	3	_fiat_
fiats	8	53	2448	3	_fiats
filiate	10	4	1423	3	filiate
fixate	16	3	873	3	fixate
flite	8	54	2496	3	fli_te
folate	9	33	2039	3	folate
foliage	11	4	753	3	foliage
foliated	12	4	991	3	foliated
foliates	11	4	1275	3	foliates
fomite	11	33	1407	3	fomi_te
formate	12	31	1509	3	formate
fossate	10	38	860	3	fossate
foveate	13	3	836	3	foveate
frigate	11	3	1106	3	frigate
gate	5	57	4657	3	__gate
gelate	7	34	2125	3	gelate
gite	5	54	3861	3	_gi_te
goliath	11	4	593	3	goliath
grate	6	49	3288	3	_grate
gyrate	10	49	1252	3	gyrate
hamate	11	33	1983	3	hamate
hate	7	84	5017	3	__hate
hoplite	12	3	1107	3	hoplite
humate	11	32	1444	3	humate
ideate	7	3	1368	3	ideate
imitate	9	3	1087	3	imitate
ingate	7	30	1824	3	ingate
inmate	8	29	1736	3	inmate
innate	6	39	1731	3	innate
iodate	7	3	1350	3	iodate
iodinate	9	4	934	3	iodinate
iolite	6	32	2198	3	ioli_te
irate	5	56	2798	3	_irate
jugate	14	37	946	3	jugate
karate	10	53	2092	3	karate
kite	8	53	3823	3	_ki_te
labiate	9	13	1357	3	labiate
lanate	6	4	2126	3	lanate
lapidate	11	5	790	3	lapidate
late	4	75	6048	3	__late
legate	7	29	1745	3	legate
liane	5	47	2066	3	_liane
ligate	7	25	1925	3	ligate
lipase	8	23	910	3	lipase
lite	4	70	5454	3	_li_te
lobate	8	29	1524	3	lobate
locate	8	39	1984	3	locate
loricate	10	3	1066	3	loricate
lunate	6	3	1604	3	lunate
luxate	13	3	808	3	luxate
lyrate	9	41	1210	3	lyrate
lysate	9	38	810	3	lysate
malate	8	46	2455	3	malate
mate	6	51	5422	3	__mate
mediate	10	34	1521	3	mediate
metate	8	27	2053	3	metate
misate	8	12	2269	3	misate
mite	6	62	4941	3	_mi_te
modiste	10	3	928	3	modiste
motivate	13	4	769	3	motivate
muriate	9	3	1336	3	muriate
mutate	8	30	1748	3	mutate
negate	7	29	1557	3	negate
nidate	7	3	1378	3	nidate
nite	4	59	4358	3	_ni_te
nominate	10	3	1247	3	nominate
noplace	11	3	739	3	noplace
norite	6	32	2113	3	nori_te
notate	6	32	1786	3	notate
nutate	6	30	1737	3	nutate
oat	3	98	8826	3	o__at_
oaten	5	52	2240	3	o__aten
oater	5	54	3373	3	o__ater
oath	7	61	3215	3	o__ath
oats	4	65	5421	3	o__ats
obia	6	79	2311	3	obia__
obias	7	61	1686	3	obia_s
obit	6	68	3708	3	obi_t_
obits	7	46	1755	3	obi_ts
oblates	9	19	1324	3	oblates
obligate	11	19	830	3	obligate
obovate	12	3	546	3	obovate
obviated	14	4	456	3	obviated
obviates	13	4	515	3	obviates
ocicat	10	14	1281	3	ocicat_
ocicats	11	13	741	3	ocicats
ocreate	9	37	1174	3	ocreate
octane	8	14	1163	3	octane
octave	11	15	734	3	octave
odist	6	4	2191	3	odist_
odists	7	4	985	3	odists
odonate	8	4	840	3	odonate
ogive	9	37	909	3	ogi_ve
ohia	7	57	1936	3	ohia__
ohias	8	44	1557	3	ohia_s
ohmage	12	9	506	3	ohmage
oleates	7	4	1783	3	oleates
olive	8	48	1715	3	oli_ve
omit	6	53	3737	3	omi_t_
omits	7	50	1826	3	omi_ts
omitted	10	34	789	3	omitted
omitter	9	29	850	3	omitter
oocyte	11	3	575	3	oocyte
oolite	6	33	1960	3	oolite
oophyte	15	4	563	3	oophyte
opah	9	62	1840	3	op_a_h
opahs	10	54	1198	3	op_ahs
opal	6	69	2352	3	op_a_l
opals	7	57	1835	3	op_als
opaque	17	3	421	3	opaque
ope	5	68	4524	3	op___e
operated	11	5	1222	3	operated
operates	10	5	1541	3	operates
ophites	12	3	1010	3	ophites
opiating	11	4	1009	3	opiating
opined	9	51	1385	3	opined
opines	8	48	2070	3	opines
oping	8	63	2241	3	opi_ng
opioid	9	3	1008	3	opioid
opium	9	28	1209	3	opi_um
opiums	10	30	707	3	opiums
oppilated	14	4	458	3	oppilated
oppilates	13	4	545	3	oppilates
oppose	10	3	919	3	oppose
opt	5	75	4554	3	op__t_
optative	13	4	765	3	optative
opted	8	49	1427	3	op__ted
optime	10	7	935	3	optime
opts	6	81	2474	3	op__ts
orated	7	42	2150	3	o_rated
orates	6	43	2861	3	o_rates
ordinate	9	3	1025	3	ordinate
oriole	6	8	1429	3	oriole
orpine	8	39	1448	3	orpi_ne
otiose	6	3	940	3	otiose
outage	7	20	1753	3	outage
outdate	8	30	1642	3	outdate
outrate	7	23	2318	3	outrate
overate	10	6	2096	3	overate
ovine	8	63	1664	3	ovi_ne
ovulate	10	3	945	3	ovulate
oxalate	14	5	762	3	oxalate
oxidase	15	4	354	3	oxidase
oxidated	17	4	503	3	oxidated
oxidates	16	3	633	3	oxidates
oxide	13	12	1095	3	oxi_de
oxime	14	9	843	3	oxi_me
ozonate	16	4	686	3	ozonate
pace	8	63	4577	3	_p_ace
page	7	60	3610	3	_p_age
paise	7	50	2833	3	_paise
palate	8	42	2678	3	palate
pale	6	60	5501	3	_p_ale
pane	6	49	5029	3	_p_ane
pare	6	67	6084	3	_p_are
pase	6	53	4686	3	_p_ase
paste	7	49	3295	3	_paste
pat	5	80	8946	3	_p_at_
pated	8	52	3784	3	_p_ated
paten	7	48	2734	3	_p_aten
pater	7	47	4072	3	_p_ater
pates	7	60	4789	3	_p_ates
path	9	91	3491	3	_p_ath
pats	6	64	6085	3	_p_ats
paty	9	52	3456	3	_p_aty
pave	9	61	3389	3	_p_ave
peace	9	50	2608	3	_peace
peage	8	47	2356	3	_peage
pease	7	52	3111	3	_pease
peat	6	59	6793	3	_peat_
peats	7	61	4019	3	_peats
peaty	10	57	2569	3	_peaty
pedate	9	31	1776	3	pedate
phage	11	51	1367	3	_phage
phase	10	46	1721	3	_phase
phat	9	58	3786	3	_phat_
pia	5	68	4803	3	_pia__
piaffe	14	9	491	3	_piaffe
pial	6	56	3670	3	_pia_l
pian	6	61	3609	3	_pia_n
piano	7	61	1871	3	_piano
pians	7	51	2696	3	_pians
pias	6	65	4255	3	_pia_s
piaster	9	30	1288	3	_piaster
piastre	9	30	789	3	_piastre
piazze	16	3	468	3	_piazze
picante	11	3	1052	3	_picante
pice	8	46	4109	3	_pi_ce
picrate	11	20	1414	3	_picrate
pie	5	54	5740	3	_pi__e
piece	9	67	1799	3	_piece
pieta	7	54	2175	3	_pieta
piety	10	58	1730	3	_piety
pikake	11	11	580	3	_pikake
pike	10	63	3521	3	_pi_ke
pile	6	56	4969	3	_pi_le
pileate	9	38	1592	3	_pileate
pinata	8	38	1722	3	_pinata
pine	6	77	5571	3	_pi_ne
pinite	8	3	2124	3	_pinite
pinnate	9	36	1374	3	_pinnate
pint	6	69	6317	3	_pint_
pinta	7	57	2705	3	_pinta
pintle	8	38	1826	3	_pintle
pinto	7	56	2575	3	_pinto
pints	7	59	3622	3	_pints
pipage	11	9	914	3	_pipage
pipe	8	64	3443	3	_pi_pe
pipet	9	55	3332	3	_pipet
pique	16	4	1017	3	_pique
pirated	10	25	1561	3	_pirated
pirates	9	30	2033	3	_pirates
pistes	8	53	2563	3	_pistes
pit	5	64	7192	3	_pi_t_
pita	6	54	3643	3	_pi_ta
pitas	7	74	2767	3	_pitas
pith	9	54	3269	3	_pi_th
pits	6	63	4874	3	_pi_ts
pitta	7	50	1869	3	_pitta
pitted	9	43	1959	3	_pitted
pity	9	60	3193	3	_pi_ty
pixie	14	54	1552	3	_pixie
place	9	48	2461	3	_place
plage	8	45	2040	3	_plage
plane	7	49	2914	3	_plane
plat	6	60	4887	3	_plat_
plated	9	52	2577	3	_plated
platen	8	45	1820	3	_platen
plater	8	44	2769	3	_plater
plates	8	54	3224	3	_plates
plats	7	55	3137	3	_plats
platy	10	50	2166	3	_platy
plicate	11	3	1451	3	plicate
podite	9	33	1535	3	podite
point	7	53	3873	3	point_
pointed	10	38	1398	3	pointed
pointer	9	38	1493	3	pointer
pointes	9	32	1675	3	pointes
points	8	56	1853	3	points
pointy	11	49	1328	3	pointy
poise	7	51	2789	3	poi_se
polite	8	36	2507	3	polite
pomace	12	31	1191	3	pomace
pomade	11	36	1133	3	pomade
populate	12	28	1209	3	populate
potage	9	27	1590	3	potage
potato	8	5	1343	3	potato
prase	7	61	2875	3	_prase
prat	6	59	5204	3	_prat_
prated	9	49	2492	3	_prated
prater	8	48	2535	3	_prater
prates	8	46	3316	3	_prates
prats	7	63	3339	3	_prats
primate	11	15	1628	3	primate
private	12	15	1326	3	private
pupate	10	42	1312	3	pupate
quate	14	45	2141	3	_quate
quinate	16	5	1157	3	quinate
quinte	15	34	1452	3	quinte
quite	14	46	2146	3	qui_te
radiate	8	34	1631	3	radiate
ramate	8	39	2168	3	ramate
rate	4	54	5876	3	__rate
rebate	8	44	2411	3	rebate
redate	7	41	2468	3	redate
relate	6	40	3363	3	relate
remate	8	44	2868	3	remate
replate	9	34	2005	3	replate
riata	5	46	1802	3	_riata
rite	4	58	4945	3	_ri_te
roseate	7	6	1345	3	roseate
rotate	6	33	2034	3	rotate
rugate	7	58	1381	3	rugate
ruinate	7	3	1283	3	ruinate
sate	4	55	5610	3	__sate
satiate	7	3	1540	3	satiate
savate	9	3	1378	3	savate
sedate	7	30	1980	3	sedate
senate	6	37	2514	3	senate
septate	9	5	1187	3	septate
seriate	7	37	2247	3	seriate
site	4	70	5241	3	_si_te
sixte	12	62	1658	3	_sixte
skate	9	47	2155	3	_skate
skite	9	51	2005	3	ski_te
slate	5	54	3828	3	_slate
smite	7	52	2487	3	smi_te
solate	6	45	2607	3	solate
solvate	10	27	1021	3	solvate
somite	8	45	1937	3	somi_te
sonicate	10	3	1093	3	sonicate
sopited	10	42	1106	3	sopi_ted
sopites	9	38	1717	3	sopi_tes
sorbate	9	3	1173	3	sorbate
space	9	53	2567	3	sp_ace
spade	8	44	2332	3	sp_ade
spae	6	50	3432	3	sp_a_e
spait	7	56	3160	3	spait_
spaits	8	50	1747	3	spaits
spake	11	43	2274	3	sp_ake
spale	7	49	2921	3	sp_ale
spare	7	51	3556	3	sp_are
spat	6	65	4852	3	sp_at_
spates	8	50	2817	3	sp_ates
spathe	11	51	1569	3	sp_athe
spats	7	50	3138	3	sp_ats
speciate	12	20	958	3	speciate
spicae	10	43	1370	3	spicae
spicated	13	30	990	3	spicated
spice	9	55	2881	3	spi_ce
spike	11	49	2284	3	spi_ke
spile	7	52	3008	3	spi_le
spilt	7	55	3222	3	spilt_
spilth	11	46	973	3	spilth
spinage	10	28	965	3	spinage
spine	7	65	3442	3	spi_ne
spinet	8	56	2975	3	spinet
spinto	8	4	1066	3	spinto
spire	7	58	2869	3	spi_re
spirt	7	50	3295	3	spirt_
spirted	10	39	1307	3	spirted
spirts	8	53	1713	3	spirts
spit	6	55	4508	3	spi_t_
spital	8	38	1387	3	spital
spited	9	48	2044	3	spi_ted
spites	8	41	2733	3	spi_tes
spits	7	44	2955	3	spi_ts
spitted	10	39	1270	3	spitted
spitter	9	40	1518	3	spitter
spittle	9	3	792	3	spittle
spitz	16	60	1797	3	spi_tz
splake	12	5	978	3	splake
splat	7	61	2934	3	splat_
splats	8	48	1730	3	splats
spoliate	10	3	924	3	spoliate
sprat	7	66	3597	3	sprat_
sprats	8	58	1993	3	sprats
sprite	8	44	2177	3	sprite
state	5	62	3733	3	_state
striate	7	42	1895	3	striate
suite	5	48	2956	3	sui_te
supinate	10	3	1031	3	supinate
tate	4	47	4860	3	__tate
toccate	11	3	877	3	toccate
toeplate	10	4	761	3	toeplate
togate	7	45	1568	3	togate
toluate	7	15	934	3	toluate
topiary	12	4	581	3	topiary
triage	7	28	1289	3	triage
triste	6	38	1864	3	triste
trite	5	47	3003	3	tri_te
tubate	8	28	1317	3	tubate
unite	5	48	2838	3	uni_te
updated	11	36	942	3	updated
updater	10	34	725	3	updater
updates	10	32	979	3	updates
upgaze	18	3	354	3	upgaze
uprated	10	32	1332	3	uprated
uprates	9	38	1486	3	uprates
upstate	9	16	1049	3	upstate
uptake	12	3	696	3	uptake
urate	5	54	3216	3	_urate
urinate	7	3	1536	3	urinate
vacate	11	3	1455	3	vacate
variate	10	13	1643	3	variate
velate	9	37	2014	3	velate
vitae	8	42	1763	3	_vitae
vitiate	10	34	1295	3	vitiate
volvate	13	31	799	3	volvate
white	11	49	2030	3	whi_te
wite	7	54	4327	3	_wi_te
write	8	55	2283	3	wri_te
zonate	15	41	1492	3	zonate

Search took 6 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.123	1452772.4
2	DLD Change Limit	112716	485	5.436	20735.1
3	Display Results	485	485	0.156	3109.0
	(SQL Overall)	178691	485	5.715	31267.0