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

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

347 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
opiums	10	30	707	(None)
odiums	9	33	794	1	odiums
opium	9	28	1209	1	opium_
coniums	11	3	1186	2	coniums
foliums	12	3	717	2	foliums
ioniums	9	3	830	2	ioniums
oakums	12	6	415	2	oakums
odeums	9	36	731	2	odeums
odium	8	34	1303	2	odium_
oleums	8	35	878	2	oleums
onium	7	31	1553	2	onium_
opines	8	48	2070	2	opines
opiumism	14	4	289	2	opiumism
optimums	14	4	256	2	optimums
opus	6	64	2059	2	op_u_s
osmiums	11	3	414	2	osmiums
oxims	14	10	764	2	oxi_ms
plums	9	46	1995	2	_plums
podiums	12	22	763	2	podiums
sodiums	10	17	721	2	sodiums
agisms	9	39	939	3	agisms
aims	6	77	3818	3	_ai_ms
albums	10	19	827	3	albums
algums	9	20	804	3	algums
alliums	9	5	797	3	alliums
alums	7	57	2060	3	_alums
animus	8	42	1161	3	animus
apices	10	49	1626	3	apices
arums	7	55	1783	3	_arums
atriums	9	3	904	3	atriums
aurums	8	4	938	3	aurums
axioms	15	40	805	3	axioms
bariums	11	3	914	3	bariums
begums	11	42	949	3	begums
bohriums	15	9	392	3	bohriums
boojums	18	4	265	3	boojums
brims	9	47	2162	3	bri_ms
bums	8	59	3459	3	__bums
ceriums	11	3	947	3	ceriums
cesiums	11	3	630	3	cesiums
chirms	13	51	1398	3	chirms
chums	12	50	1583	3	_chums
conium	10	4	1531	3	conium_
copalms	13	36	754	3	copalms
copiers	11	42	1596	3	copiers
copies	10	41	3031	3	copi_es
copihues	15	4	399	3	copihues
copings	12	41	1184	3	copings
copious	11	3	1196	3	copious
copouts	11	3	1108	3	copouts
corium	10	3	1572	3	corium_
crinums	11	3	586	3	crinums
cuprums	13	3	445	3	cuprums
curiums	11	3	850	3	curiums
datums	9	3	635	3	datums
degums	10	43	862	3	degums
deisms	9	44	1104	3	deisms
dims	7	54	3502	3	_di_ms
dopings	11	40	878	3	dopings
doums	8	54	1764	3	_doums
drums	8	54	1587	3	_drums
durums	9	4	815	3	durums
eonisms	9	28	1104	3	eonisms
epics	9	50	1428	3	epi_cs
erbiums	11	3	546	3	erbiums
europiums	13	4	411	3	~~eur~~opiums
fanums	11	3	726	3	fanums
films	10	56	1796	3	_films
firms	10	52	1742	3	_firms
folium	11	3	1045	3	folium_
forums	11	46	1184	3	forums
gaums	8	62	1707	3	_gaums
geums	8	54	1411	3	_geums
glims	8	74	1767	3	gli_ms
glums	8	46	2142	3	_glums
gonium	9	4	980	3	gonium_
gums	7	50	3094	3	__gums
gypsums	15	4	192	3	gypsums
heliums	12	18	830	3	heliums
hims	9	52	3097	3	_hi_ms
hokums	15	3	392	3	hokums
holisms	12	38	1111	3	holisms
holmiums	15	4	415	3	holmiums
hums	9	68	3142	3	__hums
idioms	9	5	641	3	idioms
ilium	7	46	1418	3	ilium_
imaums	10	10	630	3	imaums
indiums	10	3	714	3	indiums
iodisms	10	30	848	3	iodisms
ionium	8	6	1092	3	ionium_
isms	6	62	1347	3	__isms
jisms	14	45	800	3	_jisms
jorums	15	40	809	3	jorums
jugums	16	10	467	3	jugums
kaliums	13	3	660	3	kaliums
khoums	15	9	401	3	khoums
larums	8	36	1053	3	larums
linums	8	3	828	3	linums
locums	10	47	830	3	locums
lums	6	57	3424	3	__lums
maims	9	63	2179	3	mai_ms
mediums	12	30	872	3	mediums
miniums	11	39	1022	3	miniums
modicums	15	4	348	3	modicums
momisms	10	30	822	3	momisms
monisms	11	35	1280	3	monisms
mums	8	57	3277	3	__mums
muoniums	12	4	472	3	muoniums
neums	7	54	1425	3	_neums
nims	6	62	2688	3	_ni_ms
niobiums	12	4	337	3	niobiums
nomisms	11	26	874	3	nomisms
oakum	11	7	731	3	oakum_
obias	7	61	1686	3	obi_as
obiism	10	3	636	3	obiism
obiisms	11	3	567	3	obiisms
obis	6	62	2684	3	obi__s
obits	7	46	1755	3	obi_ts
occurs	10	13	655	3	occurs
odeum	8	46	1054	3	odeum_
odious	7	4	993	3	odious
odists	7	4	985	3	odists
odours	7	41	825	3	odours
ogams	8	41	1268	3	o_gams
oghams	12	4	585	3	oghams
ogives	10	36	791	3	ogives
ogrisms	10	3	644	3	ogrisms
ohias	8	44	1557	3	ohi_as
ohms	9	55	1403	3	o__hms
oidium	9	5	981	3	oidium_
oils	4	63	3797	3	o_i_ls
oinks	9	48	1991	3	o_inks
oleum	7	36	1332	3	oleum_
olios	5	45	2085	3	oli_os
olives	9	43	1395	3	olives
omits	7	50	1826	3	omi_ts
oms	5	63	3751	3	o___ms
onions	6	40	1643	3	onions
onus	4	58	2681	3	o_nu_s
opahs	10	54	1198	3	op_ahs
opals	7	57	1835	3	op_als
opaques	18	3	364	3	opaques
opens	7	61	1855	3	op_ens
operas	8	3	1245	3	operas
opes	6	59	4261	3	op__es
ophites	12	3	1010	3	ophites
opiate	8	5	1346	3	opiate
opiates	9	3	1214	3	opiates
opine	7	74	2246	3	opi_ne
opined	9	51	1385	3	opined
oping	8	63	2241	3	opi_ng
opioid	9	3	1008	3	opioid
opioids	10	3	652	3	opioids
opiumisms	15	4	263	3	opiu~~mis~~ms
opossums	12	5	239	3	opossums
oppugn	11	4	279	3	oppugn
oppugns	12	4	193	3	oppugns
ops	5	66	4125	3	op___s
opsins	8	4	1171	3	opsins
optics	10	28	1018	3	optics
optima	10	10	653	3	optima
optime	10	7	935	3	optime
optimes	11	4	847	3	optimes
optimum	13	4	335	3	optimum
options	9	38	1060	3	options
opts	6	81	2474	3	op__ts
opuses	8	40	1224	3	opuses
oribis	8	3	883	3	oribis
oriels	6	49	1462	3	oriels
orphisms	15	4	599	3	orphisms
orpines	9	44	1479	3	orpines
orpins	8	36	1416	3	orpi_ns
osiers	6	34	1279	3	osiers
osmium	10	3	657	3	osmium_
ostium	8	3	1013	3	ostium_
otitis	6	36	1234	3	otitis
ouds	5	64	3010	3	o__uds
ours	4	72	3756	3	o__urs
outs	4	57	4696	3	o__uts
ovibos	11	4	546	3	ovibos
ovines	9	46	1434	3	ovines
ovum	9	23	1017	3	o_vum_
oxides	14	10	969	3	oxides
oxids	13	12	896	3	oxi_ds
oxim	13	11	1405	3	oxi_m_
oxime	14	9	843	3	oxi_me
oximes	15	10	742	3	oximes
palms	9	49	2175	3	_palms
pams	8	56	4176	3	_p_ams
papisms	13	23	854	3	papisms
peplums	13	14	550	3	peplums
perms	9	55	2451	3	_perms
phuts	10	46	1350	3	_phuts
pians	7	51	2696	3	_pians
pias	6	65	4255	3	_pi_as
picas	9	46	2652	3	_picas
picks	13	52	2614	3	_picks
pics	8	56	3391	3	_pi_cs
piculs	10	35	1175	3	_piculs
piers	7	59	2633	3	_piers
pies	6	69	4960	3	_pi_es
pigmy	13	29	943	3	_pigmy
pigs	7	66	3422	3	_pi_gs
pikas	11	42	1809	3	_pikas
pikes	11	50	3103	3	_pikes
pikis	11	51	1639	3	_pikis
piles	7	47	4261	3	_piles
pilis	7	58	2520	3	_pilis
pills	7	41	3097	3	_pills
pilus	7	59	2106	3	_pilus
pima	8	54	2865	3	_pi_ma
pimas	9	47	2510	3	_pimas
pimp	10	60	2490	3	_pi_mp
pimps	11	46	1698	3	_pimps
pinas	7	54	3445	3	_pinas
pines	7	60	4886	3	_pines
pings	8	58	3088	3	_pings
pinks	11	57	2938	3	_pinks
pins	6	55	5845	3	_pi_ns
pints	7	59	3622	3	_pints
pinups	10	3	741	3	_pinups
pions	7	58	2639	3	_pions
pious	7	46	2127	3	_pious
pipes	9	60	3014	3	_pipes
pips	8	58	3713	3	_pi_ps
piques	17	3	909	3	_piques
pirns	7	60	2009	3	_pirns
pis	5	63	6203	3	_pi__s
pisos	7	60	2106	3	_pisos
piss	6	50	3333	3	_pi_ss
pitas	7	74	2767	3	_pitas
piths	10	58	1754	3	_piths
pits	6	63	4874	3	_pi_ts
piu	5	66	3954	3	_piu__
pixes	14	43	2317	3	_pixes
plugs	8	52	1349	3	_plugs
plum	8	51	2210	3	_plum_
plumb	11	45	1407	3	_plumb
plumbs	12	45	933	3	_plumbs
plume	9	48	1946	3	_plume
plumes	10	43	1813	3	_plumes
plump	11	53	1526	3	_plump
plumps	12	46	1261	3	_plumps
plumy	12	42	1323	3	_plumy
plus	6	63	2483	3	_plu_s
podium	11	29	1191	3	podium_
poems	9	57	1555	3	_poems
poilus	8	22	1057	3	poilus
poinds	9	35	1114	3	poinds
points	8	56	1853	3	points
pois	6	65	3904	3	poi__s
poises	8	42	2654	3	poises
poms	8	70	3774	3	_p_oms
popguns	12	3	402	3	popguns
porisms	11	37	1345	3	porisms
possums	11	4	575	3	possums
poufs	10	56	1606	3	_poufs
pours	7	46	2318	3	_pours
pouts	7	55	3032	3	_pouts
prams	9	61	2551	3	_prams
prims	9	54	2593	3	_prims
primus	10	37	1217	3	primus
prisms	10	49	1550	3	prisms
proms	9	54	2641	3	_proms
protiums	12	3	855	3	protiums
pubs	8	50	2921	3	_p_ubs
puds	7	56	3051	3	_p_uds
pugs	7	63	3277	3	_p_ugs
puls	6	54	3756	3	_p_uls
puma	8	54	2412	3	_p_uma
pumas	9	51	2156	3	_p_umas
pump	10	57	2685	3	_p_ump
pumps	11	55	2060	3	_p_umps
puns	6	66	4148	3	_p_uns
pups	8	60	3223	3	_p_ups
purs	6	56	4104	3	_p_urs
pus	5	55	4784	3	_p_u_s
puss	6	48	3013	3	_p_uss
puts	6	56	4175	3	_p_uts
radiums	10	29	931	3	radiums
rheums	11	3	546	3	rheums
rhodiums	14	4	376	3	rhodiums
rims	6	59	3630	3	_ri_ms
rums	6	48	3347	3	__rums
scrums	10	46	1425	3	scrums
scums	9	50	1742	3	_scums
sebums	10	36	981	3	sebums
sedums	9	39	1048	3	sedums
seisms	8	49	1214	3	seisms
septums	11	3	574	3	septums
serums	8	39	1630	3	serums
shims	10	44	2255	3	shi_ms
sims	6	57	3717	3	_si_ms
skims	11	45	1719	3	ski_ms
slims	7	54	2365	3	sli_ms
slums	7	46	2343	3	_slums
sodium	9	21	1145	3	sodium_
solums	8	52	1133	3	solums
sophisms	15	4	665	3	sophisms
sopites	9	38	1717	3	sopites
spams	9	49	2219	3	sp_ams
spasms	10	41	897	3	spasms
sperms	10	25	1260	3	sperms
spicas	10	47	1582	3	spicas
spices	10	43	2603	3	spices
spicks	14	48	1499	3	spicks
spics	9	41	2324	3	spi_cs
spiels	8	53	1795	3	spiels
spiers	8	44	2174	3	spiers
spies	7	60	3762	3	spi_es
spiffs	14	32	847	3	spiffs
spikes	12	45	2071	3	spikes
spiks	11	41	1747	3	spi_ks
spiles	8	42	2791	3	spiles
spills	8	47	1746	3	spills
spines	8	51	3203	3	spines
spins	7	53	2798	3	spi_ns
spirems	11	49	956	3	spirems
spires	8	46	2811	3	spires
spirts	8	53	1713	3	spirts
spites	8	41	2733	3	spites
spits	7	44	2955	3	spi_ts
spivs	10	51	1424	3	spi_vs
spouts	8	51	1511	3	spouts
sprues	8	45	1576	3	sprues
sprugs	9	40	1017	3	sprugs
spuds	8	51	1367	3	sp_uds
spues	7	50	2538	3	sp_ues
spume	9	58	1731	3	sp_ume
spumes	10	213	1488	3	sp_umes
spumy	12	46	1036	3	sp_umy
spurs	7	46	2152	3	sp_urs
strums	8	47	1645	3	strums
stums	7	53	2008	3	_stums
sums	6	58	3758	3	__sums
swims	10	55	1414	3	swi_ms
tediums	10	26	697	3	tediums
thoriums	13	16	640	3	thoriums
thrums	11	42	912	3	thrums
tophus	11	52	1036	3	tophu_s
topics	10	47	1458	3	topi_cs
topis	7	60	2583	3	topi__s
trims	7	50	2147	3	tri_ms
tropisms	12	4	772	3	tropisms
utopisms	12	4	541	3	utopisms
vims	9	54	2331	3	_vi_ms
whims	13	45	1533	3	whi_ms

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	112716	0.420	425454.8
2	DLD Change Limit	112716	347	5.673	19868.9
3	Display Results	347	347	0.110	3154.5
	(SQL Overall)	178691	347	6.203	28807.2