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

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
understatements1881671understatements_
understatement1772322understatement__
overstatements1962494_overstatements_
overstatement1863005_overstatement__
restatements1455285__re_statements_
undergarments1762805under_ga_rments_
underlayments1972645under_la_yments_
underpayments2162505under_pa_yments_
understates1247705understat__e__s_
debatements1656046__de__batements_
endorsements1555496endors___ements_
entertainments1672456enter_tainments_
indorsements1565186indors___ements_
interlacements1862666inter_lacements_
misstatements17122906__misstatements_
reinstatements1661916_reinstatements_
restatement1356266__re_statement__
statements1256886_____statements_
undergarment1653646under_ga_rment__
underlayment1853406under_la_yment__
underpayment2063216under_pa_yment__
understaffings22121596understa_ffings_
understandings17112376understa_ndings_
understands1344656understa____nds_
understate1148866understat__e____
understated1347836understat__e___d
understatedly1862276understat__e_dly
understating1446546understat__in__g
understeers1253766unders__te_e_rs_
undertenants1362946under___tenants_
unsettlements1562746unse__ttlements_
advertisements20182857adver_tisements_
advertizements29162277adver_tizements_
ascertainments1861747ascer_tainments_
bereavements19154207__ber_eavements_
curettements1652487__curet_tements_
debasements1666177__de__basements_
debatement1547077__de__batement__
defacements1946077__de__facements_
denotements1446867__de__notements_
depravements2054457__de_pravements_
derailments1446107__der__ailments_
derangements1665827__der_angements_
despisements1785167__de_spisements_
detachments1954597__de__tachments_
detainments1485897__de__tainments_
devotements1745617__de__votements_
endearments14115387ende___a_rments_
endorsement1456307endors___ement__
enframements1954627en_fr__amements_
enslavements1754127___enslavements_
entertainment1563057enter_tainment__
entreatments14114397en_tr_eat_ments_
escapements1744827___e_scapements_
forestallments1961187fore_stallments_
indorsement1455777indors___ement__
installments1453277in___stallments_
instalments1354417in___sta_lments_
interlacement1753487inter_lacement__
interstates11710207interstat__e__s_
intertwinements2071537intertwinements_
investments1665907inve_s__t_ments_
misstatement16113367__misstatement__
reinstatement1562277_reinstatement__
statement1148797_____statement__
testaments1265357__te_sta__ments_
underclassmen18171797underclassmen___
undercoatings1753067undercoat__ings_
undercurrents1692027under__currents_
undereaten1149547under_eat__en___
underpants1346917under_pa____nts_
underrates11410567under_rat__e__s_
undersaturated1662497unders_at_urated
undersets10129327unders_____e_ts_
understaffed2052817understa_ffe___d
understaffing21102737understa_ffin__g
understand1246187understa____n__d
understanding1673777understa_ndin__g
understandingly2171597understa_ndingly
understeer1145817unders__te_e___r
understeered1452927unders__te_e_red
understeering1573067unders__te_ering
understories1365567underst_orie__s_
understrappers1961427understrappe_rs_
understrength1861457unders__t_rength
understudies1453327underst_udie__s_
undertaken1545987under_ta__ken___
undertakers1643817under_ta__ke_rs_
undertakes1547697under_ta__ke__s_
undertakings1894037under_ta__kings_
undertaxes1847027under_ta__xe__s_
undertenant1284507under___tenant__
undertints1148287under___t__ints_
unsettlement1462887unse__ttlement__

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 Filter178691950240.376475242.0
2DLD Change Limit95024948.76610840.1
3Display Results94940.0761236.8
 (SQL Overall)178691949.21819385.0
 
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.