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

242 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
markup143690(None) 
markups1534961markups
backup1646612backup
larrup835712larrup
makeup1434862makeup
maraud938942maraud
mark105138062mark__
marka114620792mark_a
markas124717002markas
marked133921622marked
marker124420392marker
market123226042market
markka11416592markka
marks115933482mark_s
marque172410502marque
mockup1634072mockup
walkup1534192walkup
warmup1335342warmup
workup1534322workup
ankus91410683_ankus
arcus76918863_arcus
argue64818443_argue
argus66716543_argus
ark77044963_ark__
arks85936873_ark_s
arum66129033_ar_um
backups1736173backups
barbut104617003barbut
barhop13319643barhop
barium10313513barium
bark106242153bark__
barked135027313barked
barkeep1536363barkeep
barker124822863barker
barks115735813bark_s
barky145721613bark_y
barque17239553barque
carful11610973carful
carhop133610763carhop
cark105539273cark__
carked134024823carked
carks115534213cark_s
carp85139813car__p
carpus105514303carpus
cartop104213563cartop
catsup1036433catsup
cockup1635713cockup
crackup1743563crackup
croup95616783_croup
dark95133213dark__
darked123919633darked
darken114013443darken
darker114718693darker
darkey145212423darkey
darkie113714013darkie
darkle113813943darkle
darkly145411073darkly
darks106727873dark_s
darky136018833dark_y
earbud936283earbud
earful958963earful
earlap837183earlap
faceup1334893faceup
flareup1243173flareup
fuckup1733963fuckup
group85413923_group
haiku126113693haiku_
haikus13538293haikus
haku116923893ha_ku_
hakus125114113ha_kus
hangup1277293hangup
hark115237393hark__
harked145422553harked
harken135116343harken
harks126333433hark_s
harp96134293har__p
hookup1534423hookup
jarful1646683jarful
jaup135316423ja__up
karakul1042553karakul
kickup1354133kickup
lark85733863lark__
larked114519473larked
larker104519243larker
larks95227813lark_s
larky125218873lark_y
larrups934733larrups
larum74317973lar_um
layup1037723la_yup
linkup1245123linkup
lockup1434763lockup
lookup1233453lookup
mack125733653mack__
mackle143716433mackle
macks135127603mack_s
madcap1336333madcap
magilp1137613magilp
magnum1136733magnum
magus85318753ma_gus
mahout11415803mahout
makar115614973ma_kar
make105537893ma_k_e
maker114127813ma_ker
makes115336853ma_kes
makeups1533603makeups
mako105622363ma_k_o
makos116518363ma_kos
makuta1236393ma_kuta
malkin122913153malkin
mamluk1434743mamluk
manful11610213manful
manque17259513manque
mantua84412023mantua
manus75924933ma_nus
map77255123ma___p
maqui16249953ma_qui
mar57965953mar___
mara67444573mar__a
maraca10314153maraca
maras75443283mar_as
marauds1037553marauds
marble104219103marble
marbly134111933marbly
marc87034633mar__c
marcel103714853marcel
march125622893mar_ch
marcs95726623mar_cs
mare64759333mar__e
mares76457633mar_es
margay12310593margay
marge85328333mar_ge
marges94525713marges
margin94016843margin
maria75032883mar_ia
marina84623413marina
marine84230403marine
marish114319053marish
markers133516103markers
markets133314033markets
markhor1635463markhor
marking144020133marking
markkaa12373923markkaa
markkas12356083markkas
marl66341623mar__l
marled95523163marled
marlin84220903marlin
marls75535163mar_ls
marly106925613mar_ly
marmot10318743marmot
maroon83118203maroon
marquee18218583marquee
marques182610863marques
marquis18247063marquis
marram10313883marram
marred95421043marred
marrer83716673marrer
marron83717543marron
marrow112812603marrow
marry104821693mar_ry
mars66261873mar__s
marse76231153mar_se
marses84827113marses
marsh105320853mar_sh
marshy14558333marshy
marsupia1242473marsupia
mart66865983mar__t
marted94425213marted
marten84518263marten
martin84122523martin
marts77442233mar_ts
martyr1135693martyr
marvel113712003marvel
marvy135014033mar_vy
mask105227363mask__
masked134316523masked
maskeg13388693maskeg
masker124416103masker
masks115320533mask_s
masque17249383masque
matchup1643513matchup
maud75325403ma__ud
maul64830723ma__ul
maun65727213ma__un
maut65448453ma__ut
mayhap1635233mayhap
maypop1565143maypop
merk106027943merk__
merks114722403merk_s
mirk106729503mirk__
mirker123712693mirker
mirks115122143mirk_s
mirky146315523mirk_y
mixup1636773m_ixup
mockups1733343mockups
morgue938113morgue
murk105527253murk__
murker123715243murker
murkly15368303murkly
murks114821723murk_s
murky145216683murk_y
murmur1034853murmur
nark85230063nark__
narked114116743narked
narks96026033nark_s
narky126017803nark_y
oakum1177313oa_kum
pareu74928743pareu_
pareus85420743pareus
park105237493park__
parka115120883park_a
parkas125018023parkas
parked134425143parked
parker124121373parker
parks116134463park_s
parous84024163parous
pickup1655633pickup
raku85423773ra_ku_
rakus94413673ra_kus
roup66627693__roup
sannup836563sannup
sark84938973sark__
sarks96632463sark_s
sarky125521783sark_y
sirup74014913sir_up
smashup1443453smashup
stackup1533743stackup
startup934963startup
syrup103010963syr_up
takeup1234583takeup
tarp66936413tar__p
tarsus6310513tarsus
turnup835093turnup
varus85921183var_us
walkups1633013walkups
wark115737773wark__
warked144421213warked
warks127932403wark_s
warmups1433813warmups
warp95635003war__p
washup1435323washup
workups1633613workups
yaup96618483ya__up

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.1401276364.3
2DLD Change Limit1127162426.23318083.7
3Display Results2422420.0633841.3
 (SQL Overall)1786912426.43627764.3
 
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.