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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
marketers154598(None) 
marketeers1643121marketeers
marketer1437381marketer_
darkeners1435152darkeners
harkeners1636072harkeners
markers133516102mark__ers
marketed1537322markete_d
marketeer1543592marketeer
markets133314032market__s
masseters1136282masseters
ammeters1237693_ammeters
arbiters1038853_arbiters
aretes64425353_ar_ete_s
arresters948193_arresters
barkeepers1842893barkeepers
barkeeps1634143barke_eps
barkers134318513bark__ers
barometers14198513barometers
barraters1138043barraters
barretors1146243barretors
barterers11269633barterers
barters94223033bar__ters
careeners1138533careeners
careerers1137243careerers
careers95218783car_e_ers
carpenters1445833carpenters
carters95327253car__ters
catheters1437013catheters
darkener1335993darkener_
darters84017603dar__ters
fakeers14446673fa_ke_ers
ferreters1246253ferreters
gardeners1136603gardeners
garotters1055033garotters
garroters1055813garroters
garters84218233gar__ters
greeters92610113_greeters
hankerers16226713hankerers
hardeners1338083hardeners
harkener1537573harkener_
harvesters1644143harvesters
hearkeners1743983hearkeners
junketers2042933junketers
larceners1135993larceners
larkers113014513lark__ers
machetes1539633machete_s
mackerels1743083mackerels
magisters1235803magisters
makeovers18103283ma_keovers
makers123921733ma_k__ers
maltsters1135193maltsters
manometers1448023manometers
marauders1244263marauders
marblers12319233mar_blers
marcellers1443833marcellers
marchers153710813mar_chers
mariners103113863mar_iners
markedness1744023markedness
marker124420393mark__er_
market123226043market___
marketing1636513marketing
marketings1743163marketings
markhoors1842703markhoors
markhors1745393mark_hors
marlites103415263marlite_s
marmites122212793marmite_s
marrers93414313mar__rers
marriers103312473mar_riers
martens93714953mar__tens
martyrs1234893mar__tyrs
maskers133913843mask__ers
masseter1037063masseter_
masters94628923ma__sters
maters85032393ma___ters
matters94421753ma__tters
meeters94714543m__eeters
meters85625833m___eters
murderers1244593murderers
musketeers1642213musketeers
narraters946703narraters
parameters1448123parameters
parceners1337453parceners
parietes10714543pariete_s
parkers133816873park__ers
parkettes15137593parkettes
parleyers1444693parleyers
parroters1156763parroters
picketers17196483picketers
pocketers17196493pocketers
racketeers16153633racketeers
rocketers15186883rocketers
ureters7311823_ur_eters
wakeners1535843wa_keners
warreners1236193warreners
yawmeters1783873yawmeters

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 Filter1786911486410.216827273.1
2DLD Change Limit148641956.90621523.5
3Display Results95950.0462065.2
 (SQL Overall)178691957.16824929.0
 
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.