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

159 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
marketed153732(None) 
marketer1437381marketer
carpeted1338942carpeted
casketed1534952casketed
darkened1435942darkened
garreted1057522garreted
harkened1637482harkened
jacketed22146532jacketed
margented1346812margented
marked133921622mark__ed
market123226042market__
marketeer1543592marketeer
marketers1545982marketers
markets133314032market_s
marted94425212mar__ted
marveled1436432marveled
packeted17148282packeted
pargeted1238672pargeted
racketed15169122racketed
remarketed1753582remarketed
targeted1037482targeted
arete56031353_ar_ete_
aretes64425353_ar_etes
arrested939153_arrested
barbered13259543barbered
barked135027313bark__ed
barkeep1536363barke_ep
barreled1137843barreled
bartered113113013bartered
basseted1136743basseted
blanketed1643913blanketed
bracketed1855863bracketed
bucketed1736763bucketed
cacheted16148233cacheted
cankered153010223cankered
careened1139193careened
careered1139493careered
carked134024823cark__ed
carted98631443car__ted
corseted11311473corseted
curveted1435293curveted
dackered16116893dackered
daikered1495223daikered
darked123919633dark__ed
darkener1335993darkener
darkled13378713dark_led
darted84620923dar__ted
docketed16156583docketed
faceted13509563fa_ceted
farted105121783far__ted
ferreted1236323ferreted
galleted1038213galleted
gardened1137003gardened
garmented1345883garmented
garnered10247113garnered
garoted9710133gar_oted
garotted1066193garotted
garroted1056783garroted
gartered10319583gartered
gorgeted1135353gorgeted
greeted93111383_greeted
hankered16289443hankered
hardened1338613hardened
harked145422553hark__ed
harkener1537573harkener
harvested1644093harvested
hawkeyed2242403hawkeyed
hearkened1744453hearkened
junketed2033523junketed
lackered15108673lackered
lackeyed18104513lackeyed
lakebed1434783la_kebed
lanceted1137073lanceted
lappeted13255833lappeted
lariated91212063lariated
larked114519473lark__ed
machete14310883machete_
machetes1539633machetes
mackerel1644863mackerel
mackled164111913mack_led
maddened1334893maddened
malted94819853ma__lted
mammered12237653mammered
mandated12310283mandated
mannered11249653mannered
marauded1244333marauded
marbled123212113mar_bled
marcelled1445203marcelled
marched153813403mar_ched
margined1237743margined
marinated122513173marinated
markedly1843853markedly
marker124420393mark__er
markers133516103marke_rs
marketeers1643123marketeers
marketing1636513marketing
marksmen1644533marksmen
marled95523163mar__led
marlite92917073marlite_
marlites103415263marlites
marmite112413993marmite_
marmites122212793marmites
marooned1138563marooned
marred95421043mar__red
married104715303mar_ried
marrowed1445973marrowed
marten84518263mar__ten
martyred1434283martyred
marvelled1544963marvelled
masked134316523mask__ed
masseter1037063masseter
masted94025803ma__sted
mastered112614003mastered
mated85537783ma___ted
matted94521413ma__tted
mattered112412903mattered
mayweed1634163maywe_ed
merited10313853mer_ited
meted85424433m___eted
minareted1244623minar_eted
monkeyed1844153monkeyed
morseled1147193morseled
murdered1236023murdered
muriated1139793muriated
narked114116743nark__ed
narrated9310323narrated
palleted1139863palleted
parapeted1446463parapeted
parceled1338323parceled
parented11912213parented
pargetted1345663pargetted
parietes10714543parietes
parked134425133park__ed
parkette14138023parkette
parkettes15137593parkettes
parleyed1436223parleyed
parqueted2144203parqueted
parroted1158843parroted
parted94228683par__ted
picketed17167383picketed
pocketed17147143pocketed
premarketed2052533premarketed
rabbeted1334443rabbeted
racheted14149503racheted
rocketed15157793rocketed
sacheted14127833sacheted
smarted105012613smar__ted
smartened1244263smartened
socketed15177343socketed
tableted1137533tableted
tarted74923373tar__ted
tarweed1137343tarwe_ed
ticketed15146643ticketed
turreted935373turreted
valeted1139013va_leted
variated121211393variated
wakened1546873wa_kened
warked144421213wark__ed
warted104223233war__ted

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621597.18620339.8
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.43924020.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.