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

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

46 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
underreacting175283(None) 
underacting1547522unde_r_acting
undereating1369552unde_rea_ting
underheating1785132underhea_ting
underrating1388252underr_a_ting
overreacting1856663_overreacting
undercoating1645373undercoa_ting
underletting1454183underle_tting
underreact1344683underreact___
underreacted1653603underreact_ed
underreacts1453023underreact__s
underreporting1861583underreporting
understating1446543understa_ting
deprecating1777284__deprecating
detracting1438714__detr_acting
interacting14411714inte_r_acting
interjecting2248394interje_cting
interrelating1457294interrelating
intersecting1549714interse_cting
overreaching2175174_overreaching
uncreating13310474un__crea_ting
underactive1745964unde_r_active
underbaking1995164unde_rba_king
undercharging2152594undercharging
undercoatings1753064undercoa_tings
undercounting1763084undercounting
undercutting1653764unde_rcutting
undereaten1149544unde_rea_ten_
underfeeding1853184underfe_eding
underlapping1853514unde_rlapping
underlaying16125764unde_rla_ying
underloading1564294underloa_ding
underpainting1763554underpainting
underpaying18125374unde_rpa_ying
underplaying19154354underpla_ying
underpricing1853984underpric_ing
underrunning1452704underr_unning
underselling1453974underse_lling
undershooting1852554undershooting
understaffing21102734understaffing
understanding1673774understanding
undertaking1796584unde_rta_king
undertaxing20105584unde_rta_xing
undervaluing1753384unde_rvaluing
underwriting1754124unde_rwriting
undeviating1644724unde_via_ting

Search took 6 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 Filter178691950240.360496363.9
2DLD Change Limit95024464.65620408.9
3Display Results46460.0301533.3
 (SQL Overall)178691465.04635412.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.