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 “heliums” 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.

216 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
heliums1218830(None) 
helium112311251helium_
alliums957972alliums
ceriums1139472ceriums
cesiums1136302cesiums
foliums1237172foliums
helices12313722helices
helios94816632heli_os
helixes1739132helixes
helms105619462hel__ms
holisms123811112holisms
holmiums1544152holmiums
kaliums1336602kaliums
kelims1278912keli_ms
mediums12308722mediums
rheniums1344412rheniums
tediums10266972tediums
telium82611392telium_
thuliums1343552thuliums
vellums1235292vellums
aecium10410423aecium_
albums10198273_albums
algums9208043_algums
allium8311243allium_
alums75720603_al_ums
atriums939043atriums
bariums1139143bariums
bdelliums1442053bdelliums
bedims1149593bedi_ms
begums11429493be_gums
belauds1036643belauds
beldams1237053beldams
beliefs12448583beliefs
beliers94617383beliers
belies84631053beli_es
blellums1242833blellums
caesiums1245533caesiums
calciums1446163calciums
celiacs11157893celiacs
celoms10412123cel_oms
centums11398783centums
cerium10313763cerium_
cesium1039583cesium_
chemisms17278213chemisms
chetrums1543913chetrums
chillums1544163chillums
cilium104311373cilium_
coniums11311863coniums
curiums1138503curiums
degums10438623de_gums
deisms94411043de_isms
delicts104012253delicts
delime9314043deli_me
delimes10314193delimes
deliriums1244473deliriums
delis64928543deli__s
delists84414173delists
denims95214323deni_ms
elides74420693_elides
elints65816423_elints
elites66027123_elites
elms67322703_el__ms
eluviums1343863_eluviums
erbiums1135463erbiums
felids103111623feli_ds
felines104718073felines
fermiums1544353fermiums
ferrums1265983ferrums
folium11310453folium_
galliums1145963galliums
genius74512923geniu_s
geums85414113ge__ums
glims87417673_gli_ms
glums84621423_gl_ums
hafniums1643103hafniums
hahniums1643343hahniums
hakims1537303haki_ms
halibuts1364443halibuts
halides113416663halides
halidoms1485823halidoms
halids104016133hali_ds
halites103221193halites
halitus10339963halitus
halms105225213hal__ms
hassiums1344273hassiums
heaume1137543he_aume
heaumes1237423he_aumes
heelings12359753heelings
hegiras1136103hegiras
heils85222193he_i_ls
heirs85618563he_i_rs
heists96814633he_ists
hejiras1744233hejiras
heliac111010893heli_ac
heliast10312073heliast
heliasts1136103heliasts
helical12311153helical
helicon1237643helicon
helicons1337613helicons
helio85321193heli__o
helipad1344723helipad
helipads1443873helipads
helix154413013heli__x
hellers103619833hellers
hellions11310023hellions
helloes103717463helloes
hellos95321683hel_los
hells85032043hel__ls
helluva1353533helluva
helm95530023hel__m_
helmets12309073helmets
helos84928063hel__os
helotisms1446833helotisms
helots95217703hel_ots
helpers123311853helpers
helpings14255653helpings
helps105219343hel__ps
helves124316063hel_ves
hemins113417573hemi_ns
hemlines13310623hemlines
hems95534943he___ms
heriots10312063heriots
herms105626433he__rms
heroisms1338693heroisms
hilum105514603hil_um_
hilus84817643hil_u_s
hims95230973h__i_ms
hokums1533923h_okums
holdups1333593holdups
holibuts1363953holibuts
holies94630033holi_es
holism113713753holism_
holists104413963holists
holmium1445443holmium_
holms105117803hol__ms
hums96831423h___ums
hymeniums1973473hymeniums
ilium74614183_ilium_
indiums1037143indiums
ioniums938303ioniums
kalium1239473kalium_
kelim11912553keli_m_
kilims1277903kili_ms
linums838283__linums
lums65734243__l_ums
medium113711623medium_
medius93613283mediu_s
melisma1146473melisma
melismas1245713melismas
milium104712683milium_
miniums113910223miniums
neums75414253ne__ums
nobeliums1343893nobeliums
obelisms1236393obelisms
odiums9337943_odiums
oleums8358783_oleums
opiums10307073_opiums
osmiums1134143osmiums
palliums1236703palliums
pelites93821993pelites
peplums13145503peplums
phellems1544543phellems
plenums1136533plenums
plums94619953_pl_ums
podiums12227633podiums
prelims1139823preli_ms
premiums1437533premiums
radiums10299313radiums
realisms102212163realisms
rectums11338523rectums
refilms12347503refilms
regius7311923regiu_s
relics84517903reli_cs
relicts94414593relicts
reliefs10439433reliefs
reliers75519213reliers
relies65036423reli_es
relines75331323relines
relinks114510223relinks
reliques1736903reliques
relists73817053relists
relives104619443relives
relume8313273rel_ume
relumes9612513rel_umes
rhenium1246243rhenium_
rheums1135463rhe__ums
rhodiums1443763rhodiums
scholiums1644843scholiums
sebums10369813se_bums
sedums93910483se_dums
seisms84912143se_isms
seleniums1145823seleniums
septums1135743septums
serums83916303se_rums
sexisms16226223sexisms
skellums1443003skellums
slims75423653_sli_ms
slums74623433_sl_ums
sodiums10177213sodiums
solums85211333sol_ums
talcums1135513talcums
tectums11306423tectums
tedium9269873tedium_
terbiums1245423terbiums
thalliums1443253thalliums
theisms1237763the_isms
thelitis1147513thelitis
thoriums13166403thoriums
thulium1254473thulium_
velites103417303velites
vellum1136773vellum_
velours10278083velours
velum10713383vel_um_
verisms123011253verisms
whelms14377573whel__ms
wholisms1665253wholisms

Search took 8 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 Filter1786911340270.623286823.4
2DLD Change Limit1340272167.14318763.4
3Display Results2162160.0762842.1
 (SQL Overall)1786912167.84222786.4
 
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.