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

171 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
decerning133729(None) 
secerning1246201secerning
deceasing1338402deceasing
deceiving1635732deceiving
declining13129352declining
decreeing1335522decreeing
decrying15237412dec_rying
decurving1634722decurving
deferring1436142deferring
degerming1435752degerming
dehorning1455242dehorning
demeaning1337242demeaning
demerging1436642demerging
deperming1537112deperming
deserting11713142deserting
deserving1497902deserving
deterging1237852deterging
deterring1138622deterring
deveining1436392deveining
discerning1447862discerning
beckoning1845773beckoning
becursing1435453becursing
bemeaning1436193bemeaning
caverning1536283caverning
cering94522533__cer_ing
concerning1548903concerning
corning103720123__corning
dackering1737383dacker_ing
darning93817333d__arning
davening13258873dave_ning
deaconing1337193deaconing
deadening1277583deadening
deaerating12311563deaerating
deafening1476273deafening
deairing10311893deair_ing
deaning94020473d__eaning
debarking1735383debarking
debarring1335713debarring
debeaking1735923debeaking
debearding1543733debearding
deboning12109153de_boning
decamping1734943decamping
decanting132510633decanting
decaying15239453dec_aying
decennia1144223decenni_a
decennial1244823decennial
decennium1443783decennium
decentring1446753decentring
decern91310953decer__n_
decerned1237263decern_ed
decerns10119053decer__ns
decertify1843463decertify
deciding132210833dec_iding
decking153915593dec__king
declaring1339573declaring
declawing1636213declawing
decocting1538123decocting
decoding132410053dec_oding
decorating14312073decorating
decoying15208763dec_oying
decreasing1446513decreasing
decrowning1743593decrowning
decupling1534973decupling
deeding103315123de_e_ding
deeming113913123de_e_ming
deepening1335613deepening
defeating142311973defeating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
defining133711803de_fining
deforcing1636063deforcing
deforming1636703deforming
dehorting1447213dehorting
deigning1137753de_igning
dejecting20217793dejecting
dekeing13358353deke__ing
deleading1237773deleading
deleaving1436263deleaving
deleing93313953dele__ing
deleting103314423dele_ting
demarking1736773demarking
dementing13311043dementing
demeriting1448683demeriting
demurring1335253demurring
denning93515173d__enning
departing1349513departing
depending14208783depending
deplaning1338053deplaning
deponing121211213de_poning
deporting1369593deporting
descending1546113descending
descrying1635103descrying
deservings1593663deservings
desexing1736293dese_xing
designing1236623designing
desiring10312143desir_ing
desorbing1346363desorbing
destining11311433destining
detaining112510473detaining
detecting13259983detecting
determine1249033determine
determining1545293determining
detesting112610323detesting
dethroning1544743dethroning
develing133212733deve_ling
devesting14249903devesting
deworming1635043deworming
dickering1737463dicker_ing
diverging15226693diverging
diverting142410333diverting
dizening19177143dize_ning
dovening13238353dove_ning
dowering132510613dower_ing
dozening19236183doze_ning
durning93511733d__urning
earning83418213_e_arning
emerging1237893_emerging
evening11310223_eve_ning
everting122213133_everting
exerting162211153_exerting
fevering152510083fever_ing
governing1435533governing
interning10315253interning
jeering153513043je_er_ing
keening123713153ke_e_ning
kerning124010893__kerning
learning978553le_arning
lechering1538443lecher_ing
leering83417643le_er_ing
levering122212503lever_ing
metering112915633meter_ing
peening103318303pe_e_ning
peering103520353pe_er_ing
petering112516813peter_ing
recaning111416693rec_aning
receding122713763rece_ding
receiving1538993receiving
recessing12611013recessing
reckoning1637643reckoning
recleaning1336753recleaning
reclining121112283reclining
recoining121313803recoining
reconning121410793reconning
recording131311623recording
recorking16149643recorking
recurring1237953recurring
recurving1536773recurving
reearning1039053reearning
referring1338033referring
relearning1135283relearning
remerging1358323remerging
reperking1638703reperking
reserving131110643reserving
returning1038133returning
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rezeroing1935933rezeroing
scorning1169133_scorning
seceding12288563sece_ding
secreting1279823secreting
securing11310413secur_ing
severing122013853sever_ing
sewering122411093sewer_ing
ulcering1139333ulcer_ing
veering113213683ve_er_ing
weening114113973we_e_ning
yearning1296983ye_arning

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 Limit1486411717.92318760.7
3Display Results1711710.0602850.0
 (SQL Overall)1786911718.40621257.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.