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

354 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
marrams1131012(None) 
marram10313881marram_
arras55626132_arra_s
arrays95311682_arrays
carroms11512402carroms
jarrahs1735452jarrahs
macrame1338712macrame
macrames1438952macrames
madams11310942ma_dams
madras94316432madra_s
mantrams12288962mantrams
maras75443292ma_ra_s
margays1337492margays
marjorams2043002marjorams
markas124717002marka_s
marrano939422marrano
marranos1038422marranos
marrers93414312marrers
marries93825282marries
marrons93216972marrons
marrows122911822marrows
matrass939402matrass
murras84916012murra_s
parrals94414572parrals
alarms85913053_alarms
amalgams1343203amalgams
amtracs1198883amtracs
anagrams1146593anagrams
araks94820883_a_raks
arame75026623_a_rame
arames84622573_a_rames
areas55935773_area_s
argals75517713_argals
arhats9312973_arhats
arias55438023_aria_s
arms66137493_a_r_ms
aromas81018613_aromas
arrack121110253_arrack
arracks1387733_arracks
arrant6623253_arrant
arrases71214543_arrases
array86317143_arra_y
arrears738843_arrears
arris56824683_arr_is
arrows92813483_arrows
arums75517833_a_rums
ashrams1236653ashrams
asrama839193_asrama
asramas938303_asramas
auras55932563_aura_s
aurums849383_aurums
balsams11579013balsams
bantams1149063bantams
barcas101016603barca_s
bariums1139143bariums
barms96128463ba_r_ms
barograms1445863barograms
barrack1538253barrack
barracks1636883barracks
barrage10710843barrage
barrages11711083barrages
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrios9310773barrios
barrooms1237893barrooms
barrows123411683barrows
breams104815043_breams
carats85929023ca_rats
carcass11310513carcass
caroms105619573ca_roms
carpals113414633carpals
carrack1548753carrack
carracks1637713carracks
carrels95117303carrels
carries94328013carries
carrom10513403carrom_
carrots9714623carrots
carrs75730853carr__s
corrals93713853corrals
crams96229153__crams
creams104715253_creams
currans9310613currans
darbars10510093darbars
diagrams1246133diagrams
dirams94413703_dirams
dirhams13376313dirhams
drams86025833__drams
dreams94513983_dreams
durras74713373durra_s
eardrums11524483eardrums
earlaps936393earlaps
embarrass1342273embarrass
engrams1038073engrams
farads104713273fa_rads
farfals13268503farfals
farms106324953fa_r_ms
farrago1144923farrago
farrows13259783farrows
ferbams1435743ferbams
ferrums1265983ferrums
forams115115913_forams
garrets84413623garrets
garrons82713463garrons
grahams1335333grahams
grams85327313__grams
hammams13386443hammams
harass9313943ha_rass
hardass1139753hardass
hareems12428203hareems
harems115513823ha_rems
harms106829013ha_r_ms
harries103525493harries
harrows132611033harrows
hartals10313023hartals
hurrahs13336773hurrahs
hurrays13386153hurrays
ihrams1137173_ihrams
jagras1438463jagra_s
jarrah1636683jarra_h
jorams154810533_jorams
kalams12310603ka_lams
karats106420493ka_rats
karmas123013733karma_s
karroos1139313karroos
labrums1175853labrums
lactams1136953lactams
lariats7615053lariats
larrups934733larrups
larums83610533la_rums
larvas9310233larva_s
lauras63414333laura_s
maars74621633ma__ars
macadams1545093macadams
macaws1337023ma_caws
macrons113514893macrons
macros104017013macr_os
macrurans1343533macrurans
madam10316223ma_dam_
madame1139853ma_dame
madames12310063ma_dames
madcaps1435243madcaps
madrasa10387883madrasa
madrasas11317763madrasas
madrases112610003madrases
madrassa11274633madrassa
madres93718183madr_es
madtoms1236923madtoms
maenads1037373maenads
mafias113913573mafia_s
magians10310753magians
magmas115512503magma_s
magnums1234683magnums
maihems1444303maihems
mailgrams1443633mailgrams
maims96321793ma__ims
mairs76228303mair__s
makars124612633ma_kars
malars85020683ma_lars
malms95021553ma__lms
mamas95930773ma_ma_s
mambas125716243mamba_s
mammals10389273mammals
mammas94616403mamma_s
manas76240433ma_na_s
manats84623463ma_nats
mandamus1345523mandamus
mangas94122933manga_s
maniacs114313063maniacs
manias84029033mania_s
mannans93611523mannans
mannas85019803manna_s
mantas85725363manta_s
mantram114011603mantram_
mantraps12298063mantraps
mantras93815863mantra_s
manuals9311223manuals
mara67444573ma_ra__
maraca10314153ma_raca
maracas11313773maracas
marasmus1244473marasmus
maraud938943ma_raud
marauds1037553marauds
marbles114516653marbles
marcato1139743marcato
marcatos1249163marcatos
marcels113212373marcels
marches143921173marches
marcs95726623ma_r_cs
maremma1044463maremma
maremme1054603maremme
mares76457633ma_r_es
margay12310593marga_y
marges94525713ma_rges
margins103815193margins
margrave1444793margrave
margraves1544833margraves
maria75032883maria__
marinas93519393marinas
marines93928013marines
marjoram1944143marjoram_
marka114620793marka__
markers133516103markers
markets133314033markets
markkas12356083markkas
marks115933483ma_r_ks
markups1534963markups
marlins93420473marlins
marls75535163ma_r_ls
marmots11311513marmots
maroons92615553maroons
marques182610863marques
marquis18247063marquis
marred95421043marr_ed
marrer83716673marr_er
marriage1147253marriage
marriages1247383marriages
married104715303married
marrieds11288073marrieds
marrier93817523marrier
marriers103312473marriers
marring103319553marring
marron83717543marr_on
marrow112812603marr_ow
marrowy15236083marrowy
marry104821693marr__y
mars66261873ma_r__s
marsala939583marsala
marsalas1038253marsalas
marses84827113ma_rses
marshals1337783marshals
marshes123615373marshes
martens93714953martens
martians103111613martians
martins93322063martins
marts77442233ma_r_ts
martyrs1234893martyrs
marvels123810093marvels
masas75630413ma_sa_s
massas85116463massa_s
matres84522233matr_es
matrons93517633matrons
matsahs1236563matsahs
mattrass1045863mattrass
matzahs2134483matzahs
matzas1749703matza_s
maxims17399673ma_xims
mayas105924383ma_ya_s
maydays1634493maydays
mayhems1763413mayhems
mazards1937703mazards
mazumas2034623mazumas
mbiras1077153mbira_s
megrims1276103megrims
mihrabs1444203mihrabs
mirrors938623mirrors
mirzas1738183mirza_s
mojarras1742253mojarra_s
morals85324643m_orals
moras76438783m_ora_s
morass84614503m_orass
morays114613883m_orays
morgans10310123morgans
morris83814733morr_is
morros83714673morr_os
morrows12318723morrows
mortals93914013mortals
mortars93411523mortars
mudras94212263mudra_s
murals84016763m_urals
muras75329583m_ura_s
murra74519083murra__
murrain937763murrain
murrains1036853murrains
murres85019043murr_es
murreys12367323murreys
murrhas12286173murrhas
murries94118673murries
murrs75521303murr__s
myriads1334353myriads
myrrhs1443603myrr_hs
nairas6312783naira_s
narrate7313493narrate
narrates8312763narrates
narrows10258843narrows
narwals1036983narwals
pangrams1337153pangrams
paramo102614643pa_ramo
paramos113213513pa_ramos
paras76143043pa_ra_s
pardahs13289673pardahs
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parlays123910453parlays
parral85517533parra_l
parrels94713493parrels
parries93925843parries
parrots9312743parrots
parrs75928673parr__s
partans94418283partans
paruras9310533parura_s
praams10459643_praams
prams96125513__prams
rams65950773___rams
reams75729623__reams
roams74919613__roams
sabras85116363sabra_s
sacrals93311793sacrals
sacrums11388043sacrums
salaams997703salaams
sarans64224433sa_rans
sarcasm1136693sarcasm
sarcasms1244983sarcasms
sardars83112903sardars
sarsars73512143sarsars
satraps95011643satraps
scrams105216623_scrams
screams114810623screams
sirrahs10377303sirrahs
sirras63814863sirra_s
smarms105712533sma_r_ms
smartass1044273smartass
streams94713373streams
surras65919533surra_s
tagrags936123tagrags
tangrams1136163tangrams
tarama8412733ta_rama
taramas9612703ta_ramas
tarmacs1138323tarmacs
tarpans92513533tarpans
tarres64723043tarr_es
tarries73324263tarries
tarsals72512603tarsals
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
terras63516973terra_s
thirams1236823thirams
trams75327673__trams
varas86028193va_ra_s
varias95019903varia_s
varnas94212823varna_s
varooms1248883varooms
warms107726853wa_r_ms
warrant10614243warrant
warrants1168503warrants
warrens103810893warrens
warsaws1335763warsaws
yardarms14123333yardarms
yarrows13277853yarrows
zamarras1943803zamarra_s
zirams17438643_zirams

Search took 8 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.390458182.1
2DLD Change Limit1340273547.14018771.3
3Display Results3543540.1262809.5
 (SQL Overall)1786913547.65623340.0
 
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.