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

180 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
murrha1136645(None) 
murra74519081murr_a
murrhas12286161murrhas
durra65315792durr_a
hurrah12369182hurrah
mudra83912432mudr_a
mura65633292mu_r_a
murphy1654342murphy
murr65225132murr__
murras84916002murras
murre74821072murr_e
murres85019042murres
murrey114312252murrey
murrs75521292murr_s
murry105120232murr_y
myrrh1337092myrrh_
myrrhs1443592myrrhs
surra55521342surr_a
aura45836253au_r_a
aurora6411763aurora
bertha11429173bertha
buddha1333173buddha
bugsha1233823bugsha
buqsha2032793buqsha
bura66139533bu_r_a
burgh115216033burgh_
burghal1335073burghal
burghs12519923burghs
burka114617693bu_rka
burqa165013093bu_rqa
burr65631233burr__
burred95820723burred
burrer83718473burrer
burro75018493burr_o
burros85114993burros
burrow114610803burrow
burrs74925653burr_s
burry105221563burr_y
bursa74921523bu_rsa
crura7312583crur_a
curara83712203curara
curch124415413curch_
curia74523763cu_ria
curr65429653curr__
curran8312023curran
curred94319263curred
currie84317253currie
currs75624393curr_s
curry105920343curr_y
dura55232113du_r_a
durr55624353durr__
durras74713373durras
durrie73713253durrie
durrs65519993durr_s
eureka1034483eureka
furred104514433furred
furrow12427743furrow
furry116719283furr_y
gurry94515413gurr_y
gursh94512333gursh_
hurrahs13336773hurrahs
hurray12459913hurray
hurry114917183hurr_y
jarrah1636683jarrah
jura116024893ju_r_a
kerria10339913kerria
kurta95113913ku_rta
lurch104814633lurch_
maltha1137503maltha
mara67444563m_ar_a
maraca10314153maraca
march125622893march_
maria75032883m_aria
marina84623413marina
marka114620793m_arka
markka11416593markka
marram10313883marram
marred95421043marred
marrer83716673marrer
marron83717543marron
marrow112812603marrow
marry104821693marr_y
marsh105320853marsh_
marshal1238973marshal
marshy14558333marshy
mbira977973mbir_a
merch125417963merch_
merry104721483merr_y
micra96214973micr_a
mikra114610313mikr_a
mirror848003mirror
mirth106418893mirth_
mirths114912993mirths
mirza16410443m_irza
mocha1249923m_ocha
moira71012023moir_a
mora66641273m_or_a
morph121712513morph_
morphia1447473morphia
morpho13158443morpho
morphs13149433morphs
morris83814723morris
morro73216953morr_o
morros83714673morros
morrow113510093morrow
morula8710473morula
much115224033mu_ch_
mucho125013443mu_cho
mucosa10166273mucosa
mucro94513723mucr_o
mudras94212253mudras
mughal1236263mu_ghal
mulch124012973mulch_
muleta839233muleta
mulla74317113mu_lla
mullah113710733mullah
munch124917103munch_
mural75225103mu_ral
murals84016753murals
muras75329563mu_ras
murder93613783murder
mure65941333mu_r_e
mured85726703mu_red
murein8311763murein
mures75937213mu_res
murex145517173mu_rex
murid84520583mu_rid
murids93212193murids
murine84220023murine
muring95120373muring
murk105527253mu_r_k
murker123715243murker
murkly15368303murkly
murks114821723mu_rks
murky145216683mu_rky
murmur1034853murmur
murrain937753murrain
murreys12367323murreys
murrhine1344313murrhine
murries94118673murries
murrine9411473murrine
murther1237953murther
musca9311763mu_sca
mush94929123mu_sh_
mushy135316633mu_shy
musth105314783musth_
musths11589483musths
mutch125016173mutch_
myrica1336823myrica
myrrhic1743753myrrhic
nucha10229793nu_cha
nutria639903nutria
orra46120723_orr_a
purana8712933purana
purda82914693pu_rda
purdah12288753purdah
purr64925813purr__
purred94218073purred
purrs75320433purr_s
quotha18365113quotha
qursh174110843qursh_
sirra54416323sirr_a
sirrah9379753sirrah
sulpha1135403sulpha
supra73614253supr_a
sura45740293su_r_a
surah86823253surah_
surahs94515543surahs
surras65919533surras
surreal739223surreal
surrey94414573surrey
sutra54217933sutr_a
terra54419653terr_a
turret63121853turret
umbra948513umbr_a
urbia7311143_urbia
urea46528053_u_rea
ursa44116903_u_rsa
wirra83210823wirr_a
yurta86014253yu_rta

Search took 6 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.1261418182.5
2DLD Change Limit1127161805.50020493.8
3Display Results1801800.0632857.1
 (SQL Overall)1786911805.68931409.9
 
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.