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

293 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
stemmers1237844(None) 
stammers123611521stammers
steamers103410871steamers
stemmer113210181stemmer_
stemmery15334691stemmery
emmers104013222__emmers
hemmers143310842_hemmers
scammers14339772scammers
scummers14277782scummers
seamers94719432s_eamers
seemers93814332s_eemers
shammers153710842shammers
shimmers15269412shimmers
simmers113314612s_immers
skimmers16296462skimmers
slammers123511222slammers
slimmers12369632slimmers
slummers12358932slummers
spammers14378692spammers
stammels12495562stammels
stammer116013342stammer_
stampers124211602stampers
stealers83412212stealers
steamer93313092steamer_
steepers103011372steepers
steerers82511352steerers
steers63820982ste__ers
stemless1036652stemless
stemmas11256972stemm_as
stemmed12278152stemme_d
stemmeries1445182stemmeries
stemmier1245252stemmier_
steppers12289282steppers
stompers123610042stompers
streamers11228082streamers
strummers1333692strummers
stumpers12318312stumpers
summers113616502s_ummers
swimmers15276692swimmers
teemers95012902_teemers
tempers113513012_tempers
termers95414502_termers
ateliers837903ateliers
attempers13103503attempers
brimmers14287073brimmers
bummers133712443_bummers
clammers143510693clammers
crammers14369353crammers
creamers124111313creamers
crimmers14298543crimmers
cummers133713483_cummers
dammers123214273_dammers
dimmers123811563_dimmers
distempers1544293distempers
dreamers11369003dreamers
drummers13316163drummers
embers104116183__embers
emeers83314183__emeers
emmer94314463__emmer_
emmets10349153__emmets
femmes135410213_femme_s
gammers123214563_gammers
gleamers11306563gleamers
glimmers13396153glimmers
gummers123712203_gummers
hammers144216063_hammers
hemmer134112643_hemmer_
hummers143813063_hummers
itemizers20133293itemizers
jammers183710703_jammers
klezmers2341583klezmers
krimmers16315673krimmers
limmers113413083_limmers
mammers104615693_mammers
members13258603_members
metamers1249623metamers
mummers103712843_mummers
premiers122911653premiers
rammers113715043_rammers
reamers94221083_reamers
retempers1345023retempers
rimmers113812883_rimmers
rummers113513653_rummers
scammer133611973scammer_
scampers143611033scampers
scepters1237803scepters
schemers1576713schemers
schmeers1574833schmeers
screamers13236263screamers
scummer13398753scummer_
sealers74323553s_ealers
seamer84223613s_eamer_
seaters74028943s_eaters
seders74420283s_e_ders
seeders83017113s_eeders
seekers113712333s_eekers
seemer84418043s_eemer_
seers55136383s_e__ers
seiners74219273s_einers
seisers73816393s_eisers
seizers164112503s_eizers
sellers73721323s_ellers
sememes11109203s_ememes
semens84616973s_e_mens
semes75731583s_e_me_s
senders83022353s_enders
sergers83815633s_ergers
servers103214833s_ervers
setters73822063s_etters
settlers8289023settlers
severs94121123s_e_vers
sewers94719723s_e_wers
shammer144613143shammer_
shammes144312833shamme_s
shearers113911323shearers
shedders13267433shedders
sheers94322403she__ers
sheeters113111863sheeters
shellers112812583shellers
shelters113412813shelters
shelvers14388813shelvers
shewers134312053she_wers
shimmer143310873shimmer_
shimmery18265253shimmery
siemens938413sie_mens
simmer104115353s_immer_
simpers113014123s_impers
skeeters12298963skeeters
skelters12349373skelters
skewers14498383ske_wers
skimmer15327533skimmer_
slammer113913033slammer_
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
slimmer114211343slimmer_
slumbers123110273slumbers
slummer113711203slummer_
smearers10308623smearers
smellers10329773smellers
smelters103310513smelters
sneakers12308643sneakers
sneerers8309803sneerers
sneers64016173sne__ers
sneezers17246143sneezers
spammer133410433spammer_
speakers14299453speakers
spearers103711143spearers
specters122811063specters
speeders11339313speeders
speers85019953spe__ers
spellers102812763spellers
spelters103912243spelters
spencers12269193spencers
spenders113211743spenders
spewers124210663spe_wers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673st_agers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483st_amens
stammel11607533stamme_l
stammered1444643stammered
stammerer1344063stammerer
stammerers1443133stammerers
stamper113714403stamper_
standers93514303standers
staplers103111203staplers
starers74522313st_arers
starkers123712393starkers
starters83714783starters
starvers11459643starvers
staters73922343st_aters
stayers103813633st_ayers
steadiers1035083steadiers
stealer72913983stealer_
steamed103712143steame_d
steamered1244913steamered
steamier1048303steamier_
steams84916903steam__s
steeds73814883ste__eds
steeks103613703ste__eks
steels64117983ste__els
steepens10277113steepens
steeper93812773steeper_
steeps85215193ste__eps
steer55423863ste__er_
steerer73113633steerer_
steeves103410903steeve_s
steles63725663ste_le_s
stemma10328133stemm__a
stemmata1244213stemmata
stemmiest1335143stemmiest
stemming13408203stemming
stemmy13417033stemm__y
stems75219953ste_m__s
stemsons1045003stemsons
stemware1344883stemware
stemwares1444523stemwares
stentors839753stentors
stepper113010853stepper_
steppes113110693steppe_s
stereos74314973ste_reos
steres63929533ste_re_s
sterlets8169273sterlets
sterner7411913sterner_
stertors8310933stertors
stickers142913033stickers
stiflers11238833stiflers
stimes85920573st_ime_s
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312763stinters
stirrers8266943stirrers
stivers103613543st_ivers
stockers143411073stockers
stokers114515183st_okers
stomper114111233stomper_
stoners74817963st_oners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373st_opers
stoppers123910593stoppers
storers75018683st_orers
stovers103713733st_overs
strafers11379913strafers
strayers113510143strayers
streakers13218143streakers
streamer10239513streamer_
streekers13195813streekers
strewers11409073strewers
striders94412123striders
strikers123611293strikers
stripers103911593stripers
strivers113911843strivers
strokers123910913strokers
stroyers11388933stroyers
strummer1234783strummer_
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumblers1334383stumblers
stummed12348553stumme_d
stumper113610093stumper_
stunners8277923stunners
stutters83210473stutters
stylers10359353st_ylers
stymies1239213stymie_s
summer104017713s_ummer_
summery14329413s_ummery
swampers15317473swampers
swarmers1346323swarmers
swearers11328583swearers
sweaters113811063sweaters
sweepers13348163sweepers
swelters113110193swelters
swervers1455213swervers
swimmer14297653swimmer_
tamers84224033_t_amers
tampers113516743_tampers
tearers75218233_tearers
teasers75317243_teasers
tedders94010233_tedders
teemer85515743_teemer_
teeners74415453_teeners
teeters74018303_teeters
telfers10299083_telfers
tellers73717613_tellers
tempehs14325153_tempehs
temper103914093_temper_
tempera11329043_tempera
temperas12278233_temperas
tempters12257293_tempters
tenders83719723_tenders
tenners74014923_tenners
tenters73921113_tenters
termer85717253_termer_
termors94712773_termors
testers74124543_testers
tethers103815313_tethers
tetters74320473_tetters
timbers113111853_timbers
timers84420993_t_imers
trimers94615143_trimers
trimmers12288913trimmers
tsimmes1133673tsimme_s
tummlers12295703_tummlers
yammers143410323_yammers

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 Filter1786911461620.470380193.6
2DLD Change Limit1461622937.31319986.6
3Display Results2932930.1232382.1
 (SQL Overall)1786912937.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.