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

189 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
siglum93656(None) 
filum105015432fi_lum
glum75825102__glum
hilum105514602hi_lum
iglu510814782_iglu_
iglus6609932_iglus
sagum8512872sag_um
sigla64515202sigl_a
sigloi737742sigloi
siglos7311472siglos
slum65430512s__lum
solum74717612s_olum
aiglet74224193aiglet
algum82711763alg_um
alum65227613__alum
amylum1344693amylum
asylum1144893asylum
begum105213923beg_um
bigly114814753bigl_y
chillum1435443chillum
cilium104311373cilium
cingulum1342723cingulum
degum94711903deg_um
dictum1136863dictum
diglot83014333diglot
dinkum1335893dinkum
dirdum1036033dirdum
englut738453englut
film94828173fi_l_m
gaum75726423__gaum
geum75424553__geum
giglet83920273giglet
giglot84013133giglot
gigue71210673gig_ue
glam76529343__glam
glim76026353__glim
glom75424383__glom
glue55628493__glue
glug66118013__glug
glume85120463__glume
glums84621423__glums
glut56331293__glut
grum75625083__grum
gum67439533__g_um
hilus84817643hi_lus
igloo6410493_igloo
ileum74512823_ileum
ilium74614183_ilium
illume8298223_illume
imaum9139643_imaum
jugulum1742503jugulum
jugum15167473jug_um
kilim11711893ki_lim
ligula7359673ligula
ligule74010833ligule
linum7313823li_num
lum55542933___lum
magnum1136733magnum
milium104712683milium
minium106014423minium
oidium959813oidium
osculum1143833osculum
pablum1237503pablum
peplum12156823peplum
phylum1655153phylum
piglet93420923piglet
pignus937953pignus
pignut9311573pignut
pigout9314613pigout
pileum10399513pileum
pilus75921063pi_lus
plum85122103__plum
reglue739703reglue
regnum957163regnum
rigour7258023rigour
sacrum103910143sacrum
sagbut959753sagbut
schlub1355003schlub
schlump1643263schlump
scrum95418203s_crum
scum85924523s__cum
scutum1036373scutum
sebum93814553s_ebum
sedum84115573s_edum
segue6314413seg_ue
sensum849353sensum
septum1038003septum
serum75223473s_erum
shalom11810923shalom
shlub105411743s_hlub
shlump1345713s_hlump
sholom11910113sholom
sial45938833sial__
sialic8313633sialic
sialid7314943sialid
sials54227243sial_s
siddur834573siddur
sidle65124033sidl_e
sidled84215173sidled
sidler74716963sidler
sidles74721153sidles
sieur5911893si_eur
sigh85625893sig__h
sighed113712053sighed
sigher103813703sigher
sighs95416743sig_hs
sight94629293sig_ht
sights103818013sights
sigil63515503sig_il
sigils73912363sigils
sigma84513833sig_ma
sigmas94111363sigmas
sign55523053sig__n
signa66114703sig_na
signal73711483signal
signed83413753signed
signee73617233signee
signer74015633signer
signet73621153signet
signor73510353signor
signs65516323sig_ns
sild55030583si_l_d
silds65520523si_lds
silex123417413si_lex
silk85529323si_l_k
silks94620683si_lks
silky125315823si_lky
sill45545153si_l_l
siller64026063siller
sills55135993si_lls
silly84527623si_lly
silo46037913si_l_o
silos56029433si_los
silt46558193si_l_t
silts55330823si_lts
silty84721633si_lty
silva82714023si_lva
sim56553143si___m
simlin8311733simlin
simoom1037503simoom
sinful938803sinful
single74520603singl_e
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singl_y
sinus55523853si_nus
sirup74014913si_rup
sistrum946563sistrum
sitcom1036903sitcom
situp74414063si_tup
situs55019233si_tus
skellum1343853skellum
skelm114211293skel_m
slalom888173slalom
slam67737973s__lam
slim66631963s__lim
slub65428033s__lub
slue45332193s__lue
slug55124643s__lug
slump94816633s__lump
slums74623433s__lums
slur45525153s__lur
slut45040593s__lut
sniglet83612413sniglet
sodium92111453sodium
solums85211333s_olums
solus54726983s_olus
sorghum1343513sorghum
spiculum1464213spiculum
sputum1035943sputum
stibium1145843stibium
stickum1534823stickum
strum75619453s_trum
stum65526023s__tum
stylus9397463stylus
subgum1136133subgum
sulu45128423s_ulu_
sulus54821883s_ulus
sum56346013s___um
swum96416823s__wum
tiglon737923tiglon
unglue748003unglue
vellum1136773vellum
velum10713383_velum
vigour10256803vigour
villus93611223villus
wiglet105519153wiglet
wigwam1544723wigwam

Search took 9 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.376475242.0
2DLD Change Limit1127161897.75014544.0
3Display Results1891890.0464108.7
 (SQL Overall)1786911898.17221866.3
 
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.