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

63 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
decides11421765(None) 
decades113615511decades
decide104116871decide_
decided124312421decided
decider114213181decider
deciders123510751deciders
deciles104417721deciles
decodes113914981decodes
deicides1249301deicides
derides93420851derides
besides104814532besides
betides104915262betides
dacites101114592dacites
debrides1268722debrides
decade104216162decade_
decanes103118912decanes
decares102818532decares
deceives1437902deceives
deciares11510632deciares
decibel1235992decibel
decibels1344522decibels
decidua1144492decidua
deciduas1243462deciduas
decile94619212decile_
deckles143312802deckles
declines113315802declines
decode104414742decode_
decoded123212382decoded
decoder113712292decoder
decoders122810412decoders
decrees102513122decrees
decries103319802decries
defies104624052defi_es
defiles114016842defiles
defines114118682defines
deices94119372de_ices
deicide1149402deicide_
delimes10314192delimes
deludes91810642deludes
demies94825802demi_es
demises103719562demises
denies74729642deni_es
denudes91510042denudes
depsides1238502depsides
deride84420032deride_
derided102914252derided
derider93214972derider
deriders102411852deriders
derives114017812derives
desires81316132desires
devices133212582devices
devises114116762devises
dexies145018342dexi_es
divides123211452divides
elides74420692_elides
excides1738342excides
recedes102816062recedes
recipes113314462recipes
recites93524582recites
recodes102918632recodes
redecides1356562redecides
resides84523282resides
secedes103711982secedes

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671632.87637437.8
3Display Results63630.0134846.2
 (SQL Overall)178691633.26254779.6
 
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.