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

64 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
remakes13411617(None) 
remake124016111remake_
remaker133813171remaker
remakers143811301remakers
remates93827111remates
retakes113718861retakes
rewakes144614981rewakes
berakes134815772berakes
betakes134212522betakes
comakes154413642comakes
cremates124216002cremates
females12310662females
makes115336852__makes
prebakes1639012prebakes
rakes94440352r__akes
reales64934122re_ales
reaves94127572re_aves
reawakes15348072reawakes
rebates95123182rebates
rebukes134210552rebukes
recanes93222262recanes
redates83423872redates
refaces123216742refaces
regales83520792regales
reimages1138372reimages
relaces93420882relaces
relates73731432relates
relaxes143215322relaxes
remade94316982remade_
remails94714562remails
remains94117912remains
remands104914882remands
remans84823002rema_ns
remaps105012872rema_ps
remarked15209242remarked
remarker14178492remarker
remarkers15197282remarkers
remarket142111032remarket
remarkets15224992remarkets
remarks13329982remarks
remate84428682remate_
remated103522472remated
remiges103015472remiges
remises93423482remises
remixes164313872remixes
remotes94521612remotes
removes124514712removes
renames92418052renames
repaves123513652repaves
resales74724902resales
retake104718532retake_
retaken113911802retaken
retaker113714312retaker
retakers123511132retakers
retapes93917422retapes
retaxes143615092retaxes
revokes144212502revokes
rewake135218462rewake_
rewaked153811902rewaked
rewaken144410272rewaken
rewakens15406242rewakens
rewaxes173911332rewaxes
rumakis1335532rumakis
unmakes132810792unmakes

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 Limit107671642.94036622.8
3Display Results64640.0164000.0
 (SQL Overall)178691643.32953677.1
 
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.