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

346 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
myrrh133709(None) 
myrrhs1443601myrrhs
march125622892march
marry104821692marry
marsh105320852marsh
merch125417962merch
merry104721482merry
mirth106418892mirth
morph121712512morph
morro73216952morro
murr65225132murr_
murra74519082murra
murre74821072murre
murrha11366452murrha
murrs75521302murrs
murry105120232murry
mynah13569562mynah
myrrhic1743762myrrhic
myth126715432my_th
aargh96314083aargh
aarrgh10786303aarrgh
airth85621023airth
arch98628443_arch
ayah108022993ay_ah
barre75929543barre
berry104521773berry
berth104917883berth
birch124914023birch
birr66022363birr_
birrs74917103birrs
birth105619873birth
brr56921923_brr_
brrr65312293_brrr
burgh115216033burgh
burr65631233burr_
burro75018493burro
burrs74925653burrs
burry105221563burry
byre95023853by_re
byres104421383byres
byrl95716013by_rl
byrls105711233byrls
carr65434703carr_
carrs75730853carrs
carry105823783carry
cirri7710723cirri
curch124415413curch
curr65429653curr_
currs75624393currs
curry105920343curry
derry94721373derry
dorr56627723dorr_
dorrs65520593dorrs
durr55624353durr_
durra65315793durra
durrs65519993durrs
dyer85522113dyer_
dyers96617133dyers
earth85023053earth
err35626533_err_
errs45622533_errs
eyer76127283eyer_
eyers86521333eyers
eyra76217553ey_ra
eyras84715923eyras
eyre75525253ey_re
eyres84921773eyres
eyrie88117833eyrie
eyrir8359653eyrir
eyry106315883ey_ry
ferry116020803ferry
firry115713533firry
firth115819533firth
forth116222673forth
furry116719283furry
garth94720223garth
gerah9315303gerah
girsh95310023girsh
girth95618843girth
gurry94515413gurry
gursh94512333gursh
gyral94412783gyral
gyre84722763gy_re
gyred105114093gyred
gyres94820323gyres
gyri85415153gy_ri
gyro85217883gy_ro
gyron95314623gyron
gyros95616483gyros
gyrus95310803gyrus
harry115322953harry
harsh116418053harsh
herry114922473herry
horah117922053horah
hurrah12369183hurrah
hurry114917183hurry
hydra12249223hydra
hydro12259423hydro
hyrax1838033hyrax
jarrah1636683jarrah
jerry155016183jerry
kerry124916093kerry
kyar116916843kyar_
kyars124813963kyars
kyrie123712903kyrie
larch105919793larch
lorry86315673lorry
lurch104814633lurch
lyard95113213lyard
lyart85121883lyart
lych126015763ly_ch
lycra10317973lycra
lymph1547043lymph
lynch13468983lynch
lyre75623793ly_re
lyres85019963lyres
lyric104512723lyric
maar66025063maar_
maars74621633maars
mach116134483m_ach
macro94718173macro
madre85720173madre
mair66133783mair_
mairs76228303mairs
mar57965953m_ar_
mara67444573m_ara
maras75443293maras
marc87034633m_arc
marcs95726623marcs
mare64759333m_are
mares76457633mares
marge85328333marge
maria75032883maria
marish114319053marish
mark105138063m_ark
marka114620793marka
marks115933483marks
marl66341623m_arl
marls75535163marls
marly106925613marly
marram10313883marram
marred95421043marred
marrer83716673marrer
marron83717543marron
marrow112812603marrow
mars66261873m_ars
marse76231153marse
marshy14558333marshy
mart66865983m_art
marts77442233marts
marvy135014033marvy
mash96039403m_ash
match125621103match
math95437453m_ath
mayor106616623mayor_
mayors115714193mayors
mbira977973mbira
mensh105413563mensh
merc87225623m_erc
mercs96020453mercs
mercy125916183mercy
merde84320123merde
mere67244443m_ere
merer75126233merer
meres75143573meres
merge84523693merge
merit7339183merit
merk106027943m_erk
merks114722403merks
merl65830973m_erl
merle75824373merle
merls77423903merls
mesh96823003m_esh
meth95827843m_eth
metre74821303metre
metro74718803metro
micra96214973micra
micro94715993micro
mikra114610313mikra
milch124413373milch
mir57046773m_ir_
mire66748233m_ire
mired85729223mired
mires75640883mires
mirex146816623mirex
miri66730373m_iri
mirin75023153mirin
mirk106729503m_irk
mirks115122143mirks
mirky146315523mirky
mirror848003mirror
mirs66940573m_irs
mirths114912993mirths
miry96326753m_iry
mirza16410443mirza
mitre75522423mitre
moira71012023moira
moire71017323moire
month104818423month
mooch125313613mooch
moor66628553moor_
moors74923143moors
moory105115793moory
mor56855003m_or_
mora66641273m_ora
morae75831193morae
moral75533433moral
moras76438783moras
moray105423793moray
more67154523m_ore
morel75729093morel
mores76249643mores
morn66237563m_orn
morns75527443morns
moron76925423moron
morpho13158443morpho
morphs13149433morphs
morris83814733morris
morros83714673morros
morrow113510093morrow
mors65950063m_ors
morse76032703morse
mort66758833m_ort
morts75533563morts
mosh95227603m_osh
moth96731333m_oth
mouch124715803mouch
mourn77215013mourn
mouth105420293mouth
much115224033m_uch
mucro94513723mucro
mudra83912433mudra
mulch124012973mulch
munch124917103munch
mura65633303m_ura
mural75225113mural
muras75329583muras
mure65941333m_ure
mured85726703mured
mures75937223mures
murex145517173murex
murid84520583murid
murk105527253m_urk
murks114821733murks
murky145216683murky
murphy1654343murphy
murras84916013murras
murres85019043murres
murrey114312263murrey
murrhas12286173murrhas
mush94929123m_ush
musth105314783musth
mutch125016173mutch
my78125653my___
myc106519503my__c
mycs115314293my_cs
mylar105311533mylar
mylars114310443mylars
myna95815303my_na
mynahs14416443mynahs
mynas105815233mynas
myoid11512993myoid
myoma1239273myoma
myope124010973myope
myopy15457353myopy
myriad1235913myriad
myrica1336833myrica
myrtle1135733myrtle
mysid11610693mysid
myths135911603myths
mythy16568673mythy
north86018273north
nymph1555213nymph
orra46120723_orra
oyer75927653oyer_
oyers87620883oyers
parch125123003parch
parr65731153parr_
parrs75928673parrs
parry105323753parry
perch124518833perch
perry105222713perry
porch125918623porch
purr64925813purr_
purrs75320433purrs
pyran10514473pyran
pyre94925553py_re
pyres105523883pyres
pyrex175211213pyrex
pyric123815073pyric
pyro96019393py_ro
pyros105718293pyros
pyrrhic1744073pyrrhic
pyrrol1136273pyrrol
qursh174110843qursh
rah68052403__rah
serry84824123serry
sirra54416323sirra
sirrah9379753sirrah
smirch1356463smirch
sorry84618253sorry
surah86823253surah
surra55521343surra
sylph1347793sylph
synch135011793synch
synth113711823synth
syph125413273sy_ph
syren85216743syren
syrup103010963syrup
tarre55825633tarre
tarry85422513tarry
terra54419663terra
terry84721873terry
torah87125273torah
torch107420933torch
torr45630903torr_
torrs53923563torrs
tyer75323393tyer_
tyers86220053tyers
tyre75428253ty_re
tyred95816433tyred
tyres84725233tyres
tyro76622363ty_ro
tyros85118593tyros
wirra83210823wirra
worry116114333worry
worth117120523worth
wych154011883wy_ch
yah99046353_y_ah
yar67253833_yar_
yard85633253_yard
yare75636943_yare
yarn75230043_yarn
yeah106725413_yeah
yech127220533_yech
yeh97135773_y_eh
yerk116222083_yerk
yird87018983_yird
yirr76513573_yirr
yirrs8469193yirrs
yirth116513753yirth
yodh119916103_yodh
yogh116616143_yogh
yore76335943_yore
yuch125818533_yuch
yurt76435043_yurt

Search took 5 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 Filter178691836670.376475242.0
2DLD Change Limit836673463.64022985.4
3Display Results3463460.0933720.4
 (SQL Overall)1786913464.10943487.7
 
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.