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

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

101 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
undercoating164537(None) 
undercoatings1753061undercoatings
undercooking2063242undercooking
undercooling1653692undercooling
undercounting1763082undercounting
undercutting1653762undercutting
undereating1369552under_eating
underheating1785132underheating
underloading1564292underloading
underrating1388252under_rating
understating1446542understating
uncoating12611923un___coating
underacting1547523under_acting
underbaking1995163under_baking
undercharging2152593undercharging
underclothing2061893underclothing
undercoat1248733undercoat___
undercoated1546823undercoat_ed
undercoats1346623undercoat__s
underdoing1346803underdo__ing
underdosing1444493underdo_sing
undergoing1347083undergo__ing
underlaying16125763under_laying
underletting1454183underletting
underpaying18125373under_paying
underplaying19154353underplaying
underreacting1752833underreacting
underscoring1653633undersco_ring
undershooting1852553undershooting
undertaking1796583under_taking
undertaxing20105583under_taxing
underworking2153453underworking
underwriting1754123underwriting
undeviating1644723unde_viating
altercating1455604alterc_ating
decocting1538124__de_cocting
decorating14312074__de_corating
derating103222284__der__ating
derogating1348634__derogating
enervating1488434en_er_vating
federating1548854feder__ating
indicating1449694ind_ic_ating
indurating1249244indur__ating
innervating1546364inner_vating
intercalating1656504intercalating
intercepting1748874intercepting
intercutting1545944intercutting
interpolating1657794interpolating
interrogating1556664interrogating
moderating1448804moder__ating
numerating1357234numer__ating
percolating1657324__percolating
recoating121317464__re_coating
redecorating16115054rede_corating
sugarcoating1651844sugarcoating
ulcerating1346984ulcer__ating
unbecoming1743094unbe_co_ming
uncoatings1384794un___coatings
uncrating12813184un___crating
uncreating13310474un_cr_eating
undeceiving1853054unde_ceiving
underbidding1852774underbidding
underbudding1852814underbudding
underbuying1843454under_buying
underclothings216964underclothings
undercount1346384underco__unt
undereaten1149544under_eaten_
underfeeding1853184underfeeding
underfunding1873504underfunding
undergirding1653324undergirding
underlain1048684under_la_in_
underlapping1853514underlapping
underling111514614under___ling
underlining1346684under_lining
underlying15136374under__lying
undermining1546364under_mining
underpainting1763554underpainting
underpinning1653424underpinning
underpricing1853984underpricing
underpropping1852284underpropping
underreporting1861584underreporting
underrunning1452704underrunning
underselling1453974underselling
undersigning1553464undersigning
undersong1147994underso___ng
understaffing21102734understaffing
understanding1673774understanding
undertakings1894034under_takings
undertint10414864under___tint
underusing1247264under__using
undervaluing1753384undervaluing
underwing141410884under___wing
undraping1337334und_r__aping
undrawing1436904und_r__awing
undulating1247144und__ulating
unexciting2042994un_exc_iting
unhesitating1652644unhesitating
unrooting1098834un__r_ooting
unseating10713204unse___ating
uppercasing1852764upperc_asing
uppercutting1951534uppercutting

Search took 8 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.390458182.1
2DLD Change Limit1247901016.62318841.9
3Display Results1011010.0631603.2
 (SQL Overall)1786911017.07625253.1
 
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.