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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
derates8402889(None) 
aerates74627491aerates
berates94126871berates
cerates95428251cerates
debates103718531debates
delates83526281delates
derate74531231derate_
derated93623501derated
derats74625061derat_s
aerate64830552aerate_
aerated85322372aerated
berakes134815772berakes
berate84729022berate_
berated104422132berated
borates94823012borates
carates95630612carates
cerastes101111092cerastes
cerate84829462cerate_
cerated103922472cerated
cerites94823432cerites
certes84623082cer_tes
crates85736062_crates
creates95225202creates
curates95323832curates
dates65639152d__ates
deaerates10313642deaerates
dealates92716682dealates
dearies83526272dearies
dearths11498842dearths
deaths105914442de_aths
deaves105319532de_aves
debases103814132debases
debate94419192debate_
debated113916082debated
debater104114692debater
debaters113511922debaters
decades113615512decades
decanes103118912decanes
decares102818532decares
decorates12314742decorates
defaces133213402defaces
defames132812252defames
defats105114552defat_s
deflates123013942deflates
degames113312622degames
degases93413102degases
degrades11269922degrades
dekares122710872dekares
delate73827752delate_
delated93722872delated
deletes83117932deletes
demotes104717672demotes
denotes83817002denotes
depraves1436872depraves
depurates1239822depurates
deputes104911782deputes
derails84216392derails
deranges1039972deranges
derat65044082derat__
deratted1048402deratted
derays105514252dera_ys
derbies103016052derbies
derides93420852derides
derivates13310092derivates
derives114017812derives
derogates11310972derogates
derries83124622derries
deviates12312732deviates
devotes113713752devotes
dewater112912422dewater
dewaters122910722dewaters
dewaxes18297842dewaxes
dilates83220662dilates
disrates91118152disrates
donates83217222donates
drakes114715862d_rakes
drapes95419652d_rapes
drats66628372d_rat_s
elates65032362_elates
enates64026432_enates
erases64425402_erases
ergates8314492_ergates
federates13310152federates
ferrates113013422ferrates
gelates83219582gelates
grates75429892_grates
gyrates113610262gyrates
ideates8313732ide_ates
iterates81317822iterates
karates115617472karates
legates82917682legates
metates92720012metates
moderates12710752moderates
negates83215842negates
operates10515412operates
orates64328612_orates
penates93321602penates
pirates93020332pirates
prates84633162_prates
rates55352012__rates
rebates95123182rebates
recrates102420372recrates
redates83423872redates
regrates92618402regrates
relates73731432relates
remates93827112remates
sedates83418042sedates
senates73322612senates
serapes95218102serapes
seriates82620672seriates
serrates82617022serrates
uprates93814862uprates
urates65027762_urates
verites103822262verites
verstes104014282verstes

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.390458182.1
2DLD Change Limit1076711153.36032044.9
3Display Results1151150.0333484.8
 (SQL Overall)1786911153.78347235.3
 
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.