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

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

436 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
opium	9	28	1209	(None)
odium	8	34	1303	1	odium
onium	7	31	1553	1	onium
opiums	10	30	707	1	opiums
conium	10	4	1531	2	conium
corium	10	3	1572	2	corium
folium	11	3	1045	2	folium
gonium	9	4	980	2	gonium
ilium	7	46	1418	2	ilium
ionium	8	6	1092	2	ionium
oakum	11	7	731	2	oakum
odeum	8	46	1054	2	odeum
odiums	9	33	794	2	odiums
oidium	9	5	981	2	oidium
oleum	7	36	1332	2	oleum
opine	7	74	2246	2	opine
oping	8	63	2241	2	oping
optimum	13	4	335	2	optimum
opus	6	64	2059	2	op_us
osmium	10	3	657	2	osmium
ostium	8	3	1013	2	ostium
ovum	9	23	1017	2	o_vum
oxim	13	11	1405	2	oxi_m
piu	5	66	3954	2	_piu_
plum	8	51	2210	2	_plum
podium	11	29	1191	2	podium
sodium	9	21	1145	2	sodium
aecium	10	4	1042	3	aecium
agism	8	46	1406	3	agism
aim	5	78	5821	3	_ai_m
album	9	23	1265	3	album
algum	8	27	1176	3	algum
allium	8	3	1124	3	allium
alodium	10	4	758	3	alodium
alum	6	52	2761	3	_alum
apian	7	50	1833	3	apian
aping	8	73	2723	3	aping
apish	10	51	1663	3	apish
arum	6	61	2903	3	_arum
atrium	8	4	1182	3	atrium
aurum	7	6	1496	3	aurum
axiom	14	39	1359	3	axiom
barium	10	3	1351	3	barium
begum	10	52	1392	3	begum
bohrium	14	7	501	3	bohrium
boojum	17	3	384	3	boojum
brim	8	56	2937	3	bri_m
bum	7	53	4269	3	__bum
cecum	11	6	1184	3	cecum
cerium	10	3	1376	3	cerium
cesium	10	3	958	3	cesium
chirm	12	53	1706	3	chirm
chum	11	63	1800	3	_chum
cilium	10	43	1137	3	cilium
coniums	11	3	1186	3	coniums
copalm	12	50	1081	3	copalm
copied	11	46	1856	3	copied
copier	10	37	2289	3	copier
copies	10	41	3030	3	copies
copihue	14	4	414	3	copihue
coping	11	39	2766	3	coping
copious	11	3	1196	3	copious
copout	10	4	1878	3	copout
crinum	10	3	933	3	crinum
cum	7	64	4016	3	__cum
cuprum	12	3	674	3	cuprum
curium	10	3	1250	3	curium
datum	8	3	1063	3	datum
degum	9	47	1190	3	degum
deism	8	41	1603	3	deism
dim	6	81	4649	3	_di_m
dopier	9	35	1592	3	dopier
dopily	12	35	1046	3	dopily
doping	10	39	1946	3	doping
dorsum	9	4	762	3	dorsum
doum	7	62	2667	3	_doum
drum	7	65	2159	3	_drum
durum	8	5	1320	3	durum
eonism	8	32	1353	3	eonism
epic	8	69	2130	3	epi_c
epics	9	50	1428	3	epics
erbium	10	3	808	3	erbium
europium	12	4	523	3	~~eur~~opium
fanum	10	3	1344	3	fanum
film	9	48	2817	3	_film
filum	10	50	1543	3	filum
firm	9	60	2645	3	_firm
foliums	12	3	717	3	foliums
forum	10	83	1876	3	forum
gaum	7	57	2642	3	_gaum
geum	7	54	2455	3	_geum
glim	7	60	2635	3	gli_m
glum	7	58	2510	3	_glum
gopik	12	5	753	3	gopi_k
goyim	11	4	860	3	goyi_m
grim	7	69	2942	3	gri_m
grum	7	56	2508	3	_grum
gum	6	74	3953	3	__gum
gypsum	14	4	285	3	gypsum
helium	11	23	1125	3	helium
hilum	10	55	1460	3	hilum
him	8	62	4766	3	_hi_m
hokum	14	3	677	3	hokum
holism	11	37	1375	3	holism
holmium	14	4	544	3	holmium
hoping	12	37	1974	3	hoping
hum	8	55	4293	3	__hum
idiom	8	9	996	3	idiom
ileum	7	45	1282	3	ileum
imaum	9	13	964	3	imaum
indium	9	3	950	3	indium
iodism	9	36	1113	3	iodism
ioniums	9	3	830	3	ioniums
ism	5	63	2238	3	__ism
jism	13	55	1477	3	_jism
jorum	14	55	1374	3	jorum
jugum	15	16	747	3	jugum
kalium	12	3	947	3	kalium
khoum	14	7	664	3	khoum
labium	10	4	1024	3	labium
larum	7	43	1797	3	larum
linum	7	3	1382	3	linum
locum	9	48	1217	3	locum
loping	9	39	2141	3	loping
lum	5	55	4293	3	__lum
maim	8	58	3149	3	mai_m
medium	11	37	1162	3	medium
milium	10	47	1268	3	milium
mim	7	60	4842	3	_mi_m
minium	10	60	1442	3	minium
modicum	14	4	507	3	modicum
momism	9	34	1035	3	momism
monism	10	40	1631	3	monism
mopier	10	39	1478	3	mopier
moping	11	40	1710	3	moping
mopish	13	43	1159	3	mopish
mum	7	66	4361	3	__mum
muonium	11	4	686	3	muonium
neum	6	67	2308	3	_neum
nim	5	71	4295	3	_ni_m
niobium	11	4	472	3	niobium
nomism	10	30	1095	3	nomism
notum	7	6	1169	3	notum
oakums	12	6	415	3	oakums
obi	5	71	2773	3	obi__
obia	6	79	2311	3	obi_a
obias	7	61	1686	3	obias
obiism	10	3	636	3	obiism
obis	6	62	2684	3	obi_s
obit	6	68	3708	3	obi_t
obits	7	46	1755	3	obits
occur	9	13	732	3	occur
odeums	9	36	731	3	odeums
odic	7	49	2057	3	odi_c
odious	7	4	993	3	odious
odist	6	4	2191	3	odist
odour	6	47	1049	3	odour
ogam	7	51	2003	3	o_gam
ogham	11	3	825	3	ogham
ogive	9	37	909	3	ogive
ogrism	9	3	791	3	ogrism
ohia	7	57	1936	3	ohi_a
ohias	8	44	1557	3	ohias
ohing	9	60	1881	3	ohing
ohm	8	65	2301	3	o__hm
oi	2	90	6148	3	o_i__
oil	3	74	5205	3	o_i_l
oils	4	63	3797	3	o_ils
oily	7	79	3225	3	o_ily
oink	8	54	2934	3	o_ink
oleums	8	35	878	3	oleums
olio	4	68	2967	3	oli_o
olios	5	45	2085	3	olios
olive	8	48	1715	3	olive
om	4	85	5300	3	o___m
omasum	10	3	550	3	omasum
omit	6	53	3737	3	omi_t
omits	7	50	1826	3	omits
onion	5	43	2097	3	onion
onus	4	58	2681	3	o_nus
op	4	58	5016	3	op___
opah	9	62	1840	3	op_ah
opahs	10	54	1198	3	opahs
opal	6	69	2352	3	op_al
opals	7	57	1835	3	opals
opaque	17	3	421	3	opaque
ope	5	68	4524	3	op__e
oped	7	62	3015	3	op_ed
open	6	64	2700	3	op_en
opens	7	61	1855	3	opens
opera	7	3	1357	3	opera
opes	6	59	4261	3	op_es
ophite	11	4	1056	3	ophite
opiate	8	5	1346	3	opiate
opined	9	51	1385	3	opined
opines	8	48	2070	3	opines
opioid	9	3	1008	3	opioid
opiumism	14	4	289	3	opiu~~mis~~m
opossum	11	5	344	3	opossum
oppugn	11	4	279	3	oppugn
ops	5	66	4125	3	op__s
opsin	7	6	1347	3	opsin
opsins	8	4	1171	3	opsins
opt	5	75	4554	3	op__t
opted	8	49	1427	3	opted
optic	9	37	1518	3	optic
optics	10	28	1018	3	optics
optima	10	10	653	3	optima
optime	10	7	935	3	optime
optimums	14	4	256	3	optimums
opting	9	45	1440	3	opting
option	8	36	1271	3	option
opts	6	81	2474	3	op_ts
oribi	7	3	1109	3	oribi
oriel	5	49	2042	3	oriel
orphism	14	4	618	3	orphism
orpin	7	34	1553	3	orpi_n
orpine	8	39	1448	3	orpine
orpins	8	36	1416	3	orpins
osier	5	35	1801	3	osier
osmiums	11	3	414	3	osmiums
otic	6	66	2482	3	oti_c
oud	4	74	3907	3	o__ud
our	3	60	4289	3	o__ur
out	3	80	7215	3	o__ut
ovine	8	63	1664	3	ovine
owing	9	62	2272	3	owing
oxid	12	8	1548	3	oxi_d
oxide	13	12	1095	3	oxide
oxids	13	12	896	3	oxids
oxime	14	9	843	3	oxime
oxims	14	10	764	3	oxims
palm	8	53	3136	3	_palm
pam	7	78	5839	3	_p_am
papism	12	22	1151	3	papism
peplum	12	15	682	3	peplum
perm	8	58	3463	3	_perm
pfui	9	34	979	3	_pfui
phut	9	69	2597	3	_phut
pi	4	81	4536	3	_pi__
pia	5	68	4803	3	_pi_a
pial	6	56	3670	3	_pial
pian	6	61	3609	3	_pian
pias	6	65	4255	3	_pias
pic	7	60	4682	3	_pi_c
pica	8	58	3149	3	_pica
pice	8	46	4109	3	_pice
pick	12	59	3381	3	_pick
pics	8	56	3391	3	_pics
picul	9	50	1536	3	_picul
pie	5	54	5740	3	_pi_e
pied	7	50	3536	3	_pied
pier	6	60	3529	3	_pier
pies	6	69	4960	3	_pies
pig	6	57	4497	3	_pi_g
pigmy	13	29	943	3	_pigmy
pigs	7	66	3422	3	_pigs
pika	10	63	2295	3	_pika
pike	10	63	3521	3	_pike
piki	10	65	2056	3	_piki
pile	6	56	4969	3	_pile
pileum	10	39	951	3	_pileum
pili	6	61	3035	3	_pili
pill	6	53	3946	3	_pill
pilus	7	59	2106	3	_pilus
pily	9	61	3273	3	_pily
pima	8	54	2865	3	_pima
pimp	10	60	2490	3	_pimp
pin	5	70	6672	3	_pi_n
pina	6	58	4263	3	_pina
pine	6	77	5571	3	_pine
ping	7	59	4359	3	_ping
pink	10	70	3938	3	_pink
pins	6	55	5845	3	_pins
pint	6	69	6317	3	_pint
pinup	9	6	1288	3	_pinup
piny	9	118	3835	3	_piny
pion	6	72	3529	3	_pion
pious	7	46	2127	3	_pious
pip	7	80	5104	3	_pi_p
pipe	8	64	3443	3	_pipe
pips	8	58	3713	3	_pips
pipy	11	54	2151	3	_pipy
pique	16	4	1017	3	_pique
pirn	6	71	2837	3	_pirn
pis	5	63	6203	3	_pi_s
pish	9	61	2791	3	_pish
piso	6	67	2756	3	_piso
piss	6	50	3333	3	_piss
pit	5	64	7192	3	_pi_t
pita	6	54	3643	3	_pita
pith	9	54	3269	3	_pith
pits	6	63	4874	3	_pits
pity	9	60	3193	3	_pity
pix	12	64	3793	3	_pi_x
pixy	16	61	1776	3	_pixy
plug	7	49	1599	3	_plug
plumb	11	45	1407	3	_plumb
plume	9	48	1946	3	_plume
plump	11	53	1526	3	_plump
plums	9	46	1995	3	_plums
plumy	12	42	1323	3	_plumy
plus	6	63	2483	3	_plus
podiums	12	22	763	3	podiums
poem	8	62	2577	3	_poem
poi	5	72	4466	3	poi__
poilu	7	23	1600	3	poilu
poilus	8	22	1057	3	poilus
poind	8	42	1791	3	poind
point	7	53	3873	3	point
pois	6	65	3904	3	poi_s
poise	7	51	2789	3	poise
pom	7	82	4991	3	_p_om
popgun	11	4	573	3	popgun
popish	13	38	1211	3	popish
porism	10	45	1806	3	porism
possum	10	5	795	3	possum
pouf	9	57	3264	3	_pouf
pour	6	115	2747	3	_pour
pout	6	57	5255	3	_pout
pram	8	57	3349	3	_pram
prim	8	51	3220	3	_prim
prism	9	48	2026	3	prism
prom	8	76	3170	3	_prom
proprium	14	4	737	3	proprium
protium	11	3	1229	3	protium
ptui	6	49	1248	3	_ptui
pub	7	60	3769	3	_p_ub
pud	6	58	3665	3	_p_ud
pug	6	53	3718	3	_p_ug
pul	5	61	3806	3	_p_ul
puma	8	54	2412	3	_p_uma
pump	10	57	2685	3	_p_ump
pun	5	88	4651	3	_p_un
pup	7	63	3988	3	_p_up
pur	5	68	4055	3	_p_ur
pus	5	55	4784	3	_p_us
put	5	57	5907	3	_p_ut
radium	9	35	1329	3	radium
rheum	10	3	884	3	rheum
rhodium	13	4	534	3	rhodium
rim	5	60	5227	3	_ri_m
ropier	8	41	1880	3	ropier
ropily	11	33	1244	3	ropily
roping	9	40	2302	3	roping
rum	5	66	4464	3	__rum
sagum	8	5	1287	3	sagum
scrum	9	54	1820	3	scrum
scum	8	59	2452	3	_scum
sebum	9	38	1455	3	sebum
sedum	8	41	1557	3	sedum
seism	7	50	1902	3	seism
septum	10	3	800	3	septum
serum	7	52	2347	3	serum
shim	9	58	2786	3	shi_m
sim	5	65	5314	3	_si_m
skim	10	53	2251	3	ski_m
slim	6	66	3196	3	sli_m
slum	6	54	3051	3	_slum
sodiums	10	17	721	3	sodiums
solum	7	47	1761	3	solum
sophism	14	3	787	3	sophism
sopite	8	49	1771	3	sopite
spam	8	59	3004	3	sp_am
spasm	9	45	1417	3	spasm
sperm	9	32	1602	3	sperm
spic	8	52	2743	3	spi_c
spica	9	47	1794	3	spica
spice	9	55	2881	3	spice
spick	13	45	1907	3	spick
spics	9	41	2324	3	spics
spicy	12	54	1771	3	spicy
spied	8	54	2771	3	spied
spiel	7	46	2391	3	spiel
spier	7	57	2803	3	spier
spies	7	60	3762	3	spies
spiff	13	36	1640	3	spiff
spik	10	54	1971	3	spi_k
spike	11	49	2284	3	spike
spiks	11	41	1747	3	spiks
spiky	14	60	1411	3	spiky
spile	7	52	3008	3	spile
spill	7	48	2116	3	spill
spilt	7	55	3222	3	spilt
spin	6	62	3130	3	spi_n
spine	7	65	3442	3	spine
spins	7	53	2798	3	spins
spiny	10	49	2130	3	spiny
spire	7	58	2869	3	spire
spirem	10	42	1416	3	spirem
spirt	7	50	3295	3	spirt
spiry	10	50	1735	3	spiry
spit	6	55	4508	3	spi_t
spite	7	54	3066	3	spite
spits	7	44	2955	3	spits
spitz	16	60	1797	3	spitz
spiv	9	59	1779	3	spi_v
spivs	10	51	1424	3	spivs
spout	7	50	2963	3	spout
sprue	7	47	1763	3	sprue
sprug	8	53	1389	3	sprug
spud	7	58	1849	3	sp_ud
spue	6	60	2552	3	sp_ue
spume	9	58	1731	3	sp_ume
spumy	12	46	1036	3	sp_umy
spun	6	62	2146	3	sp_un
spur	6	53	2119	3	sp_ur
sputum	10	3	594	3	sputum
strum	7	56	1945	3	strum
stum	6	55	2602	3	_stum
sum	5	63	4601	3	__sum
swim	9	62	2140	3	swi_m
swum	9	64	1682	3	_swum
tedium	9	26	987	3	tedium
telium	8	26	1139	3	telium
thorium	12	20	841	3	thorium
thrum	10	47	1363	3	thrum
topful	11	3	654	3	topful
tophus	11	52	1036	3	tophus
topi	6	78	3039	3	topi__
topic	9	57	2150	3	topi_c
topics	10	47	1458	3	topics
toping	9	41	2299	3	toping
topis	7	60	2583	3	topi_s
trim	6	53	2952	3	tri_m
tropism	11	3	929	3	tropism
um	4	73	3883	3	___um
utopism	11	4	633	3	utopism
velum	10	7	1338	3	velum
vim	8	74	3702	3	_vi_m
vum	8	54	2865	3	__vum
whim	12	62	2053	3	whi_m
yomim	12	5	1008	3	yomi_m
yum	8	61	3282	3	__yum
zoarium	18	4	609	3	zoarium
zoecium	20	4	418	3	zoecium

Search took 5 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	83667	0.360	496363.9
2	DLD Change Limit	83667	436	4.343	19264.8
3	Display Results	436	436	0.126	3460.3
	(SQL Overall)	178691	436	4.829	37003.7