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

166 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
stigmas1020664(None) 
sigmas94111361s_igmas
stigma9226761stigma_
stigmal10245921stigmal
astigmias1243462astigmias
enigmas1045172enigmas
saigas74114292saig_as
sigma84513832s_igma_
simas75727552s_i_mas
smegmas1233502smegmas
stemmas11256972stemmas
sterigmas1243562sterigmas
stigmata1144672stigmata
stimes85920572sti_mes
stomas84816322st_omas
strumas9419832strumas
agmas85919873__agmas
amigas95912173amig_as
animas84418723ani_mas
asthmas12117363ast_hmas
astigmia1143373astigmia
atmas75721013at__mas
bimas95521743_bi_mas
dogmas105011243_dogmas
enigma935643enigma_
gigas75415583_gig_as
gliomas1035333gliomas
intimas9119583inti_mas
limas75627633_li_mas
magmas115512503_magmas
osteomas1045333osteomas
pimas94725103_pi_mas
primas104418103pri_mas
sagas66025883s_ag_as
saiga64717933saig_a_
sangas75222663sang_as
satsumas1043573satsumas
schemas1468163schemas
scillas9310473scillas
seismal937303seismal
seisms84912143seism_s
seriemas1047193seriemas
shamas113717943s_hamas
shammas14358723shammas
shiksas1484643shiksas
shims104422553shi_m_s
shipman14247133shipman
shivas124512413shi_vas
sighs95416743s_ig_hs
sights103818013s_ights
sigils73912363s_igils
sigla64515203s_igla_
siglos7311473s_iglos
sigmate10710143s_igmate
signa66114703s_igna_
signal73711483s_ignal
signals8359163s_ignals
signs65516323s_ig_ns
sikas94617023s_i_kas
silvas92912183s_ilvas
sima64730783s_i_ma_
simar74920813s_i_mar
simars84916933s_i_mars
simps94719763s_i_mps
sims65737173s_i_m_s
sirras63814863s_irras
sixmos1534813s_ixmos
skimos12548803ski_mos
skimps14488043ski_mps
skims114517193ski_m_s
slights112810723slights
slimes84722043sli_mes
slims75423653sli_m_s
smegma1134113smegma_
somas76030373s__omas
spicas104715823spi_cas
spigots1037793spigots
spireas94412513spireas
stadias8411113stadias
stagers84116673stagers
stages75629493stag_es
stags66226743stag__s
staigs75414813staig__s
stamps105614023st_amps
stanzas1636363stanzas
steams84916903steam_s
stellas72813043stellas
stemma10328133stemma_
stems75219953st_em_s
sterigma1144123sterigma_
stibial946583stibial
stichs114511653sti_chs
stickman1643943stickman
sticks125118613sti_cks
sties55132983sti__es
stiffs12389963sti_ffs
stifles103013393stifles
stigmatic1445733stigmatic
stigmatics1543943stigmatics
stigmatist1354653stigmatist
stiles64328773sti_les
stillman1043953stillman
stills64118573sti_lls
stilts67915313sti_lts
stime76521803sti_m_e
stimies9316563stimies
stimy105114743sti_m_y
stingers94012743stingers
stingos8459453stingos
stingray1243583stingray
stingrays1342713stingrays
stings76220183sti_ngs
stinks105616833sti_nks
stints65119763sti_nts
stipels9418953stipels
stipes84524053sti_pes
stirks104914243sti_rks
stirpes95011293stirpes
stirps85011823sti_rps
stirs55921623sti__rs
stivers103613543stivers
stoas55126023st__oas
stogeys11486123stogeys
stogies8413693stogies
stoma75918273st_oma_
stomal85213313st_omal
stomps105612833st_omps
storms85814633storm_s
stramash1344573stramash
stratas73013583stratas
streams94713373streams
strigils946853strigils
stroma84313073stroma_
stromal93010593stromal
struma84313273struma_
strumae9368093strumae
strums84716453strum_s
stumps104912283st_umps
stums75320083st_um_s
stupas83910883st_upas
stygian1144083stygian
summas104313163s_ummas
swagman1334913swagman
swigs96213663swig__s
swims105514143swi_m_s
swingman1443593swingman
syngas10368913syng_as
syntagmas1542033syntagmas
taigas73712573taig_as
teguas768013_teguas
tiaras6314553_tiaras
tibias839953_tibias
tigers75616513_tigers
tights104015853_tights
tigons74112263_tigons
tikkas934523_tikkas
times75630823_ti_mes
tineas64616483_tineas
tinman82411143_tinman
titman82711003_titman
togas67823003_tog_as
tsimmes1133673tsimmes
ultimas936363ulti_mas
vigas94817883_vig_as
vigias104110893_vigias
zeugmas1942543zeugmas

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.410435831.7
2DLD Change Limit1340271666.78019768.0
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.25324636.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.