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

276 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
stemmy1341703(None) 
steamy115112371steamy
stemma10328131stemma
emmy116013242__emmy
gemmy135211052_gemmy
gremmy1454472gremmy
jemmy19498552_jemmy
scummy15265222scummy
seamy105921272s_eamy
seemly1138432seemly
shammy16388502shammy
shimmy16306412shimmy
slummy13325862slummy
steady103510202steady
steam76322922steam_
steams84916902steams
steely93612572steely
stem610628242ste_m_
stemmas11256972stemmas
stemmed12278152stemmed
stemmer113210182stemmer
stemmery15334692stemmery
stems75219952ste_ms
stewy116112062ste_wy
stey76224412ste__y
stimy105114732st_imy
stormy115510722stormy
streamy12509482streamy
stumpy13458132stumpy
stymy13358292st_ymy
swimmy16234352swimmy
tammy124013222_tammy
tommy124712232_tommy
tummy124711992_tummy
atemoya1242933atemoya
atomy107415193at_omy
beamy126218573_beamy
chammy18488953chammy
chummy18385893chummy
clammy15356333clammy
commy144712643_commy
creamy134811363creamy
crummy15365893crummy
demy105422853_de_my
dreamy12509993dreamy
dummy134712783_dummy
elmy95616793__elmy
emmys12446023__emmys
enemy1059993ene_my
esteem838813esteem_
esteems935243esteems
femme125011433_femme
gammy135514893_gammy
gemma106311773_gemma
germy115113663_germy
gleamy12398113gleamy
gummy135413653_gummy
hammy155113433_hammy
hempy154912763_hempy
immy114611823__immy
item65620383ite_m_
itemed936603itemed
items7499613ite_ms
jammy194810193_jammy
jimmy19538503_jimmy
lemma94811033_lemma
mammy115215163_mammy
mommy114010753_mommy
mummy114913623_mummy
osteoma945423osteoma
ostomy1137823ost_omy
plummy15375663plummy
pommy14449863_pommy
rammy124312493_rammy
rheumy1433353rheumy
rummy124212413_rummy
satem76021453sate_m_
seam66645973s_eam_
seams75731663s_eams
sedgy104512783s_edgy
seedy94821533s_eedy
seely84522633s_eely
seem65438563s_eem_
seemed95117613seemed
seemer84418043seemer
seems75525023s_eems
seepy104717973s_eepy
seme65836653s_e_me
sememe10129983s_ememe
semen75724103s_emen
semes75731583s_emes
semi65127223s_e_mi
semis74623533s_emis
sepoy10314303s_epoy
serry84824123s_erry
sexy146418023s_e_xy
shamoy14379913shamoy
sheeny124912193sheeny
shelly124414463shelly
shelty124011543shelty
shelvy15377863shelvy
sherry124510413sherry
skelm114211283skelm_
skelms12368023skelms
skerry13356103skerry
skimpy17475723skimpy
sleazy18267393sleazy
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
slimly11408903slimly
slimsy11407723slimsy
slimy105417423s_limy
smarmy13629353smarmy
smeary114110803smeary
smegma1134113smegma
smelly114110353smelly
sneaky13427843sneaky
sneery93610413sneery
sneezy18345273sneezy
sodomy1276673sodomy
speedy1218410783speedy
spendy124911143spendy
sperm93216013sperm_
sperms102512603sperms
spumy124610363s_pumy
stably113314123stably
stagey105915583stagey
staggy115510393staggy
stagy96618893st_agy
stalky13499303stalky
stamen84115943stamen
stammel11607533stammel
stammer116013343stammer
stamp95217363st_amp
stamps105614023stamps
starry94911673starry
stay78333723st__ay
stead65520273ste_ad
steads74116223steads
steak95219803ste_ak
steaks104415853steaks
steal56125473ste_al
steals64020063steals
steamed103712143steamed
steamer93313093steamer
steamily1335803steamily
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steel55721993ste_el
steels64117983steels
steep76020703ste_ep
steeply1236293steeply
steeps85215193steeps
steer55423863ste_er
steers63820983steers
steeve93710903steeve
stein54620533ste_in
steins64818343steins
stela54019043ste_la
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stele55026843ste_le
steles63725663steles
stelic8313083stelic
stella63612973stella
stemmata1244213stemmata
stemmers12378443stemmers
stemmier1245253stemmier
stemming13408203stemming
stemson945163stemson
stench114111163stench
stenchy15256213stenchy
steno54716863ste_no
stenoky1444253stenoky
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
step67126293ste__p
steppe10319873steppe
steps76619883ste_ps
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
stern55319123ste_rn
sterna63712763sterna
sternly1037853sternly
sterns64616753sterns
sterol6613323sterol
stet45947323ste__t
stets55423913ste_ts
stew77525463ste__w
stewed104814243stewed
stews85519143ste_ws
sticky154711343sticky
stigma9226753stigma
stilly93714073stilly
stime76521793st_ime
stimes85920573stimes
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083st_ogy
stoma75918273st_oma
stomal85213313stomal
stomas84816323stomas
stomp95616663st_omp
stomps105612833stomps
stoney96217353stoney
stony85818643st_ony
storey95217613storey
storm76520373storm_
storms85814603storms
story86723033st_ory
stoury9529943stoury
strawy1210312823strawy
stray88525573st_ray
streaky14447813streaky
stream84717283stream_
streams94713373streams
stripy115812743stripy
stroma84313073stroma
stroy87720393st_roy
strum75619443strum_
struma84313273struma
strums84716453strums
stubby1345043stubby
studly10397693studly
study94411793st_udy
stuffy15317083stuffy
stum65526013st_um_
stummed12348553stummed
stump94616463st_ump
stumps104912283stumps
stums75320083st_ums
sturdy1037043sturdy
sty66227313st___y
stymie1137623stymie
suety85318493sue_ty
summa94713313s_umma
swampy16437233swampy
swamy136714403s_wamy
sweaty123710053sweaty
sweeny12358843sweeny
sweepy14447453sweepy
team66238653_team_
teams75726513_teams
teary85124053_teary
techy135612013_techy
teddy10489493_teddy
teem66132603_teem_
teems76019783_teems
teeny85417883_teeny
telly84920823_telly
temp85323333_te_mp
tempi94912203_tempi
tempo95214973_tempo
temps95417133_temps
tempt95124843_tempt
tenty86121603_tenty
tepoy10312163_tepoy
term66233153_term_
termly1138433_termly
terms75523473_terms
terry84721873_terry
testy85419063_testy
thymy16437923_thymy
whammy19375293whammy
yummy15429153_yummy

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.1731032896.0
2DLD Change Limit1127162766.64016975.3
3Display Results2762760.0932967.7
 (SQL Overall)1786912766.90625874.7
 
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.