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 “marcs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

240 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
marcs9572662(None) 
arcs67834781_arcs
macs86742511ma_cs
maras75443281maras
marc87034631marc_
march125622891march
mares76457631mares
marks115933481marks
marls75535161marls
mars66261871mar_s
marts77442231marts
mercs96020451mercs
narcs76122021narcs
arbs66834732_arbs
arc510250902_arc_
arch98628442_arch
arco68331542_arco
arcus76918862_arcus
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
barbs95928192barbs
barca91319432barca
barcas101016602barcas
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
darbs85323262darbs
dares66146702dares
darics94314112darics
darks106727872darks
darns66927892darns
darts67635732darts
earls56127512earls
earns55927562earns
ears46356592ear_s
farce104925322farce
farces115223322farces
farci105919312farci
farcy135217092farcy
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
garbs86321412garbs
gars55750742gar_s
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
jarls126120962jarls
jars117338352jar_s
karns96624142karns
karts97630112karts
lacs66942482la_cs
laics76419252laics
larch105919792larch
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
maars74621632maars
mabes96331532mabes
mac78053932ma_c_
mace87345792ma_ce
maces97139962maces
mach116134482ma_ch
machs125722562machs
mack125733652ma_ck
macks135127602macks
macro94718172macro
macros104017012macros
madras94316432madras
madres93718182madres
mads76845372ma_ds
maes66948402ma_es
mages85036022mages
magics115311612magics
mags75444532ma_gs
magus85318752magus
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mairs76228302mairs
makes115336852makes
makos116518362makos
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
manas76240432manas
manes76648962manes
manics103919932manics
manos74933622manos
mans66354552ma_ns
manus75924932manus
maps86141052ma_ps
mar57965952mar__
mara67444572mar_a
maraca10314152maraca
maracas11313772maracas
marcel103714852marcel
marcels113212372marcels
marches143921172marches
mare64759332mar_e
marge85328332marge
marges94525712marges
maria75032882maria
marish114319052marish
mark105138062mar_k
marka114620792marka
markas124717002markas
marl66341622mar_l
marly106925612marly
marry104821692marry
marse76231152marse
marses84827112marses
marsh105320852marsh
mart66865982mar_t
marvy135014032marvy
mas58175822ma__s
masas75630412masas
masks115320532masks
mass66044942ma_ss
masts77035762masts
match125621102match
mates75251362mates
maths105624022maths
matres84522232matres
mats65460292ma_ts
matts76829182matts
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mavis105622722mavis
maws96437142ma_ws
maxes145629532maxes
maxis145721562maxis
mayas105924382mayas
mayos105521932mayos
mays96940032ma_ys
mazes165632172mazes
merc87225622merc_
merces105720742merces
merch125417962merch
mercy125916182mercy
meres75143572meres
merks114722402merks
merls77423902merls
mics87435152m_ics
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
mocs85834902m_ocs
moras76438772moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
muras75329562muras
mures75937212mures
murks114821722murks
murrs75521292murrs
mycs115314292m_ycs
narc67127952narc_
narco76718242narco
narcos86714202narcos
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
orcs67025432_orcs
pacs85842182pa_cs
paras76143042paras
parch125123002parch
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
rares55247442rares
sacs65739072sa_cs
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
smarms105712532smarms
smarts86218002smarts
talcs74817182talcs
tares57456562tares
tarns56433952tarns
tarocs84615662tarocs
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
torcs75123762torcs
vacs96226202va_cs
varas86028192varas
vars75742072var_s
varus85921182varus
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs

Search took 4 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 Filter178691538000.1101624463.6
2DLD Change Limit538002403.48315446.5
3Display Results2402400.0633809.5
 (SQL Overall)1786912403.65648876.1
 
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.