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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
understudying196214(None) 
overstudying2043173_overstudying
underbudding1852813under_budding
underbuying1843453under_bu_ying
understaffing21102733understaffing
understanding1673773understanding
understating1446543underst_ating
understeering1573063understeering
understudied1553253understud_ied
understudies1453323understud_ies
understudy1543183understudy___
restudying1543424__re_studying
underbidding1852774under_bidding
undercounting1763084undercounting
undercutting1653764under_cutting
underdoing1346804under___doing
underfeeding1853184underfeed_ing
underfunding1873504under_funding
undergirding1653324undergird_ing
underlaying16125764under__laying
underloading1564294underload_ing
underlying15136374under___lying
underpaying18125374under__paying
underplaying19154354under_playing
underrunning1452704under_running
underscoring1653634unders_coring
underselling1453974unders_elling
undershooting1852554undershooting
undersigning1553464unders_igning
underslung1243794underslu___ng
understaffings22121594understaffings
understandings17112374understandings
undertaking1796584under_t_aking
undertaxing20105584under_t_axing
underusing1247264under__u_sing
bestudding1542655__be_studding
destroying1564905__de_stroying
indenturing1342875inde_ntu_ring
outstudying1642155__outstudying
overstaying1847055_overst_aying
overstuffing2253055_overstuffing
oversudsing1645015_overs_udsing
studying1335555_____studying
thunderstriking2481425thunderstriking
undemanding1653445unde_mand_ing
underacting1547525under__acting
underbaking1995165under__baking
undercharging2152595undercharging
underclothing2061895underclothing
undercoating1645375under_coating
undercooking2063245under_cooking
undercooling1653695under_cooling
underdosing1444495under__dosing
undereating1369555under__eating
underestimating1972075underestimating
underexposing2461935underexposing
undergoing1347085under___going
underheating1785135under_heating
underhung1445185under_hu___ng
underlapping1853515under_lapping
underletting1454185under_letting
underling111514615under____ling
underlining1346685under__lining
undermining1546365under__mining
underpainting1763555underpainting
underpinning1653425under_pinning
underpricing1853985under_pricing
underpropping1852285underpropping
underrating1388255under__rating
underreacting1752835underreacting
undersign1177115unders____ign
undersong1147995unders____ong
underspin1246655unders___pin_
underspins1346835unders___pins
understand1246185underst___and
understandingly2171595understandingly
understories1365565underst_ories
understory1445125understory___
undertakings1894035under_t_akings
underthrusting1961265underthrusting
undertint10414865under_t___int
underutilizing2561845underutilizing
undervaluing1753385under_valuing
underwhelming2361535underwhelming
underwing141410885under____wing
underworking2153455under_working
underwriting1754125under_writing
undeserving1643545unde_s_erving
undesigning1453445unde_s_igning
undressing1246535undres___sing
ungrudging1452455un_gr__udging
unresting10311135unre_st___ing
unsteadying1641795un___steadying
untidying1445475un____tidying

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.393454684.5
2DLD Change Limit124790949.42013247.3
3Display Results94940.0631492.1
 (SQL Overall)178691949.87618093.5
 
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.