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

164 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
degusting123616(None) 
debuting12268632debu_ting
deducting1436842deducting
defusing13227942defus_ing
degassing1234822degassing
degaussing1342292degaussing
degumming1643132degumming
delisting112710502delisting
demasting1338452demasting
deputing12238792depu_ting
desisting112810382desisting
detesting112610322detesting
devesting14249902devesting
digesting12208672digesting
disgusting1345972disgusting
dusting93618992d__usting
egesting1039012_egesting
gusting93917162__gusting
adjusting1843833adjusting
agisting1038243_agisting
becrusting1544603becrusting
begetting13186583begetting
beguiling1334853beguiling
begulfing1642843begulfing
bemisting1438073bemisting
bemusing1336613bemus_ing
besting104923923be__sting
busting104221793__busting
crusting113612793_crusting
daunting103310403d_aunting
dauting93814763d_au_ting
deashing134210953de_ashing
debasing12238063debas_ing
debating123213733de_bating
debiting122511203de_biting
debugging1542993debugging
debunking1733353debunking
decanting132510633decanting
decocting1538123decocting
decupling1534973decupling
decurving1634723decurving
decussating1543193decussating
deducing1336423dedu_cing
defatting1436103defatting
defaulting1543393defaulting
defeating142311973defeating
defecting162510223defecting
deflating142610713deflating
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defuzing22195253defu_zing
degerming1435753degerming
deglazing2135133deglazing
degrading13137373degrading
degust8310253degust___
degusted1135733degust_ed
degusts936063degust__s
dehiscing1643733dehiscing
dehorting1447213dehorting
dejecting20217793dejecting
delating103119603de_lating
deleting103314423de_leting
delousing1136303delous_ing
deluding1137683delu_ding
deluging1137123delu_ging
delustering1344073delustering
dementing13311043dementing
demising122012523demis_ing
demitting13239073demitting
demoting12311423de_moting
demounting1444963demounting
demurring1335253demurring
denoting10311753de_noting
denting94422183de__nting
denudating1345263denudating
denuding1137113denu_ding
departing1349513departing
depicting1537813depicting
depleting1378193depleting
deporting1369593deporting
deposing12129773depos_ing
depositing1446933depositing
depurating1438643depurating
derating103222283de_rating
deratting1139513deratting
desalting1138843desalting
deserting11713143deserting
despiting13179323despiting
destine83719953de__stine
destiny113111463de__stiny
detecting13259983detecting
deucing1139393de_u_cing
deviating14311083deviating
devising133111523devis_ing
devoting1338823de_voting
dighting142510843dig_hting
diluting10248983dilu_ting
disusing1039013disus_ing
divesting14298483divesting
doubting1237373d_oubting
dousing93315763d_ous_ing
ducting113713593d__ucting
dueting93814393d__ueting
dunting93418383d__unting
dusking133912053d__usking
dustings10419033d__ustings
easting84924303_e_asting
eluting84115293_elu_ting
equating18310113_equating
eructing112110173_eructing
erupting11218443_erupting
existing1639073_existing
exulting1637643_exulting
feasting122011323fe_asting
gasting95022763__gasting
guesting1058463__guesting
gushing124014223__gushing
gutting93415923__gutting
heisting123411043he_isting
ingesting11129623ingesting
jesting154317713je__sting
jousting16309353_jousting
justing153615163__justing
legating102313113leg_ating
lusting83619323__lusting
musting103221073__musting
negating102012833neg_ating
nesting84320443ne__sting
ousting84021353__ousting
perusing11811063perus_ing
rebutting1237523rebutting
recasting122414233recasting
recusing112512883recus_ing
recutting1239483recutting
reesting93118273re_esting
refusing122310873refus_ing
refuting121911903refu_ting
regrating111316213regrating
regulating12310063regulating
relisting102414353relisting
relucting1239773relucting
renesting102514703renesting
repasting122312843repasting
reputing112412603repu_ting
requesting2046313requesting
requiting1939883requiting
resisting103215313resisting
resting85031183re__sting
resulting10311083resulting
retasting102513413retasting
retesting102614603retesting
reusing82516783re_us_ing
revesting132814123revesting
rousting93913273_rousting
rusting83821263__rusting
segueing1034983segu_eing
testing86021053te__sting
thrusting1335013thrusting
trusting93411653_trusting
vesting114618683ve__sting
westing115020273we__sting
yeasting12188923ye_asting
zesting174515333ze__sting

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.436409841.7
2DLD Change Limit1486411647.50019818.8
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.99922339.2
 
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.