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

87 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
derogating134863(None) 
abrogating1497982abrogating
arrogating121778392arrogating
decorating14312072decorating
delegating1337672delegating
derating103222282der__ating
derogation12410392derogation
derogations1349392derogations
derogative1546982derogative
desolating1239462desolating
detonating1248822detonating
perorating13313132perorating
aerating92821003aer__ating
berating113220763ber__ating
bromating1439183_bromating
coronating13410173coronating
corotating1349323corotating
deaerating12311563deaerating
debating123213733de__bating
decimating1648763decimating
decocting1538123deco_cting
decollating1545973decollating
dedicating1539143dedicating
defeating142311973de_feating
defecating17237783defecating
deflating142610713de_flating
defoaming1645653defo_aming
defogging1653863defog_ging
defoliating1645823defoliating
defrosting1544493defro_sting
dehorting1447213deho_rting
delating103119603de__lating
delighting1644993delighting
demoting12311423demo__ting
demounting1444963demounting
denigrating14146923denigrating
denoting10311753deno__ting
denudating1345263denudating
deorbiting1445153deorbiting
depilating1439193depilating
deporting1369593depo_rting
depositing1446933depositing
deprecating1777283deprecating
depredating1655693depredating
deprograming1963363deprograming
depurating1438643depurating
deratting1139513der_atting
deregulating1554013deregulating
derogate10311353derogat__e
derogated1238683derogat_ed
derogates11310973derogat_es
derogatory1545113derogatory
designating1446073designating
desugaring1343263desugaring
deviating14311083de_viating
devoting1338823devo__ting
divagating1644003divagating
doating93816863d__o_ating
donating10311803d__onating
elongating1244523_elongating
herniating1445983herniating
irrigating1245953irrigating
legating102313113le__gating
levigating1545693levigating
negating102012833ne__gating
percolating1657323percolating
perforating1747023perforating
permeating1539923permeating
personating1447673personating
probating14311193_probating
pronating12313763_pronating
prorating12314283_prorating
prorogating1556063prorogating
recoating121317463reco_ating
relegating1239483relegating
relocating13310873relocating
renovating1447423renovating
reprobating1647103reprobating
rerouting10311873rero_uting
resonating11311263resonating
rotating92614553__rotating
segregating1445453segregating
seriating10916403ser_iating
serrating10513213ser_rating
subrogating15164983subrogating
surrogating13194323surrogating
throating1398403thro_ating

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 Filter1786911406030.420425454.8
2DLD Change Limit140603876.28322378.3
3Display Results87870.0461891.3
 (SQL Overall)178691876.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.