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

133 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
marketer143738(None) 
marketed1537321marketed
marketeer1543591marketeer
marketers1545981marketers
darkener1335992darkener
harkener1537572harkener
marker124420392mark__er
market123226042market__
marketeers1643122marketeers
markets133314032market_s
masseter1037062masseter
ammeter1148393_ammeter
arbiter939933_arbiter
arete56031353_ar_ete_
aretes64425353_ar_etes
arrester839253_arrester
barkeep1536363barke_ep
barkeeper1742933barkeeper
barker124822863bark__er
barkier133814483bark_ier
barometer13189043barometer
barrater10310143barrater
barrener1038333barrener
barretor1046713barretor
barter85525373bar__ter
barterer102711633barterer
careener1039323careener
career85822243car_e_er
careerer1038583careerer
carpenter1346493carpenter
carpeted1338953carpeted
carter84932273car__ter
casketed1534953casketed
catheter1338153catheter
darkened1435943darkened
darkeners1435153darkeners
darker114718693dark__er
darklier1335013darklier
darneder1033983darneder
darter75320363dar__ter
fakeer13378743fa_ke_er
ferreter1136543ferreter
gardener1037103gardener
garotter965943garotter
garreted1057523garreted
garroter956573garroter
garter74420513gar__ter
greeter82812673_greeter
hankerer15248233hankerer
hardener1238883hardener
harkened1637483harkened
harkeners1636073harkeners
harvester1544333harvester
hearkener1644213hearkener
jacketed22146533jacketed
junketer1943713junketer
larcener1036493larcener
larker104519243lark__er
larkier113711523lark_ier
machete14310883machete_
machetes1539633machetes
mackerel1644863mackerel
magister1136283magister
makeover17113353ma_keover
maker114127813ma_k__er
maltster1035303maltster
manometer1368763manometer
marauder1144553marauder
marbler113511673mar_bler
marblier1256343marblier
marceller1345153marceller
marcher143912973mar_cher
margented1346813margented
mariner93315993mar_iner
marked133921623mark__ed
markedly1843863markedly
markers133516103marke_rs
marketing1636513marketing
markhoor1742973markhoor
markhor1635463mark_hor
marksmen1644533marksmen
marlier92614773mar_lier
marlite92917073marlite_
marlites103415263marlites
marmite112413993marmite_
marmites122212793marmites
marrer83716673mar__rer
marrier93817523mar_rier
marshier1337593marshier
marted94425213mar__ted
marten84518263mar__ten
martyr1135693mar__tyr
marveled1436433marveled
masker124416103mask__er
masseters1136283masseters
master84831343ma__ster
mater74438863ma___ter
matter84325343ma__tter
meeter83616503m__eeter
meter75130323m___eter
mirker123712693mirk__er
mirkier13319053mirk_ier
murderer1145263murderer
murker123715243murk__er
murkier133110273murk_ier
musketeer1542553musketeer
nakeder1254363na_keder
narrater838723narrater
packeted17148283packeted
parameter1349123parameter
parcener1238473parcener
pargeted1238683pargeted
parietes10714543parietes
parker124121373park__er
parkette14138023parkette
parkettes15137593parkettes
parleyer1335633parleyer
parroter1058203parroter
picketer16187433picketer
pocketer16157373pocketer
racketed15169123racketed
racketeer15174633racketeer
racketier15165413racketier
remarketed1753583remarketed
rocketer14158333rocketer
sarkier113413313sark_ier
smarter94113133smar__ter
targeted1037483targeted
tarter64023563tar__ter
ureter6313203_ur_eter
wakener1446913wa_kener
warrener1136913warrener
yawmeter1693873yawmeter

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621336.43622710.1
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.92225814.9
 
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.