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

178 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
murmurs113452(None) 
murmur1034851murmur_
bemurmurs1551132bemurmurs
muggurs11315102muggurs
mummers103712842mummers
mumus95517282mu_mu_s
murders103311362murders
murmured1343112murmured
murmurer1242872murmurer
murmurers1342672murmurers
murmurous1343182murmurous
murrs75521292mur__rs
muumuus1141762muumuus
armers85520273_armers
armors85017813_armors
armours9389843_armours
armure8710133_armure
armures9510273_armures
augurs7399963au_gurs
aureus65314883aureu_s
aurous64119263aurou_s
aurums849383aur_ums
auteurs7137503auteurs
bemurmur1441313bemurmur_
bulgurs10397113bulgurs
bummers133712443bummers
burgers103918573burgers
buriers94017193buriers
burkers133716623burkers
burlers94120273burlers
burners94115673burners
burrers93814493burrers
burrs74925653bur__rs
bursars94510893bursars
cummers133713473cummers
curbers115514373curbers
curers84923183cur_ers
curiums1138503curiums
curlers94218063curlers
currs75624393cur__rs
cursers94317153cursers
cursors93910023cursors
demurs939773_demurs
dormers104313913dormers
durbars1077973durbars
durrs65519993dur__rs
durums948153dur_ums
farmers124315263farmers
femurs1136713_femurs
firmers124711443firmers
formers128217953formers
fulmars1246423fulmars
fumers113613383fu_mers
furfur1235553furfur_
furfures1445663furfures
furlers104214223furlers
furors9310953fur_ors
gummers123712193gummers
gurus64318193gur_u_s
harmers124116593harmers
hummers143813063hummers
hummus1336243hummu_s
humors11129633hu_mors
humours1286413humours
humus106215073hu_mu_s
hurlers103714323hurlers
hurters103413633hurters
jurors1338283jur_ors
kulturs1134723kulturs
kurus98015633kur_u_s
lemurs837253_lemurs
lurers64217493lur_ers
lurkers113910083lurkers
maimers113813043maimers
mammers104615693mammers
marauds1037553marauds
markers133516103markers
markups1534963markups
marmots11311513marmots
marques182610863marques
marquis18247063marquis
marrers93414313marrers
martyrs1234893martyrs
mercers114412773mercers
mercury14364893mercury
mergers103813423mergers
mimers105520183m_imers
mirrors938623mirrors
mohurs1135933m_ohurs
momus96116113m_omu_s
morgues1038273morgues
mortars93411523mortars
mourners1036913mourners
muckers153612793muckers
muclucs1343683muclucs
mucors104410843mu_cors
mucous104411653mucou_s
mucus94015743mu_cu_s
mudbugs1342853mudbugs
mudders113211103mudders
mugfuls1344003mugfuls
muggars11316643muggars
muggers113611933muggers
muggur10325593muggur_
mukluks1242413mukluks
muktuks1242253muktuks
mullers93217303mullers
multure939183multure
multures1039333multures
mummer93614543mummer_
mummery13336663mummery
mummies103812843mummies
mumms85513153mu_m_ms
mumpers133311363mumpers
mumps115619103mu_m_ps
mums85732773mu_m__s
mumu86022063mu_mu__
murals84016753mur_als
muras75329563mur__as
murder93613783murder_
mureins9310733mureins
mures75937213mur__es
murexes1636973murexes
murices112612283murices
murids93212193mur_ids
murines93718223murines
murker123715243murker_
murks114821723mur__ks
murmuring1443623murmuring
murr65225133mur__r_
murra74519083mur__ra
murras84916003mur_ras
murre74821073mur__re
murres85019043mur_res
murreys12367323murreys
murrhas12286163murrhas
murries94118673murries
murry105120233mur__ry
murthers1336543murthers
musers84719093mu_sers
museums1134563museums
mushers124016433mushers
musters94522493musters
mutters94117133mutters
muumuu1042373muumu_u
nursers74311833nursers
nurture736643nurture
nurtures837443nurtures
ormers84316143_ormers
purgers104714003purgers
purpura1144793purpura
purpuras12105073purpuras
purpure1195993purpure
purpures1276143purpures
purrs75320433pur__rs
pursers93916093pursers
pursuers10376523pursuers
pursues94111373pursues
rummers113513653rummers
rumors81110393ru_mors
rumours976363rumours
sulfurs1037343sulfurs
summers113616503summers
surfers103614133surfers
surgers83517483surgers
termers95414503termers
termors94712773termors
tumors8810603tu_mors
tumours976733tumours
turgors836823turgors
turners73912893turners
turnups933893turnups
tussurs7356373tussurs
urgers73313623_urgers
urus46426133_ur_u_s
warmers124514293warmers
warmups1433813warmups
wormers124012573wormers

Search took 10 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.1601116818.8
2DLD Change Limit1340271789.07614767.2
3Display Results1781780.0632825.4
 (SQL Overall)1786911789.29919216.2
 
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.