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 “understanding” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
understanding167377(None) 
understandings17112371understandings
understaffing21102732understaffing
understandingly2171592understandingly
understating1446542understa_ting
undemanding1653443unde__manding
underfunding1873503under_funding
underloading1564293underloa_ding
undersigning1553463undersign_ing
understaffings22121593understaffings
understand1246183understand___
understands1344653understand__s
understeering1573063understeering
understudying1962143understudying
undertaking1796583under_ta_king
undertaxing20105583under_ta_xing
desanding12207654__de_s_anding
freestanding1762084_freestanding
underacting1547524under__acting
underbaking1995164under_ba_king
underbidding1852774under_bidding
underbudding1852814under_budding
undercharging2152594undercharging
undercoating1645374undercoa_ting
undercounting1763084undercounting
undereating1369554under_ea_ting
underfeeding1853184under_feeding
undergirding1653324under_girding
underheating1785134underhea_ting
underlapping1853514under_lapping
underlaying16125764under_la_ying
underlining1346684under_lin_ing
undermining1546364under_min_ing
underpainting1763554underpainting
underpaying18125374under_pa_ying
underpinning1653424under_pinning
underplaying19154354underpla_ying
underrating1388254under_ra_ting
underreacting1752834underreacting
underrunning1452704under_running
underscoring1653634unders_coring
underselling1453974unders_elling
undershooting1852554undershooting
understandable1891714understandable
understandably21131424understandably
understudied1553254underst_udied
understudies1453324underst_udies
undertakings1894034under_ta_kings
undervaluing1753384under_valuing
undesigning1453444unde_sign_ing
unpretending1672834un_pretending
upstanding1443714u___pstanding
condescending2052285conde_scending
countermanding2053745counter_manding
countershading2163835countersha_ding
counterstaining1863245counterstaining
counterstating1755195countersta_ting
demanding14237925__de__manding
deranging1238065__der__anging
descanting1446925__de_scanting
descending1546115__de_scending
desponding1555665__de_sponding
destaining1267945__de_staining
destining11311435__de_stin_ing
disbanding1545585__d_isbanding
distancing1447085__d_istancing
distending1348335__d_istending
engarlanding155925engar_landing
entertaining1354385enter_taining
grandstanding1761495grandstanding
hardstanding1851695_hardstanding
instancing1344645in___stancing
interchanging2052995interchanging
intergrading1545985intergra_ding
interlarding1445565inter_larding
interlending1456415inter_lending
interplanting1655345interplanting
interspacing1755055interspa_cing
interstadial1354085intersta_dial
nondemanding1752465nonde__manding
outdistancing176855outd_istancing
outstanding1344555__outstanding
overhanding1947025_over_handing
overshading1946645_oversha_ding
overspending1945735_overspending
overstaffing2243655_overstaffing
overstating15410735_oversta_ting
overstaying1847055_oversta_ying
overstriding1745615_overstriding
pedestaling1553725pede_sta_ling
pedestalling1652565pede_stalling
persuading1454505__persua_ding
redemanding1643485rede__manding
redescending1752575rede_scending
standing103413635_____standing
thunderstriking2481425thunderstriking
unbending1337465unbe____nding
unbraiding1445125un_br__aiding
uncertain1146205uncer_ta__in_
underbuying1843455under__buying
underclothing2061895underclothing
undercoatings1753065undercoa_tings
undercooking2063245under_cooking
undercooling1653695under_cooling
undercutting1653765under_cutting
underdoing1346805under___doing
underdosing1444495under__dosing
underestimating1972075underestimating
underexposing2461935underexposing
undergoing1347085under___going
underhand1447265under_hand___
underhanded1744665under_hand_ed
underhands1545455under_hand__s
underlain1048685under_la__in_
underletting1454185under_letting
underling111514615under____ling
underlying15136375under___lying
underpaintings1862025underpaintings
underpinnings1762015under_pinnings
underpricing1853985under_pricing
underpropping1852285underpropping
undersign1177115unders____ign
underslung1243795unders___lung
undersong1147995unders____ong
underspin1246655unders___pin_
underspins1346835unders___pins
understaffed2052815understa_ffed
understate1148865understa___te
understated1347835understa__ted
understatedly1862275understatedly
understatement1772325understatement
understates1247705understa__tes
understood1244145understood___
understories1365565underst_ories
understudy1543185underst_ud__y
undertaken1545985under_ta_ken_
undertenant1284505under_ten_ant
undertint10414865under_t___int
underusing1247265under___using
underutilizing2561845underutilizing
underwhelming2361535underwhelming
underwing141410885under____wing
underworking2153455under_working
underwriting1754125under_writing
undeserving1643545unde_s_erving
undeviating1644725unde_via_ting
undraping1337335und_r__a_ping
undrawing1436905und_r__a_wing
undressing1246535undres___sing
unending10239945un_e____nding
unfastening1572785un_fasten_ing
unhanding1437205un____handing
unhesitating1652645unhesita_ting
uninstalling1352265un_installing
unleading1138675unle___a_ding
unmeaning1237955unme___an_ing
unreasoning1242975unreas_on_ing
unresting10311135unre_st___ing
unrewarding1642895un__rewarding
unrounding1244875un__r_ounding
unstacking1744995un___stacking
unstating10711215un___sta_ting
unstinting1147305un___stinting
unthreading1644155unthr_ea_ding
untreading1247565un_tr_ea_ding
withstanding2061155_withstanding

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901668.86014084.7
3Display Results1661660.1101509.1
 (SQL Overall)1786911669.37619058.3
 
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.