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

77 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
debates10371853(None) 
debases103814131debases
debate94419191debate_
debated113916081debated
debater104114691debater
debaters113511921debaters
delates83526281delates
derates84028891derates
rebates95123181rebates
abates85825032_abates
aerates74627492aerates
bates75846342__bates
berates94126872berates
cerates95428252cerates
dates65639152d__ates
dealates92716682dealates
deaths105914442de_aths
deaves105319532de_aves
debacles1335722debacles
debags104211062deba_gs
debarks14388492debarks
debars94218042deba_rs
debase94014472debase_
debased113310582debased
debaser103510412debaser
debasers11377902debasers
debited113311622debited
debits94214502debit_s
debones103315112debones
debts86418372deb_t_s
debuted11379332debuted
debuts93911752debut_s
debyes1238102deb_yes
decades113615512decades
decanes103118912decanes
decares102818532decares
defaces133213402defaces
defames132812252defames
defats105114552defat_s
deflates123013942deflates
degames113312622degames
degases93413102degases
dekares122710872dekares
delate73827752delate_
delated93722872delated
deletes83117932deletes
demotes104717672demotes
denotes83817002denotes
deputes104911782deputes
derate74531232derate_
derated93623502derated
derats74625062derat_s
deviates12312732deviates
devotes113713752devotes
dewater112912422dewater
dewaters122910722dewaters
dewaxes18297842dewaxes
dilates83220662dilates
donates83217222donates
elates65032362_elates
enates64026432_enates
gelates83219582gelates
ideates8313732ide_ates
legates82917682legates
metates92720012metates
negates83215842negates
penates93321602penates
rebate84424112rebate_
rebated103619702rebated
rebater93517912rebater
rebaters103413942rebaters
rebatos92913112rebatos
redates83423872redates
relates73731432relates
remates93827112remates
sedates83418042sedates
senates73322612senates

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.356501941.0
2DLD Change Limit107671773.34332207.9
3Display Results77770.0164812.5
 (SQL Overall)178691773.71548099.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.