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

(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
derogates1131097(None) 
derogate10311351derogate_
derogated1238671derogated
abrogates12108972abrogates
arrogates10129422arrogates
decorates12314742decorates
delegates1139842delegates
derates84028892der__ates
derivates13310092derivates
desolates10311792desolates
detonates10310432detonates
ergates8314492_er_gates
perorates11417022perorates
abrogate11129603abrogate_
abrogated13126713abrogated
aerates74627493aer__ates
aerobats1049843aerobat_s
aerolites9312583aerolites
aerosats8411013aerosat_s
arrogate91210323arrogate_
arrogated11147143arrogated
berates94126873ber__ates
bromates12413143_bromates
cerates95428253cer__ates
chromates16313113chromates
coronates1110816923coronates
corotates112714283corotates
deaerates10313643deaerates
dealates92716683de_alates
debates103718533de__bates
decimates14410693decimates
decollates13137153decollates
decorate11315193decorate_
decorated13312203decorated
dedicates13311693dedicates
defecates1538593defecates
deflates123013943de_flates
defoliates1446333defoliates
degames113312623de__games
degases93413103de__gases
delates83526283de__lates
delegate10410463delegate_
delegated1238373delegated
delegatee1148803delegatee
delegatees1244273delegatees
delicates12314313delicates
demotes104717673demo__tes
denigrates1298113denigrates
denotes83817003deno__tes
denudates1145583denudates
depilates12310923depilates
deprecates1547283deprecates
depredates1445503depredates
depurates1239823depurates
derate74531233der__ate_
derated93623503der__ated
derats74625063der__at_s
deregulates13135133deregulates
derivate12311203derivate_
derogating1348633derogating
derogation12410393derogation
derogations1349393derogations
derogative1546983derogative
derogatory1545113derogatory
designates1246363designates
desolate9411993desolate_
desolated1139653desolated
desolater1038383desolater
desolaters1146043desolaters
detonate9311193detonate_
detonated1138213detonated
deviates12312733de_viates
devotes113713753devo__tes
divagates1444733divagates
donates83217223d__onates
drogues9398393d_rog_ues
elongates1045383_elongates
ergate7315143_er_gate_
ferrates113013423fer_rates
frigates12310933_frigates
headgates1446383headgates
herniates1247333herniates
irrigates1057253irrigates
legates82917683le__gates
levigates1346493levigates
negates83215843ne__gates
neonates8310063ne_onates
perborates1459213perborates
percolates14410423percolates
perforates1558863perforates
periodates1347863periodates
permeates13311773permeates
perorate10417923perorate_
perorated12412463perorated
personates122510693personates
probates12414283_probates
pronates10418373_pronates
prorates10418073_prorates
prorogates1347313prorogates
relegates10310943relegates
relocates11712933relocates
renovates1248453renovates
reprobates1447363reprobates
reroutes8312223rero_utes
resonates9412403resonates
rotates72819773__rotates
segregates1245333segregates
seriates82620673ser_iates
serrates82617023ser_rates
sororates9410473sororates
subrogates1345833subrogates
surrogates1144683surrogates
tergites9310543ter_gites
veritates12310973veritates
virgates1237923vir_gates

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411157.53019739.8
3Display Results1151150.0502300.0
 (SQL Overall)1786911158.00022336.4
 
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.