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

408 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
marques18261086(None) 
barques18259641barques
marque172410501marque_
marquee18218581marquee
marquees19206241marquees
marquess19204951marquess
marquis18247061marquis
masques18239361masques
argues74516412_argues
baroques1934862baroques
barque17239552barque_
basques18248672basques
caiques18248792caiques
calques182710192calques
casques18278982casques
cirques1836462cirques
macaques2143952macaques
manque17259512manque_
maquis17249482ma_quis
marauds1037552marauds
marbles114516652marbles
marches143921172marches
mares76457632mar__es
marges94525712mar_ges
marines93928012marines
markups1534962markups
marquise19206172marquise
marquises20225702marquises
marries93825282marries
marses84827112mar_ses
marshes123615372marshes
masque17249382masque_
masquer18266462masquer
masquers19195702masquers
morgues1038272morgues
mosques18256912mosques
parquet18311582parquet
parquets1936412parquets
remarques2093392remarques
sacques18106862sacques
torques16217512torques
acquest1837173_acquest
agues64919053_a_gues
amarones10311353amarones
aquas142412613_a_quas
arames84622573_arames
arbutes939703_arbutes
arches114822043_arches
arcus76918863_arcu_s
arcuses94814693_arcuses
arenes64928393_arenes
ares45871023_ar__es
aretes64425353_aretes
argles75218483_argles
argue64818443_argue_
argued84311173_argued
arguer74510543_arguer
arguers8489033_arguers
argus66716543_argu_s
arguses84711743_arguses
arises65233803_arises
arles56735743_ar_les
armies85123693_armies
armures9510273_armures
arouse65019983_arouse
arouses74921293_arouses
arquebus1942263_arquebus
arses55733873_ar_ses
arums75517833_ar_ums
banquet1839783banquet
banquets1935433banquets
barbeques22103873barbeques
barbes104526233bar_bes
barbies114519593barbies
barbules1238043barbules
barbuts11439843barbuts
bardes95026933bar_des
bareges105212033bareges
bares75457133bar__es
bargees105415873bargees
barges94528253bar_ges
barguest1137163barguest
barites94322333barites
bariums1139143bariums
baroque1835103baroque_
barres84427543bar_res
baryes116218503bar_yes
barytes124611153barytes
basque17259083basque_
battues94610193battues
bisques18236893bisques
bosques18217973bosques
caciques21165373caciques
caique17318803caique_
calque17289843calque_
calqued19306523calqued
cangues10611823cangues
carafes125015703carafes
carates95630613carates
cares77369183car__es
carfuls1249133carfuls
cargoes104415223cargoes
caribes113715643caribes
carices114220953carices
caries85147623car_ies
carles85435083car_les
carnies94123963carnies
carouse9614423carouse
carouses10614503carouses
carpus105514303carpu_s
carries94328013carries
carses85233653car_ses
cartes86239473car_tes
carves115128453car_ves
casque17299273casque_
casqued19235633casqued
caziques28193773caziques
charquis2243933charquis
cheques2136863cheques
cinques1837333cinques
cirque1735853cirque_
claques18279013claques
cliques18309203cliques
cloques18268563cloques
darbies104216983darbies
dares66146703dar__es
darkies124015753darkies
darkles124011933darkles
dartles84014133dartles
earbuds1044633earbuds
earfuls1036863earfuls
embrues1136473embr_ues
farces115223323far_ces
farcies125317883farcies
fares85852873far__es
farles96025783far_les
fiques1837973_fiques
gangues9149753gangues
garages9314113garages
garbles104016923garbles
gargles94214893gargles
garigues1034953garigues
garotes8614563garotes
grues65721963_gr_ues
hardies114923233hardies
hares86255543har__es
harpies123818323harpies
harquebus2351533harquebus
harries103525493harries
imbrues1135503imbr_ues
jarfuls1754773jarfuls
karates115617473karates
lacquer18135153lacquer
lacquers19125033lacquers
lacquey21143803lacquey
lacqueys22132693lacqueys
laliques1744833laliques
langues81211913langues
larches124416453larches
larees65323113lar_ees
lares54852633lar__es
larges74824233lar_ges
larrups934733larrups
larums83610533lar_ums
mabes96331533ma__bes
macaque2044053macaque_
maces97139963ma__ces
maches134827233ma_ches
mackles154415753mackles
macles107023223ma_cles
macrames1438953macrames
macules114015133macules
madames12310063madames
madrases112610003madrases
madres93718183ma_dres
madrones112912283madrones
maes66948403ma___es
mages85036023ma__ges
magnums1234683magnums
magpies12310363magpies
maguey1236833ma_guey
magueys1333943ma_gueys
magus85318753ma_gu_s
mahoes11313103ma_hoes
mahouts1237143mahouts
mailes84329113ma_iles
maizes175115733ma_izes
makes115336853ma__kes
makeups1533603makeups
malates93522613malates
males75049793ma__les
malices114316623malices
malines93625603malines
mallees93315973mallees
malleus92911313malleus
mamboes135011823mamboes
mameyes14376983mameyes
mamies104626243ma_mies
mamluks1543313mamluks
mammees104411143mammees
mammies104314763mammies
manages103418963manages
manches143818623manches
maneges103612143maneges
manes76648963ma__nes
manges94628943ma_nges
mangles104021463mangles
mangoes104316133mangoes
manropes1237913manropes
manses84225513ma_nses
mantes84430783ma_ntes
mantles94820703mantles
mantuas93410993mantuas
manures9313353manures
manus75924933ma_nu_s
maples104819423ma_ples
maqui16249953ma_qu_i
maracas11313773maracas
maras75443293mar__as
maraud938943marau_d
marauded1244333marauded
marauder1144553marauder
marauders1244263marauders
marble104219103marble_
marbled123212113marbled
marbler113511673marbler
marblers12319233marblers
marcel103714853mar_cel
marcels113212373marcels
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marchers153710813marchers
marchesa15346883marchesa
marchese15358913marchese
marchesi15337323marchesi
marcs95726623mar__cs
mare64759333mar__e_
margays1337493margays
marge85328333mar_ge_
margins103815193margins
marinas93519393marinas
marine84230403marine_
mariner93315993mariner
mariners103113863mariners
marishes13512553marishes
markas124717003mar_kas
marked133921623mar_ked
marker124420393mar_ker
markers133516103markers
market123226043mar_ket
markets133314033markets
markkas12356083markkas
marks115933483mar__ks
markup1436903marku_p
marled95523163mar_led
marlier92614773marlier
marliest102415183marliest
marlines103818713marlines
marlins93420473marlins
marlites103415263marlites
marls75535163mar__ls
marmites122212793marmites
marmots11311513marmots
maroons92615553maroons
marquesses2143353marquesses
marquetry2362613marquetry
marrams11310123marrams
marred95421043mar_red
marrer83716673mar_rer
marrers93414313marrers
married104715303married
marrieds11288073marrieds
marrier93817523marrier
marriers103312473marriers
marrons93216973marrons
marrows122911823marrows
mars66261873mar___s
marse76231153mar_se_
marted94425213mar_ted
marten84518263mar_ten
martens93714953martens
martins93322063martins
martlet93419153martlet
martlets103310483martlets
marts77442233mar__ts
martyrs1234893martyrs
marvel113712003mar_vel
marvels123810093marvels
mashes115030003ma_shes
mashies12318253mashies
masses85028713ma_sses
matches143219783matches
mates75251363ma__tes
matres84522233ma_tres
matrices12312083matrices
matrixes1738063matrixes
mattes85624533ma_ttes
matures9314313matures
mauds85519273ma__uds
mauls76524953ma__uls
mauts75927193ma__uts
mauves113811553ma_uves
mavies114923193ma_vies
mavises122812993mavises
maxes145629533ma__xes
maxixes1535253maxixes
maybes1339243ma_ybes
mazes165632173ma__zes
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122493mer_ges
merises93421423merises
merles85322763mer_les
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
miscues11312393miscues
morales93619403morales
mores76249643mor__es
moresques2042873moresques
morgue938113morgue_
mosque17287163mosque_
moues75732843m__oues
mures75937223mur__es
murexes1636973murexes
murices112612283murices
murines93718223murines
murmurs1134523murmurs
murres85019043mur_res
murries94118673murries
myrtles1235733myrtles
nares55544153nar__es
opaques1833643opaques
parades104121463parades
paraquet1948783paraquet
paraquets2044593paraquets
parches143720003parches
pares77164483par__es
pareses94718883pareses
pareus85420743pareu_s
parges94529543par_ges
paries84742513par_ies
parises94827183parises
parles86334403par_les
paroles95025883paroles
paroquet1947283paroquet
paroquets2043643paroquets
parous84024163parou_s
parries93925843parries
parses85534703par_ses
parties93230863parties
parures9512693parures
perdues103511333perdues
periques1937653periques
piques1739093_piques
piroques1944353piroques
plaques18317893plaques
pulques1835323pulques
pursues94111373pursues
racquet1838743racquet
racquets1944763racquets
rares55247443rar__es
reargues936713reargues
remarque1993553remarque_
roques154912563_roques
roues56039353__roues
rues46044483__r_ues
sacque17107113sacque_
sarapes94617753sarapes
sarees65329943sar_ees
sarges75128593sar_ges
sarodes84216143sarodes
saroses73619333saroses
smarties10312873smarties
sprues84515763spr_ues
tardies84225863tardies
tares57456563tar__es
targes74524593tar_ges
tarres64723043tar_res
tarries73324263tarries
tarsus6310513tarsu_s
tartufes1164153tartufes
toques154612353_toques
torque15237673torque_
torqued17224893torqued
torquer16205323torquer
torquers17204303torquers
trues54925323_tr_ues
tuques15358373_tuques
uniques1667443uniques
usques15126803_usques
values94314943va_lues
varices123313573varices
varies94330873var_ies
varus85921183var_u_s
varuses10310623varuses
varves124414783var_ves
virtues10338023virtues
warbles123215563warbles
wares88250583war__es
warmups1433813warmups
warsles103413643warsles
yanquis1943723yanquis

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.406440125.6
2DLD Change Limit1340274086.98319193.3
3Display Results4084080.1562615.4
 (SQL Overall)1786914087.54523683.4
 
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.