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

181 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
markups153496(None) 
markup1436901markup_
backups1736172backups
larrups934732larrups
makeups1533602makeups
marauds1037552marauds
markas124717002mark_as
markers133516102markers
markets133314032markets
markkas12356082markkas
marks115933482mark__s
marques182610862marques
marquis18247062marquis
mockups1733342mockups
walkups1633012walkups
warmups1433812warmups
workups1633612workups
ankus91410683_anku_s
arcus76918863_arcu_s
argues74516413_argues
argus66716543_argu_s
arks85936873_ark__s
arums75517833_ar_ums
backup1646613backup_
barbuts11439843barbuts
barhops14288113barhops
bariums1139143bariums
barkeeps1634143barkeeps
barkers134318513barkers
barks115735813bark__s
barques18259643barques
carfuls1249133carfuls
carhops14329703carhops
carks115534213cark__s
carps96932253car__ps
carpus105514303carpu_s
catsups1135343catsups
cockups1735223cockups
crackups1843123crackups
croups104312553_croups
darkens12409873darkens
darkeys15356533darkeys
darkies124015753darkies
darkles124011933darkles
darks106727873dark__s
earbuds1044633earbuds
earfuls1036863earfuls
earlaps936393earlaps
flareups1342473flareups
fuckups1832923fuckups
groups94210513_groups
haikus13538293haiku_s
hakus125114113ha_ku_s
hangups1364813hangups
harkens144112863harkens
harks126333433hark__s
harps105926873har__ps
hookups1633263hookups
jarfuls1754773jarfuls
jaups144810533ja__ups
karakuls1142083karakuls
kickups1443503kickups
larkers113014513larkers
larks95227813lark__s
larrup835713larrup_
larums83610533lar_ums
layups1133993la_yups
linkups1333633linkups
lockups1534243lockups
lookups1332953lookups
mackles154415753mackles
macks135127603mack__s
madcaps1435243madcaps
magilps1234083magilps
magnums1234683magnums
magus85318753ma_gu_s
mahouts1237143mahouts
makars124612633ma_kars
makers123921733ma_kers
makes115336853ma_k_es
makeup1434863makeup_
makos116518363ma_k_os
makuta1236393ma_kuta
malkins133311803malkins
mamluks1543313mamluks
mantuas93410993mantuas
manus75924933ma_nu_s
maps86141053ma___ps
maquis17249483ma_quis
maracas11313773maracas
maras75443293mar__as
maraud938943marau_d
marbles114516653marbles
marcels113212373marcels
marches143921173marches
marcs95726623mar__cs
mares76457633mar__es
margays1337493margays
marges94525713mar_ges
margins103815193margins
marinas93519383marinas
marines93928013marines
mark105138063mark___
marka114620793mark__a
marked133921623mark_ed
marker124420393mark_er
market123226043mark_et
markhor1635463markhor
markhors1745393markhors
marking144020133marking
markings153410243markings
markka11416593mark_ka
markkaa12373923markkaa
marlins93420473marlins
marls75535163mar__ls
marmots11311513marmots
maroons92615553maroons
marque172410503marqu_e
marquee18218583marquee
marquees19206243marquees
marquess19204953marquess
marquise19206173marquise
marrams11310123marrams
marrers93414313marrers
marries93825283marries
marrons93216973marrons
marrows122911823marrows
mars66261873mar___s
marses84827113mar_ses
marshes123615373marshes
marsupia1242473marsupia
martens93714953martens
martins93322063martins
marts77442233mar__ts
martyrs1234893martyrs
marvels123810093marvels
maskegs14375413maskegs
maskers133913843maskers
masks115320533mask__s
masques18239363masques
matchups1743073matchups
mauds85519273ma__uds
mauls76524953ma__uls
mauts75927193ma__uts
maypops16104453maypops
merks114722403merk__s
mirks115122143mirk__s
mixups1743263m_ixups
mockup1634073mockup_
morgues1038273morgues
murks114821733murk__s
murmurs1134523murmurs
narks96026033nark__s
oakums1264153oa_kums
pareus85420743pareu_s
parkas125018023park_as
parkers133816873parkers
parks116134463park__s
parous84024163parou_s
pickups1754253pickups
rakus94413673ra_ku_s
roups75118903__roups
sannups934463sannups
sarks96632463sark__s
sirups83710533sir_ups
smashups1543213smashups
stackups1643313stackups
startups1033893startups
syrups11277953syr_ups
takeups1333403takeups
tarps76527113tar__ps
tarsus6310513tarsu_s
turnups933893turnups
varus85921183var_u_s
walkup1534193walkup_
warks127932403wark__s
warmup1335343warmup_
warps107126423war__ps
washups1534683washups
workup1534323workup_
yaups105910743ya__ups

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.423422437.4
2DLD Change Limit1340271816.57620381.2
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.06225303.2
 
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.