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

117 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
momento1134890(None) 
memento11378131memento
moment103319681moment_
momenta11299851momenta
momentos12338331momentos
moments113113121moments
foment113718302foment_
foments122912052foments
loment84021472loment_
lomenta92710132lomenta
loments93413472loments
mementos12267372mementos
momently1546472momently
momentoes13286252momentoes
momentous13285772momentous
momentum1144432momentum
obento837892_obento
omenta83411722_omenta
pimento1157222pimento
tomenta9319832tomenta
ament76036543_ament_
aments85219803_aments
amoretto1095793amoretto
bento75922953__bento
cement103321673cement_
cementa112810543cementa
cements112714223cements
cento76625173__cento
cogent9321003cogent_
comedo11359603come_do
comet95946073come_t_
cometh134811683come_th
comets105823583come_ts
comment1310317703comment_
comments142913883comments
conto76027173co__nto
coranto9311893coranto
dement93825153dement_
dements103016623dements
docent92918683docent_
docents102810803docents
domino92611493domin_o
dozenth2044323dozenth
fomented1437803fomented
fomenter1339263fomenter
fromenty1645243fromenty
lament85024943lament_
laments94314853laments
lento57223393__lento
lomentum1244753lomentum
magenta1038623magenta
magneto1046743magneto
marengo1035263marengo
mementoes13325383mementoes
meno66031363__men_o
menta74424423__menta
mentor8414363__mentor
mimeo96018683mime__o
moderato1186263moderato
modest93818453modest_
modesty13476983modesty
mofette1296773mofette
moiety1148223moie_ty
molest85022743molest_
molests93311563molests
molto75619603mo__lto
mome85239353mome___
momentary1645233momentary
momentums1242923momentums
momes95134473mome__s
mondo85721233mo__ndo
mongo810122413mo__ngo
mono66036723mo__n_o
monte75829773mo__nte
month104818423mo__nth
monument1289903monument_
monuments1397633monuments
mordent10313993mordent_
mordents1138813mordents
morello9117793morello
motet75641193mote_t_
motets84216193mote_ts
motto76119513mo__tto
mount74128063mo_unt_
mounts84115073mo_unts
movement1549433movement_
movements1647513movements
mozetta1894753mozetta
mozette1886773mozette
nocent83217413nocent_
nomen75621623nomen__
obentos936703_obentos
omen66828183_omen__
omened93711003_omened
omens75618963_omen_s
omental93210423_omental
omentum1155933_omentum
onto46127663_o__nto
pimentos1246233pimentos
pimiento1243253pimiento
polenta9310093polenta
pomelo10238663pome_lo
ponent82821593ponent_
potent84223353potent_
ramenta9311183ramenta
rodent7519243rodent_
rodents8611543rodents
romano84912943roman_o
romeo73719703rome__o
tomato8313453tom_ato
tomentose1143563tomentose
tomentum1244993tomentum
torment9316173torment_
tormentor1144363tormentor
torments10310453torments
vomito11238033vom_ito
women104619253women__

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 Limit1340271176.95319276.1
3Display Results1171170.0761539.5
 (SQL Overall)1786911177.45223978.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.