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

145 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
divesting1429848(None) 
devesting14249901devesting
digesting12208671digesting
diverting142410331diverting
detesting112610322detesting
dieting93616832di_e_ting
directing1338822directing
diverging15226692diverging
investing13119392investing
revesting132814122revesting
riveting12139442rive_ting
rivetting13256412rivetting
vesting114618682__vesting
advecting1645113advecting
adverting1437223adverting
arresting1038633arresting
attesting1036383attesting
averting122512733_averting
besting104923923__besting
biestings12266033bi_estings
bisecting1436973bisecting
caveating1539293caveating
coveting141912303cove_ting
cresting114017043_cresting
davening13258873dave_ning
defeating142311973defeating
defecting162510223defecting
degusting1236163degusting
dejecting20217793dejecting
deleting103314423dele_ting
delisting112710503delisting
demasting1338453demasting
dementing13311043dementing
denting94422183d__enting
deserting11713143deserting
desisting112810383desisting
destine83719953d__estine
destiny113111463d__estiny
detecting13259983detecting
deveining1436393deveining
develing133212733deve_ling
deviating14311083deviating
devising133111523devis_ing
devoting1338823dev_oting
dictating1338883dictating
dieing84018653di_e__ing
dieseling1146143di_eseling
digestif1396173digesti_f
digestifs1484433digestifs
digestion1146573digestion
digestions1246403digestions
digestive1446243digestive
dighting142510843di_ghting
digressing1345793digressing
dilating102714903di_lating
diluting10248983di_luting
dinting93520553di__nting
dipnetting1453623dipnetting
discepting1658473discepting
discing113914593di__scing
diseasing11310833diseasing
disgusting1345963disgusting
dishing124017103di__shing
disinvesting1754203disinvesting
disjecting2177243disjecting
disking134615493di__sking
dismasting1446383dismasting
disputing1337763disputing
disrating11714553disrating
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserting121310853disserting
dissing94517683di__ssing
distasting1248023distasting
disusing1039003disus_ing
divagating1644003divagating
divest106820073divest___
divested13268213divest_ed
divestment16146313divestment
divests114510933divest__s
divesture13144183divesture
dividing1437183div_iding
diving113717953div___ing
divining1338413div_ining
divorcing1644323divorcing
divulging15103273divulging
divulsing14103933divulsing
divvying1932773div_vying
dizening19177143dize_ning
dovening13238353dove_ning
dressing102810423d_ressing
driveling1445763drive_ling
drivelling1543983drivelling
dueting93814393d_ue_ting
duetting1047183d_uetting
dusting93618993d__usting
duvetine1245163duve_tine
egesting1039013_egesting
everting122213133_everting
fileting1239303file_ting
finessing1345123finessing
fisting113818123fi__sting
foresting13311363foresting
guesting1058463_guesting
harvesting1744413harvesting
histing113720373hi__sting
ideating10311703_ideating
infesting13109513infesting
ingesting11129623ingesting
inventing13109973inventing
inverting131013223inverting
jesting154317713__jesting
listing84020593li__sting
livening12248153live_ning
livering122012383live_ring
miseating121215433miseating
misting103623383mi__sting
molesting1237753molesting
nesting84320443__nesting
obtesting1245883obtesting
obverting1536303obverting
pipetting1435513pipetting
pivoting1436183piv_oting
priesting1239483priesting
questing1838273_questing
redigesting1444573redigesting
reesting93118273_reesting
reinvesting1545323reinvesting
renesting102514703renesting
resting85031183__resting
retesting102614603retesting
reverting132315133reverting
revetting132912633revetting
riesling939013ri_esling
riposting1236063riposting
testing86021053__testing
unresting10311133unresting
venting114218093__venting
vestings12359143__vestings
vetting114216563__vetting
westing115020273__westing
wisting113519743wi__sting
wresting123811833_wresting
zesting174515333__zesting

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411456.03024650.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911456.26628517.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.