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

110 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
decreeing133552(None) 
decerning1337292decerning
decreasing1446512decreasing
decrying15237412decr_ying
dreeing94311182d__reeing
secreting1279822secreting
accreting1446333accreting
agreeing10295903_agreeing
becriming1646363becriming
bescreening1642773bescreening
creeling113513363__creeling
creeping133310103__creeping
creping122913653__creping
crewing133212633__crewing
dackering1737383dackering
deadening1277583deadening
deafening1476273deafening
debriding1446483debriding
debriefing1742113debriefing
decamping1734943decamping
decanting132510633decanting
decaying15239453dec_aying
deceasing1338403deceasing
deceiving1635733deceiving
deciding132210833dec_iding
decking153915593dec__king
declaring1339573declaring
declawing1636213declawing
declining13129353declining
decocting1538123decocting
decoding132410053dec_oding
decorating14312073decorating
decoying15208763dec_oying
decree93117783decree___
decreed112710253decree__d
decreer10269123decree__r
decreers11277623decree_rs
decrees102513123decree__s
decrement14411053decrement
decrepit1345873decrepi_t
decretive1547493decretive
decrowning1743593decrowning
decrypting1943213decrypting
decupling1534973decupling
decurving1634723decurving
deeding103315123de__eding
deeming113913123de__eming
deepening1335613deepening
deferring1436143deferring
defleaing1444743defleaing
defraying1735853defraying
defueling14255093defueling
degerming1435753degerming
degrading13137373degrading
degreasing1345423degreasing
dekeing13358353de__keing
deleing93313953de__leing
deleting103314423de_leting
demerging1436643demerging
deperming1537113deperming
depleting1378193depleting
depraving1635973depraving
depressing1448093depressing
depriving1636403depriving
derating103222283de_rating
deriding112512933de_riding
deriving132510743de_riving
describing1645073describing
descrying1635103descr_ying
deserting11713143deserting
deserving1497903deserving
desexing1736293de_sexing
deterging1237853deterging
deterring1138623deterring
detruding1245193detruding
develing133212733de_veling
dickering1737463dickering
docketing1785413docketing
emceeing1343573_emceeing
excreting1946433excreting
ferreling13136273ferreling
ferreting13127693ferreting
freeing113713913__freeing
greeing93613783__greeing
lechering1538443lechering
leveeing12265963le_veeing
necrosing1247693necrosing
preeing103817673__preeing
pureeing1137273_pureeing
rebreeding1445423rebreeding
receding122713763rec_eding
rechewing1836493rechewing
recrating121318793recrating
recreating131214583recreating
refereeing1444673refereeing
refreezing2344413refreezing
regreening1246033regreening
regreeting1237343regreeting
rescreening1444083rescreening
reseeing92412623re_seeing
screeding1336323_screeding
screening1247193_screening
screwing14288233_screwing
seceding12288563sec_eding
secerning1246203secerning
secretin10108343secretin_
secretins11108463secretins
treeing83414303__treeing
unfreeing1345103unfreeing
weeweeing1641783weeweeing

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.423422437.4
2DLD Change Limit1486411107.76619140.0
3Display Results1101100.0601833.3
 (SQL Overall)1786911108.24921662.1
 
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.