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

253 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
stemma1032813(None) 
stemmas11256971stemmas
stemmy13417031stemmy
gemma106311772_gemma
lemma94811032_lemma
osteoma945432osteoma
smegma1134112smegma
steam76322932steam_
steams84916902steams
steamy115112372steamy
stela54019042ste_la
stella63612972stella
stem610628252ste_m_
stemmata1244212stemmata
stemmed12278152stemmed
stemmer113210182stemmer
stems75219952ste_ms
sterna63712762sterna
stigma9226762stigma
stoma75918272st_oma
stroma84313072stroma
struma84313272struma
summa94713312s_umma
anemia82613573anemia
asteria7316183asteria
asthma11126563ast_hma
atemoya1242933atemoya
atma68121773at__ma
bema85825253_be_ma
bregma1134963bregma
caeoma1039033caeoma
comma114514793_comma
derma84918513_derma
dilemma1243063dilemma
edema8610553ede_ma
emmy116013243__emmy
enema7612743ene_ma
esteem838813esteem_
esteems935243esteems
etyma1036583et_yma
femme125011433_femme
gamma106116103_gamma
gemmae11507793_gemmae
gemmy135211053_gemmy
gramma11499803gramma
gremmy1454473gremmy
gumma105313103_gumma
herma105318883_herma
item65620383ite_m_
itemed936603itemed
items7499613ite_ms
jemmy19498553_jemmy
lemmas10349163_lemmas
mamma86317913_mamma
maremma1044463maremma
momma85111053_momma
nema65522523_ne_ma
osteomas1045333osteomas
pneuma1035263pneuma
pyemia1337553pyemia
regma84612333_regma
samba95618773s_amba
satem76021463sate_m_
satsuma943873satsuma
scena74815783sce_na
schema1388373schema
scummy15265223scummy
sea36161293s_e__a
seam66645973s_eam_
seaman84015903s_eaman
seams75731663s_eams
seamy105921273s_eamy
seedman1037373seedman
seem65438563s_eem_
seemed95117613seemed
seemer84418043seemer
seemly1138433seemly
seems75525023s_eems
selva83014273s_elva
seme65836653s_e_me
sememe10129983s_ememe
semen75724103s_emen
semes75731583s_emes
semi65127223s_e_mi
semimat11412903s_emimat
semina8915563s_emina
semis74623533s_emis
senna54617983s_enna
sensa54117473s_ensa
sepia75318673s_epia
septa75518083s_epta
sera46141393s_e_ra
seta45637313s_e_ta
shammas14358723shammas
shammy16388503shammy
shea76031573she__a
sheila969843sheila
shelta93111793shelta
sherpa1138093sherpa
shimmy16306413shimmy
sienna647193sienna
sierra637313sierra
siesta639503siesta
sigma84513833s_igma
sima64730783s__ima
skelm114211293skelm_
skelms12368023skelms
slummy13325863slummy
smegmas1233503smegmas
soma65635293s__oma
sperm93216023sperm_
sperms102512603sperms
squama1736533squama
stadia7312143stadia
stamen84115943stamen
stamina9310793stamina
stammel11607533stammel
stammer116013343stammer
stamp95217363st_amp
stamps105614023stamps
stanza1537073stanza
stasima955633stasima
stead65520273ste_ad
steads74116223steads
steady103510203steady
steak95219803ste_ak
steaks104415853steaks
steal56125473ste_al
steals64020063steals
steamed103712143steamed
steamer93313093steamer
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steel55721993ste_el
steels64117983steels
steely93612573steely
steep76020703ste_ep
steeps85215193steeps
steer55423863ste_er
steers63820983steers
steeve93710903steeve
stein54620543ste_in
steins64818343steins
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stele55026843ste_le
steles63725663steles
stelic8313083stelic
stellar72610423stellar
stellas72813043stellas
stemmatic1546013stemmatic
stemmers12378443stemmers
stemmery15334693stemmery
stemmier1245253stemmier
stemming13408203stemming
stemson945163stemson
stemware1344883stemware
stench114111163stench
stengah1144563stengah
steno54716863ste_no
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
step67126293ste__p
steppe10319873steppe
steps76619883ste_ps
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
sterigma1144113sterigma
stern55319123ste_rn
sternal73411913sternal
sterns64616763sterns
sterol6613333sterol
stet45947323ste__t
stets55423913ste_ts
stew77525463ste__w
stewed104814243stewed
stewpan1234193stewpan
stews85519143ste_ws
stewy116112063ste_wy
stey76224413ste__y
sthenia1058503sthenia
stigmal10245923stigmal
stigmas10206643stigmas
stime76521803st_ime
stimes85920573stimes
stimy105114743st_imy
stoa45425913st__oa
stomal85213313stomal
stomas84816323stomas
stomata938533stomata
stomp95616663st_omp
stomps105612833stomps
storm76520403storm_
storms85814633storms
stormy115510733stormy
strata63616283strata
stream84717293stream_
streams94713373streams
streamy12509483streamy
stretta737293stretta
stria55723213st_ria
stromal93010593stromal
strum75619453strum_
strumae9368093strumae
strumas9419833strumas
strums84716453strums
stum65526023st_um_
stummed12348553stummed
stump94616463st_ump
stumps104912283stumps
stumpy13458133stumpy
stums75320083st_ums
stupa74112313st_upa
stymie1137623stymie
stymy13358293st_ymy
summae103911013s_ummae
summas104313163s_ummas
swimmy16234353swimmy
tammy124013223_tammy
tea37353323_te__a
team66238653_team_
teams75726513_teams
tecta74215523_tecta
teem66132603_teem_
teems76019783_teems
tegua6109563_tegua
tela45532973_te_la
telia55821143_telia
temp85323333_te_mp
tempi94912203_tempi
tempo95214973_tempo
temps95417133_temps
tempt95124843_tempt
tenia55324483_tenia
tepa66021683_te_pa
terga63315643_terga
term66233153_term_
terms75523473_terms
terra54419663_terra
tesla55612603_tesla
testa54822043_testa
tetra53417953_tetra
tommy124712233_tommy
tryma1037223_tryma
tummy124711993_tummy
ulema7109713ule_ma
uremia82910893uremia

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.373479064.3
2DLD Change Limit1127162535.00022543.2
3Display Results2532530.0763328.9
 (SQL Overall)1786912535.44932793.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.