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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
derogations134939(None) 
derogation12410391derogation_
abrogations14116462abrogations
arrogations12126482arrogations
decorations14312882decorations
delegations1348032delegations
denegations1348542denegations
denotations1239852denotations
derivations15611492derivations
derogating1348632derogati_ng
desolations12310592desolations
detonations1239372detonations
perorations13314062perorations
rogations101510822__rogations
abrogation13107333abrogation_
aerations9317903aer__ations
arrogation11107443arrogation_
coronations13410703coronations
corotations1349763corotations
darnations1138413dar_nations
deaerations12311673deaerations
dealations11311373de_alations
decimations16410163decimations
decoctions1547143deco_ctions
decollations1547363decollations
decoration13314423decoration_
dedications15310873dedications
defamations1745893defamations
defecations1779003defecations
deflations1439713de_flations
deflorations1646063deflorations
defoliations1647593defoliations
deformations1846843deformations
degradations1544553degradations
delations102616593de__lations
delegation1238883delegation_
demolitions1446523demolitions
demotions1258443demo__tions
denegation1249413denegation_
denigrations1447353denigrations
denotation11311083denotation_
dentations11413633de_ntations
denudations1346343denudations
depilations14310903depilations
deportations1548463deportations
depositions14117683depositions
depravations1885373depravations
deprecations1748563deprecations
depredations1646733depredations
deprivations1897923deprivations
deputations1448343deputations
deregulations1545203deregulations
derivation14712783derivation_
derogates11310973derogat__es
derogative1546983derogati_ve
derogatory1545113derogat_ory
designations1456943designations
desolation11311403desolation_
desorptions1445993desorptions
detonation11310943detonation_
deviations14311163de_viations
devolutions15106263devolutions
devotions1356593devo__tions
divagations16103833divagations
donations101112353d__onations
dotations101411633d__otations
durations10311463dur__ations
elongations1244663_elongations
evocations15259873_evocations
herniations1447403herniations
irrigations1246943irrigations
legations102711923le__gations
levigations1546213levigations
negations102811963ne__gations
nervations1359483ner_vations
percolations1648053percolations
perforations1747873perforations
permeations1549883permeations
peroration12316003peroration_
personations1448393personations
probations14311083_probations
pronations12314033_pronations
prorations12314463_prorations
prorogations1556723prorogations
purgations1346743pur_gations
relegations1248973relegations
relocations13311143relocations
renovations1448423renovations
reprobations1647773reprobations
revocations16410313revocations
rogation91612053__rogation_
rotations91613843__rotations
segregations1445803segregations
seriations10316683ser_iations
serrations10313103ser_rations
subrogations1545453subrogations
vernations13310333ver_nations

Search took 7 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 Filter1786911216330.406440125.6
2DLD Change Limit121633975.70321327.9
3Display Results97970.0462108.7
 (SQL Overall)178691976.15529031.8
 
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.