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

450 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
marram1031388(None) 
marrams11310121marrams
arras55626132_arras
array86317142_array
carrom10513402carrom
jarrah1636682jarrah
macrame1338712macrame
madam10316222ma_dam
madras94316432madras
mantram114011602mantram
mara67444572ma_ra_
maras75443292ma_ras
margay12310592margay
maria75032882maria_
marjoram1944142marjoram
marka114620792marka_
markas124717002markas
marrano939422marrano
marred95421042marred
marrer83716672marrer
marron83717542marron
marrow112812602marrow
marry104821692marr_y
murra74519082murra_
murras84916012murras
parral85517532parral
aarrgh10786303aarrgh
abeam9316533_abeam
alarm76621423_alarm
amalgam1244923amalgam
amarna839793amarna_
amoral8314633amoral
amtrac10109123amtrac
anagram1058193anagram
arak86929573_a_rak
arame75026623_a_rame
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
argal65023393_argal
arhat8327093_arhat
aria46245423_aria_
arias55438023_arias
arm58449623_a_r_m
aroma71220143_aroma
arrack121110253_arrack
arrant6623253_arrant
arrays95311683_arrays
arrear6310253_arrear
arris56824683_arris
arrow83414883_arrow
artal55525473_artal
arum66129033_a_rum
arval86017013_arval
ashram1139053ashram
asrama839193_asrama
aura45836253_aura_
aurae54128113_aurae
aural54428963_aural
aurar54420253_aurar
auras55932563_auras
aurum7614963_aurum
balsam105612233balsam
bantam10314063bantam
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
barium10313513barium
barm86739603ba_r_m
barman103519703barman
barogram1346533barogram
barrack1538253barrack
barrage10710843barrage
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barret84930483barret
barrio8312573barrio
barroom1139373barroom
barrow114512763barrow
bream95121813_bream
carat75048793ca_rat
carman103920743carman
carnal83919203carnal
carom95025563ca_rom
carpal103716253carpal
carr65434703carr__
carrack1548753carrack
carrel84718633carrel
carroms11512403carroms
carrot8423123carrot
carrs75730853carr_s
carry105823783carr_y
corral83616253corral
cram85635493__cram
cream95721353_cream
curran8312023curran
darbar959953darbar
diagram1147363diagram
diram84419473_diram
dirham12378273dirham
dram75832003__dram
dream85120393_dream
durra65315793durra_
durras74713373durras
eardrum10135423eardrum
earlap837183earlap
earwax1664733earwax
engram9310653engram
farad95720673fa_rad
farfal123410183farfal
farm95934533fa_r_m
farrago1144923farrago
farrow12309973farrow
ferbam1339003ferbam
ferrum1147453ferrum
foram105124933_foram
garda7316763garda_
gardai839663gardai
garred85217403garred
garret74426553garret
garron73113493garron
graham1237853graham
gram77034583__gram
hammam12419333hammam
hareem114312063hareem
harem104924453ha_rem
harm95637793ha_r_m
harrow122610773harrow
harry115322953harr_y
hartal9415473hartal
hurrah12369183hurrah
hurray12459913hurray
ihram10310183_ihram
jagra1338173jagra_
jagras1438463jagras
jarrahs1735453jarrahs
jarred144613253jarred
joram145816983_joram
kalam11315113ka_lam
karat96837593ka_rat
karma113415003karma_
karmas123013733karmas
karroo10410013karroo
labra75415463labra_
labrum1057423labrum
lactam10310943lactam
lariat6629043lariat
larrup835713larrup
larum74317973la_rum
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
maar66025063ma__ar
maars74621633maar_s
macadam1446853macadam
macaw12311763ma_caw
macrames1438953macrames
macro94718173macr_o
macron103615673macron
macros104017013macros
macrural1244963macrural
macruran1244013macruran
madame1139853ma_dame
madams11310943ma_dams
madcap1336333madcap
madman113712383madman
madrasa10387883madrasa
madre85720173madr_e
madres93718183madres
madtom1138023madtom
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magma104513573magma_
magmas115512503magmas
magnum1136733magnum
maihem1366213maihem
mailgram1344413mailgram
maim85831493ma__im
mair66133783mair__
mairs76228303mair_s
makar115614973ma_kar
makars124612633makars
malar76424443ma_lar
malars85020683malars
malm85129983ma__lm
mama86231593ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammas94616403mammas
mana65341963ma_na_
manas76240433ma_nas
manat76039993ma_nat
manga85026203manga_
mangas94122923mangas
mania75634153mania_
maniac103917973maniac
manias84029033manias
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manta75629913manta_
mantas85725363mantas
mantra84116093mantra_
mantrams12288963mantrams
mantrap11379823mantrap
mantras93815863mantras
manual8313463manual
mar57965953ma_r__
maraca10314153maraca
maracas11313773maracas
maraud938943maraud
marble104219103marble
marbly134111933marbly
marc87034633ma_r_c
marcato1139743marcato
marcel103714853marcel
march125622893ma_rch
marcs95726623ma_rcs
mare64759333ma_r_e
maremma1044463maremma
maremme1054603maremme
mares76457633ma_res
margays1337493margays
marge85328333ma_rge
marges94525713marges
margin94016843margin
margrave1444793margrave
marina84623413marina
marinas93519383marinas
marine84230403marine
marish114319053marish
marital92314183marital
marjorams2043003marjorams
mark105138063ma_r_k
marked133921623marked
marker124420393marker
market123226043market
markka11416593markka
markkaa12373923markkaa
markkas12356083markkas
marks115933483ma_rks
markup1436903markup
marl66341623ma_r_l
marled95523163marled
marlin84220903marlin
marls75535163ma_rls
marly106925613ma_rly
marmot10318743marmot
maroon83118203maroon
marque172410503marque
marranos1038423marranos
marrers93414313marrers
marriage1147253marriage
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marrons93216973marrons
marrows122911823marrows
marrowy15236083marrowy
mars66261873ma_r_s
marsala939583marsala
marse76231153ma_rse
marses84827113marses
marsh105320853ma_rsh
marshal1238973marshal
marshy14558333marshy
mart66865983ma_r_t
marted94425213marted
marten84518263marten
martial92415413martial
martian93514683martian
martin84122523martin
marts77442233ma_rts
martyr1135693martyr
marvel113712003marvel
marvy135014033ma_rvy
masa65034723ma_sa_
masas75630413ma_sas
massa75518923massa_
massas85116463massas
matrass939403matrass
matres84522233matres
matrix1539843matrix
matron83918313matron
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
maxim165216003ma_xim
maxima17568633maxima
maya95824593ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
mayday1535883mayday
mayhap1635233mayhap
mayhem1644923mayhem
mayoral1237693mayoral
mazard1838763mazard
mazuma1935603mazuma
mbira977973mbira_
mbiras1077153mbiras
megrim1178043megrim
merman10513863merman
merry104721483merr_y
micra96214973micra_
mihrab1335523mihrab
mikra114610313mikra_
mirror848003mirror
mirza16410443mirza_
mirzas1738183mirzas
mitral81314323mitral
moira71012023moira_
moirai886913moirai
mojarra1642513mojarra_
mojarras1742253mojarras
mora66641273m_ora_
morae75831193m_orae
moral75533433m_oral
moras76438783m_oras
moray105423793m_oray
morgan9311373morgan
morris83814733morris
morro73216953morr_o
morros83714673morros
morrow113510093morrow
mortal84616853mortal
mortar83812043mortar
mudra83912433mudra_
mudras94212263mudras
mura65633303m_ura_
mural75225113m_ural
muras75329583m_uras
murr65225133murr__
murrain937763murrain
murre74821073murr_e
murres85019043murres
murrey114312263murrey
murrha11366453murrha
murrhas12286173murrhas
murrs75521303murr_s
murry105120233murr_y
myriad1235913myriad
myrrh1337093myrr_h
myrrhs1443603myrrhs
naira5314743naira_
nairas6312783nairas
narial6317953narial
narrate7313493narrate
narrow9269143narrow
narwal938943narwal
orra46120723_orra_
pangram1239023pangram
para65242173pa_ra_
parae76335703pa_rae
paramo102614643pa_ramo
paras76143043pa_ras
pardah123412823pardah
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parr65731153parr__
parrals94414573parrals
parred95024073parred
parrel84515983parrel
parrot8320663parrot
parrs75928673parr_s
parry105323753parr_y
partan83820563partan
parura8310583parura_
paruras9310533paruras
praam94815613_praam
pram85733493__pram
ram56867273___ram
ream65841613__ream
roam67132413__roam
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
sacrum103910143sacrum
salaam8711013salaam
saran53730303sa_ran
sarcasm1136693sarcasm
sardar73013173sardar
sarsar63011843sarsar
satrap86212553satrap
scram910621623_scram
scream104814253scream
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
smarm95517603sma_r_m
stream84717293stream
surra55521343surra_
surras65919533surras
tagrag837043tagrag
tangram1038073tangram
tarama8412733ta_rama
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarry85422513tarr_y
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tarzan152910753tarzan
terra54419663terra_
terrae62915213terrae
terras63516973terras
thiram1139963thiram
tram67034553__tram
vagrom1235943vagrom
vara75530883va_ra_
varas86028193va_ras
varia85824203varia_
varias95019903varias
varna84516173varna_
varnas94212823varnas
varoom11411413varoom
warm95935673wa_r_m
warrant10614243warrant
warred104019843warred
warren95012853warren
warsaw1236193warsaw
wirra83210823wirra_
yardarm13114533yardarm
yarrow12287933yarrow
zamarra1843783zamarra_
zamarras1943803zamarras
ziram163912893_ziram

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 Limit1127164505.61020092.0
3Display Results4504500.1403214.3
 (SQL Overall)1786914506.14029102.8
 
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.