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

221 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
stigma922676(None) 
sigma84513831s_igma
stigmal10245921stigmal
stigmas10206641stigmas
astigmia1143362astigmia
enigma935642enigma
saiga64717932saig_a
sigla64515202s_igla
sigmas94111362s_igmas
signa66114702s_igna
sima64730782s_i_ma
smegma1134112smegma
stemma10328132stemma
sterigma1144112sterigma
stigmata1144672stigmata
stime76521792sti_me
stimy105114732sti_my
stoma75918272st_oma
stroma84313072stroma
struma84313272struma
agma77623263__agma
amiga85514813amig_a
anima74620073ani_ma
asthma11126563ast_hma
astigmias1243463astigmias
atma68121773at__ma
bima86723833_bi_ma
bregma1134963bregma
dogma96112463_dogma
enigmas1045173enigmas
etyma1036583et_yma
giga66720943_gig_a
glioma935953glioma
intima81910033inti_ma
lima65734133_li_ma
magma104513573_magma
optima10106533opti_ma
osteoma945423osteoma
ostia52315583osti__a
ostium8310133ostium_
pigmy13299433_pigmy
pima85428653_pi_ma
prima95019343pri_ma
regma84612333_regma
saga55331173s_ag_a
saigas74114293saigas
sanga66023793sang_a
satsuma943873satsuma
schema1388373schema
scilla8310943scilla
seism75019023seism_
seismal937303seismal
seisms84912143seisms
seriema938403seriema
shiksa1394653shiksa
shim95827853shi_m_
shimmy16306413shimmy
shims104422543shi_ms
shipman14247133shipman
shiva115915003shi_va
sigh85625893s_ig_h
sighs95416743s_ighs
sight94629293s_ight
sigil63515503s_igil
sigmate10710143s_igmate
sign55523053s_ig_n
signal73711483s_ignal
signs65516323s_igns
sika86021323s_i_ka
silva82714023s_ilva
sim56553133s_i_m_
simar74920813s_i_mar
simas75727553s_i_mas
simp85228773s_i_mp
sims65737173s_i_ms
sirra54416323s_irra
sixmo1448303s_ixmo
skim105322503ski_m_
skimo116312533ski_mo
skimp135411313ski_mp
skims114517183ski_ms
slight103416003slight
slim66631953sli_m_
slime74925753sli_me
slims75423653sli_ms
slimy105417423sli_my
smegmas1233503smegmas
soigne74310033soigne
soma65635293s__oma
spica94717943spi_ca
spigot9312603spigot
spirea84015633spirea
squama1736533squama
stadia7312143stadia
stag57332003stag__
stage65330193stag_e
staged84521563staged
stager74821343stager
stages75629493stages
stagey105915583stagey
staggy115510393staggy
stags66226743stag_s
stagy96618893stag_y
staig65519633staig__
staigs75414813staig_s
stamp95217363st_amp
stanza1537073stanza
stasima955633stasima
steam76322923steam_
steams84916903steams
steamy115112373steamy
stela54019043st_ela
stella63612973stella
stem610628243st_em_
stemmas11256973stemmas
stemmy13417033stemmy
stems75219953st_ems
sterigmas1243563sterigmas
sterna63712763sterna
stibial946583stibial
stich104117923sti_ch
stichs114511653stichs
stick115121563sti_ck
stickman1643943stickman
sticks125118613sticks
sticky154711343sticky
stied65723033sti_ed
sties55132983sti_es
stiff114219243sti_ff
stiffs12389963stiffs
stifle93611903stifle
stigmatic1445733stigmatic
stile54931573sti_le
stiles64328773stiles
still54922083sti_ll
stillman1043953stillman
stills64118573stills
stilly93714083stilly
stilt54831983sti_lt
stilts67915313stilts
stimes85920573stimes
sting65330243sti_ng
stinger84314683stinger
stingo74212163stingo
stingos8459453stingos
stingray1243583stingray
stings76220183stings
stingy105213203stingy
stink95122503sti_nk
stinko10499393stinko
stinks105616833stinks
stinky134611073stinky
stint57037663sti_nt
stints65119763stints
stipe76523373sti_pe
stiped94517073stiped
stipel84412123stipel
stipes84524053stipes
stir45723243sti__r
stirk95717413sti_rk
stirks104914243stirks
stirp76815503sti_rp
stirps85011823stirps
stirs55921623sti_rs
stitch11419103stitch
stithy12398213stithy
stiver93915733stiver
stoa45425913st__oa
stogey105811543stogey
stogie7311313stogie
stogy95414083stog_y
stomal85213313st_omal
stomas84816323st_omas
stomp95616663st_omp
storm76520383storm_
storms85814633storms
stormy115510733stormy
strata63616283strata
stream84717283stream
stria55723203st_ria
striata7379953striata
strigil837263strigil
stromal93010583stromal
strum75619443strum_
strumae9368093strumae
strumas9419833strumas
strums84716453strums
stum65526013st_um_
stump94616463st_ump
stums75320083st_ums
stupa74112313st_upa
stygian1144083stygian
stymy13358293st_ymy
summa94713313s_umma
swagman1334913swagman
swig85818023swig__
swigs96213663swig_s
swim96221393swi_m_
swimmy16234353swimmy
swims105514143swi_ms
swingman1443593swingman
syntagma1442013syntagma
taiga64115663taig_a
tegua6109563_tegua
tiara5315913_tiara
tibia7312403_tibia
tiger65718633_tiger
tight93626503_tight
tigon63914443_tigon
tikka835573_tikka
time66235013_ti_me
tinea54923163_tinea
tinman82411143_tinman
titman82711003_titman
toga57027413_tog_a
tryma1037223_tryma
ultima836313ulti_ma
vestigia1243573vestigia
viga85622963_vig_a
vigia94813273_vigia
zeugma1842713zeugma

Search took 7 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 Limit1127162215.98618829.9
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.20228811.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.