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

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

83 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
lamest8472276(None) 
gamest94919921gamest
lament85024941lament
lames75445541lames_
latest63822701latest
laxest134913361laxest
tamest85721291tamest
almes75126542almes_
almost81014432almost
ament76036542_ament
barest85327692barest
basest84720492basest
blames105121862blames_
calmest11312342calmest
cames97047312cames_
dames85435852dames_
dampest12411042dampest
fames105735922fames_
flames114723692flames_
flamiest133111972flamiest
games86238552games_
gamiest102816222gamiest
gayest104314332gayest
halest94823272halest
hames106138702hames_
kames115024692kames_
laces76141762laces_
laciest93819032laciest
lades65141272lades_
lakes95737652lakes_
lakiest113517262lakiest
lamas75532792lamas_
lambast11129892lambast
lambent113711302lambent
lambert113617112lambert
lambiest122410182lambiest
lambs95921412lambs_
lame66849292lame__
lamed85235292lame_d
lamedh12476362lamedh
lameds94812032lameds
lamely114013222lamely
laments94314852laments
lamer75233702lame_r
lamps95624832lamps_
lams66552262lam_s_
lanes54946792lanes_
lankest112714112lankest
lares54852632lares_
largest83715102largest
lases54944762lases_
last46260322la__st
latent64124302latent
latests73910312latests
laves86039152laves_
laxes125430092laxes_
lazes145129572lazes_
laziest163814472laziest
leanest7415862leanest
lest46956322l__est
likest104914382likest
limes75636502limes_
limiest93716102limiest
limpest113712312limpest
livest95315732livest
loamiest102310202loamiest
loment84021472loment
lowest93915592lowest
mayest114614792mayest
names74833362names_
palest83926222palest
ramet75743142rame_t
ramets83517392ramets
rarest65725482rarest
rawest93615062rawest
safest95016602safest
sagest74920262sagest
sanest64426692sanest
sayest94217742sayest
tames75242012tames_
wames106432802wames_
warmest123113032warmest
yarest95018912yarest

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit82551832.37634743.7
3Display Results83830.0302766.7
 (SQL Overall)178691832.51271135.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.