Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

Here are the results of your fuzzy-string dictionary search for “ionium” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

239 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ionium861092(None) 
conium10415311conium
gonium949801gonium
ioniums938301ioniums
onium73115531_onium
coniums11311862coniums
corium10315722corium
eonism83213532eonism
folium11310452folium
ilium74614182i_lium
indium939502indium
iodism93611132iodism
ionic74622662ioni_c
ionics84214482ionics
ionise63516942ionise
ionize154613872ionize
minium106014422minium
monism104016312monism
muonium1146862muonium
niobium1144722niobium
odium83413032_odium
oidium959812oidium
opium92812092_opium
podium112911912podium
sodium92111452sodium
aconitum1243743aconitum
aecium10410423aecium
allium8311243allium
alodium1047583alodium
ammonium1145883ammonium
atrium8411823atrium
barium10313513barium
biennium1263433biennium
biofilm1444333biofilm
bionic103614573bioni_c
bionics114310873bionics
bohrium1475013bohrium
bonduc1136603bonduc
bonier84321993bonier
boning94223293boning
bonita8312943bonita
bonito8313433bonito
bonus75324323bon_us
boojum1733843boojum
bunkum1435983bunkum
centum104012363centum
cerium10313763cerium
cesium1039583cesium
ciborium1455083ciborium
cilium104311373cilium
clonism1138983clonism
concur10411103concur
condom114215363condom
confirm1437363confirm
congius103210073congius
coni65534803coni__
conic95329793coni_c
conics103920593conics
conidium1366643conidium
conies84338593conies
conin76232723coni_n
conine84528553conine
coning94331823coning
conins84327233conins
consul82312303consul
consume11510133consume
conus76726533con_us
cranium11911103cranium
crinum1039333crinum
cundum1136513cundum
curium10312503curium
denim85518843deni_m
diazonium2193583diazonium
dinkum1335893dinkum
dominium1346773dominium
donut6324513don_ut
dorsum947623dorsum
doum76226673do__um
dubnium1244183dubnium
eonian6311833eonian
eonisms92811043eonisms
erbium1038083erbium
fanum10313443fan_um
foliums1237173foliums
fondu96013973fondu_
fondue104510493fondue
fondus105210943fondus
forum108318763fo_rum
genius74512923genius
gonia64117533goni_a
gonidium1244213gonidium
gonif94320923goni_f
goniff13408893goniff
gonifs104310133gonifs
gonion73612833gonion
goyim1148603goyi_m
hafnium1544243hafnium
hahnium1544433hahnium
helium112311253helium
hokum1436773ho_kum
holism113713753holism
holmium1445443holmium
honied104818393honied
honing103421503honing
honour94710863honour
iconic10411593iconi_c
idiom899963i_diom
idolism1037273idolism
ignify1334513ignify
ignite71410583ignite
ileum74512823i_leum
illinium1045163illinium
imaum9139643i_maum
inarm7314423i_narm
incur72212253i_ncur
incus73315053i_ncus
indiums1037143indiums
indue63516673i_ndue
infirm1137043infirm
inhume1196583i_nhume
inia45024703i_ni_a
inion54620183i_nion
inning73617633inning
input7314653i_nput
inrun52911373i_nrun
iodic84816753iodi_c
iodid74315533iodi_d
iodide84812933iodide
iodids83711153iodids
iodin64419353iodi_n
iodine74618653iodine
iodins74216523iodins
iodise74214943iodise
iodisms10308483iodisms
iodize164112593iodize
iodous7311503iodous
iolite63221983iolite
ion36051023ion___
ionised82911493ionised
ionises72916433ionises
ionized172611293ionized
ionizer162310123ionizer
ionizes162813343ionizes
ionone6313443ionone
ions46737853ion__s
iridium1046303iridium
ironic8313773ironi_c
ironies7517423ironies
ironing82414013ironing
ironist7314843ironist
ironize16610373ironize
ischium1444243ischium
iterum837903iterum
jorum145513743jo_rum
kalium1239473kalium
labium10410243labium
linum7313823lin_um
lionise7310373lionise
lionize1668823lionize
lithium1245823lithium
locum94812173lo_cum
meconium1447313meconium
medium113711623medium
mentum104511713mentum
milium104712683milium
minim97321603mini_m
minimum10456143minimum
miniums113910223miniums
modicum1445073modicum
momism93410353momism
monie75631653moni_e
monied94319463monied
monies83233163monies
monish114217593monish
monisms113512803monisms
monist84324983monist
muoniums1244723muoniums
nanism8311203nanism
neum66723083__neum
nim57142953__ni_m
niobiums1243373niobiums
nomism103010953nomism
noncom1039683noncom
notum7611693no_tum
oakum1177313_oakum
odeum84610543_odeum
odiums9337943_odiums
oleum73613323_oleum
onion54320973_onion
onus45826813_on_us
oogonium1144733oogonium
opiums10307073_opiums
osmium1036573osmium
ostium8310133ostium
ovum92310173_o_vum
oxim131114053_oxi_m
panicum1346393panicum
peonism11611103peonism
peponium1467493peponium
pianism11611033pianism
pionic103515953pioni_c
podiums12227633podiums
polonium1248333polonium
ponied94920703ponied
ponies84833463ponies
porism104518063porism
possum1057953possum
protium11312293protium
radium93513293radium
rhenium1246243rhenium
rhodium1345343rhodium
ronion63315643ronion
sensum849353sensum
sodiums10177213sodiums
solum74717613so_lum
sonic75225293soni_c
sonics84315633sonics
syconium1545863syconium
tedium9269873tedium
telium82611393telium
thorium12208413thorium
titanium1046033titanium
tongue7410093tongue
tonic74727653toni_c
tonics83617863tonics
tonier65520713tonier
toning74025793toning
tonish93415903tonish
tonus56324303ton_us
unionism1047013unionism
uranium9610023uranium
yomim12510083yomi_m
yoni77524393yoni__
yonic105920843yoni_c
yonis85020823yoni_s
zirconium2252533zirconium
zoarium1846093zoarium
zoecium2044183zoecium
zoning162914333zoning

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1401276364.3
2DLD Change Limit1127162395.68619823.4
3Display Results2392390.0802987.5
 (SQL Overall)1786912395.90630255.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.