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

198 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
murmur103485(None) 
murmurs1134521murmurs
bemurmur1441312bemurmur
furfur1235552furfur
muggur10325592muggur
mummer93614542mummer
mumu86022062mu_mu_
mumus95517282mu_mus
murder93613782murder
murker123715242murker
murmured1343112murmured
murmurer1242872murmurer
murr65225132mur__r
muumuu1042372muumuu
armer76924443_armer
armor75118053_armor
armour84411853_armour
armure8710133_armure
augur64311213au_gur
aurar54420253aur_ar
aureus65314883aureus
aurous64119263aurous
aurum7614963aur_um
aurums849383aurums
auteur6107943auteur
bemurmurs1551133bemurmurs
bulgur9387533bulgur
bummer124014103bummer
burger94020793burger
burier84324653burier
burker125221173burker
burler84723833burler
burner83819203burner
burr65631233bur__r
burrer83718473burrer
bursar85413253bursar
cummer124414593cummer
curber104517053curber
curer75030753cur_er
curium10312503curium
curler85221323curler
curr65429653cur__r
curser84721473curser
cursor84110293cursor
curter85320083curter
demur8311163_demur
dormer94415903dormer
durbar968723durbar
durr55624353dur__r
durum8513203dur_um
durums948153durums
farmer115017373farmer
femur1038683_femur
firmer114712443firmer
former114221403former
fulmar1137253fulmar
fumer105918233fu_mer
furler93616403furler
furor8312393fur_or
gummer114615453gummer
guru54623913gur_u_
gurus64318193gur_us
harmer114719553harmer
hummer133615273hummer
hummus1336243hummus
humor101110513hu_mor
humour11116753humour
humus106215073hu_mus
hurler94717223hurler
hurter93915853hurter
juror1239563jur_or
kultur1034433kultur
kuru85521803kur_u_
kurus98015633kur_us
lemur739773_lemur
lurer54625313lur_er
lurker103613293lurker
maimer104514593maimer
mammer94218863mammer
maraud938943maraud
marker124420393marker
markup1436903markup
marmot10318743marmot
marque172410503marque
marrer83716673marrer
martyr1135693martyr
mercer105214203mercer
mercury14364893mercury
merer75126233mer_er
merger95016483merger
merman10513863merman
mermen10813813mermen
mimer94825763m_imer
mirier83918363mirier
mirker123712693mirker
mirror848003mirror
mohur1036513m_ohur
momus96116113m_omus
morgue938113morgue
mortar83812043mortar
mourner938093mourner
mucker143816393mucker
mucluc1245053mucluc
mucor94011943mu_cor
mucous104411653mucous
mucus94015743mu_cus
mudbug1243253mudbug
mudder104413493mudder
mugful1235403mugful
muggar10316443muggar
mugger103914703mugger
muggurs11315103muggurs
mukluk1143503mukluk
muktuk1142883muktuk
muller83820353muller
multure939183multure
mum76643613mu_m__
mumm75718863mu_m_m
mummed104411553mummed
mummers103712843mummers
mummery13336663mummery
mumms85513153mu_mms
mummy114913623mu_mmy
mump105425723mu_m_p
mumper123513523mumper
mumps115619103mu_mps
mums85732773mu_m_s
mura65633303mur__a
mural75225113mur_al
murals84016763murals
muras75329583mur_as
murders103311363murders
mure65941333mur__e
mured85726703mur_ed
murein8311763murein
mures75937223mur_es
murex145517173mur_ex
murid84520583mur_id
murids93212193murids
murine84220023murine
muring95120373muring
murk105527253mur__k
murkier133110273murkier
murkly15368303murkly
murks114821733mur_ks
murky145216683mur_ky
murmurers1342673murmurers
murmuring1443633murmuring
murmurous1343183murmurous
murphy1654343murphy
murra74519083mur_ra
murras84916013murras
murre74821073mur_re
murres85019043murres
murrey114312263murrey
murrha11366453murrha
murrs75521303mur_rs
murry105120233mur_ry
murther1237953murther
muser76024123mu_ser
museum1037703museum
musher113820573musher
muster84724523muster
muter74525543mu_ter
mutter84418883mutter
muumuus1141763muumuus
nurser64314503nurser
nurture736643nurture
ormer75218373_ormer
purer75127903pur_er
purger94717233purger
purpura1144793purpura
purpure1195993purpure
purr64925813pur__r
purser85020473purser
pursue84512253pursue
pursuer9338893pursuer
rummer104715483rummer
rumor71011323ru_mor
rumour8127383rumour
sulfur937913sulfur
summer104017713summer
surer54833103sur_er
surfer93515883surfer
surger74320093surger
termer85717253termer
termor84412513termor
tumor71110693tu_mor
tumour8137403tumour
turgor736863turgor
turner63914613turner
turnup835093turnup
tussur6357293tussur
urger64116473_urger
urus46426143_ur_us
warmer113816733warmer
warmup1335343warmup
wormer114514913wormer

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.390458182.1
2DLD Change Limit1127161985.59620142.2
3Display Results1981980.0633142.9
 (SQL Overall)1786911986.04929540.6
 
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.