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

118 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
undershooting185255(None) 
overshooting1944603_overshooting
undercoating1645373under_coating
undercooking2063243under_cooking
undercooling1653693under_cooling
underheating1785133under_heating
underscoring1653633unders_coring
undershoot1445103undershoot___
undershoots1553453undershoot__s
understating1446543unders_tating
reshooting1436224__re_shooting
underacting1547524under__acting
undercharging2152594undercharging
underclothing2061894underclothing
undercoatings1753064under_coatings
undercounting1763084undercounting
undercutting1653764under_cutting
underdoing1346804under__do_ing
underdosing1444494under__dosing
undereating1369554under__eating
underexposing2461934underexposing
undergoing1347084under__go_ing
underletting1454184under_letting
underloading1564294under_loading
underpainting1763554underpainting
underpropping1852284underpropping
underrating1388254under__rating
underreacting1752834underreacting
underreporting1861584underreporting
underselling1453974unders_elling
undershorts1543694undershort__s
undershot1346894undersh_ot___
undersigning1553464unders_igning
undersong1147994unders__o__ng
understaffing21102734understaffing
understanding1673774understanding
understeering1573064understeering
understudying1962144understudying
underthrusting1961264underthrusting
underwhelming2361534underwhelming
underworking2153454under_working
underwriting1754124under_writing
unrooting1098834un__r__ooting
upshooting1642554u___pshooting
beshouting1644025__be_shouting
dehorting1447215__de__horting
disrooting1247745__d_isrooting
enrooting10128135en__r__ooting
interknotting1852665interknotting
interlooping1554315inter_looping
intersecting1549715inters_ecting
outshooting15104155__outshooting
sharpshooting2271215sharpshooting
shooting122812865_____shooting
snapshotting1851445sn_apshotting
trapshooting1852505_trapshooting
underachieving2461325underachieving
underbaking1995165under__baking
underbidding1852775under_bidding
underbudding1852815under_budding
underbuying1843455under__buying
underclothings216965underclothings
underestimating1972075underestimating
underfeeding1853185under_feeding
underfoot1347035under_foot___
underfunding1873505under_funding
undergirding1653325under_girding
underhung1445185under_h___ung
underlapping1853515under_lapping
underlaying16125765under__laying
underling111514615under____ling
underlining1346685under__lining
underlying15136375under___lying
undermining1546365under__mining
underpaintings1862025underpaintings
underpaying18125375under__paying
underpinning1653425under_pinning
underplaying19154355under_playing
underpricing1853985under_pricing
underrunning1452705under_running
undershirt1446455undersh___irt
undershirted1753475undershirt_ed
undershirts1554125undershirt__s
undersign1177115unders____ign
underslung1243795unders___lung
undersoil1056775unders__o_i_l
undersoils1156065unders__o_ils
undersongs1245335unders__o__ngs
underspin1246655unders___pin_
underspins1346835unders___pins
understaffings22121595understaffings
understand1246185unders___tand
understandings17112375understandings
understood1244145understoo___d
understories1365565unders_tories
undertaking1796585under__taking
undertaxing20105585under__taxing
undertint10414865under____tint
underusing1247265under___using
undervaluing1753385under_valuing
underwing141410885under____wing
undeserving1643545unde_s_erving
undesigning1453445unde_s_igning
undeviating1644725unde__viating
undressing1246535undres___sing
unforthcoming247455unforthcoming
unhesitating1652645unhe_sitating
unhooding1435895un____hooding
unhooking1735355un____hooking
unleashing1444465unleash___ing
unmeshing1595935unme_sh___ing
unreasoning1242975unreas__oning
unresting10311135unre_s___ting
unroofing1385705un__r__oofing
unshifting1743865un___shifting
unspooling1343855un___spooling
unweighting1952305unweigh__ting
uprooting1276905u__pr__ooting

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 Filter1786911247900.373479064.3
2DLD Change Limit1247901188.28315065.8
3Display Results1181180.0631873.0
 (SQL Overall)1786911188.71920494.4
 
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.