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

124 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
derogate1031135(None) 
derogated1238671derogated
derogates11310971derogates
abrogate11129602abrogate
arrogate91210322arrogate
decorate11315192decorate
delegate10410462delegate
derate74531232der__ate
derivate12311202derivate
derogative1546982derogative
desolate9411992desolate
detonate9311192detonate
ergate7315142_er_gate
perorate10417922perorate
abrogated13126713abrogated
abrogates12108973abrogates
aerate64830553aer__ate
aerobat9514473aerobat_
aerobats1049843aerobats
aerolite8315053aerolite
aerosat7417183aerosat_
aerosats8411013aerosats
areolate81014453areolate
arrogated11147143arrogated
arrogates10129423arrogates
berate84729023ber__ate
bromate11313553_bromate
cerate84829463cer__ate
chromate15312783chromate
coronate103018213coronate
corotate102813933corotate
deaerate9314173deaerate
dealate83617843de_alate
debate94419193de__bate
decimate13411123decimate
decollate12137743decollate
decorated13312203decorated
decorates12314743decorates
dedicate12312803dedicate
defecate1438793defecate
deflate113613943de_flate
defoliate1346993defoliate
degage92711383de__gage
degame102713183de__game
delate73827753de__late
delegated1238373delegated
delegatee1148803delegatee
delegates1139843delegates
delicate11315493delicate
demote94817803demo__te
denigrate1168693denigrate
denote74118043deno__te
dentate8315153de_ntate
denudate1046163denudate
depilate11311703depilate
deprecate1477433deprecate
depredate1345733depredate
depurate1139983depurate
derat65044083der__at_
derated93623503der__ated
derates84028893der__ates
derats74625063der__ats
deregulate12135193deregulate
derivates13310093derivates
derogating1348633derogating
derogation12410393derogation
derogatory1545113derogatory
designate1147113designate
desolated1139653desolated
desolater1038383desolater
desolates10311793desolates
detonated1138213detonated
detonates10310433detonates
deviate11312713de_viate
devote104513783devo__te
divagate1344783divagate
donate73619503d__onate
drogue8938333d_rog_ue
elongate945613_elongate
ergates8314493_er_gates
fermate122813003fer_mate
ferrate103014043fer_rate
frigate11311063_frigate
headgate1346483headgate
herniate1148113herniate
irrigate967633irrigate
legate72917453le__gate
levigate1246623levigate
negate72915573ne__gate
neonate7311333ne_onate
nervate1039533ner_vate
perborate13510143perborate
percolate13411163percolate
perforate1459463perforate
periodate1248343periodate
permeate12311613permeate
perorated12412463perorated
perorates11417023perorates
personate112111423personate
probate11414483_probate
prolate9419793_prolate
pronate9418873_pronate
prorate9418733_prorate
prorogate1247693prorogate
relegate9311243relegate
relocate10713533relocate
renovate1138553renovate
reprobate1347683reprobate
reroute7313963rero_ute
resonate8513513resonate
rotate63320343__rotate
rugate75813813__rugate
segregate1145073segregate
serenate81914883serenate
seriate73722473ser_iate
serosae7310243serosa_e
serrate73017543ser_rate
sororate8411173sororate
subrogate1246043subrogate
surrogate1044783surrogate
tergite8311003ter_gite
ternate7415483ter_nate
togate74515683__togate
virgate1138733vir_gate

Search took 10 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621248.64016916.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911249.13919552.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.