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

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

92 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
underacted144925(None) 
interacted13411212interacted
undebated1338092undeba_ted
undefaced1644752undefac_ed
underact11311512underact__
underacts1248582underact_s
underaged121011232undera_ged
underate9918602undera_te_
underrated12310842underrated
underreacted1653602underreacted
undetected1444872undetected
undirected1445012undirected
counteracted1747363counteracted
derated93623503__dera_ted
deratted1048403__deratted
detracted1357793__detracted
federated1438413federa_ted
indurated1139013indura_ted
infracted1546363in_fracted
moderated1388143modera_ted
numerated12177873numera_ted
overacted1539633_overacted
ulcerated1247743ulcera_ted
unacted10312733un___acted
unbraced132310433un_brac_ed
uncracked18226803un_cracked
uncrated11416313un_cra_ted
uncreated12312303uncrea_ted
undated93118463und__a_ted
undecayed1645173undeca_yed
undecked16238493unde__cked
undecorated1545723undecora_ted
undedicated1654813undedicated
undefeated1546203undefeated
undeleted1148063unde_leted
undented102313953unde__nted
underacting1547523underacting
underactive1745953underactive
underage101012273undera_ge_
underages11811083undera_ges
underbaked1846173underbaked
underbite1249813underbite_
underbites1347893underbites
underbred1338993under_bred
undercard1347003under_card
underclad1345563under_clad
undercoated1546823undercoated
underdosed1346153underdosed
undereaten1149543undereaten
underfed13311713under__fed
underfeed1448633under_feed
underhanded1744663underhanded
underheated1647013underheated
underived14310503under_ived
underlapped1753693underlapped
underlined121610203underlined
undermanned1544183undermanned
undermined14189123undermined
underrate10411893underrate_
underrates11410553underrates
underscored1545143underscored
undersexed1946083undersexed
undersized2148203undersized
understated1347833understated
undertaxed1946513undertaxed
underused1139323under_used
undervalued1643793undervalued
undervote1357753undervote_
undervotes1456533undervotes
underwater1446643underwater
undistracted1653253undistracted
undrained1138513und_rained
undraped1239393und_ra_ped
undreamed1336973undrea_med
undulated11310083undula_ted
uneducated1444513uneducated
unelected1237823un_elected
unerased9312773un_era_sed
unexalted1744333un_exalted
ungraced12239143un_grac_ed
unheated121514553unhe_a_ted
unheralded1543533unheralded
unmerited1239643unmer_ited
unrated82621553un__ra_ted
unreached1536883unre_ached
unrelated10310433unrela_ted
unseated91317683unse_a_ted
unselected1344973unselected
untenanted1144453untenanted
untraced112413243un_trac_ed
untracked16228373un_tracked
untreated10312903untrea_ted

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 Filter1786911406030.310576422.6
2DLD Change Limit140603926.75320820.8
3Display Results92920.0303066.7
 (SQL Overall)178691927.09325192.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.