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

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
understatements188167(None) 
understatement1772321understatement_
overstatements1962493_overstatements
overstatement1863004_overstatement_
restatements1455284__re_statements
undergarments1762804under_ga_rments
underlayments1972644under_la_yments
underpayments2162504under_pa_yments
understates1247704understat__e__s
debatements1656045__de__batements
endorsements1555495endors___ements
entertainments1672455enter_tainments
indorsements1565185indors___ements
interlacements1862665inter_lacements
misstatements17122905__misstatements
reinstatements1661915_reinstatements
restatement1356265__re_statement_
statements1256885_____statements
undergarment1653645under_ga_rment_
underlayment1853405under_la_yment_
underpayment2063215under_pa_yment_
understaffings22121595understa_ffings
understandings17112375understa_ndings
understands1344655understa____nds
understate1148865understat__e___
understated1347835understat__e__d
understatedly1862275understat__edly
understating1446545understat__in_g
understeers1253765unders__te_e_rs
undertenants1362945under___tenants
unsettlements1562745unse__ttlements
advertisements20182856adver_tisements
advertizements29162276adver_tizements
ascertainments1861746ascer_tainments
bereavements19154206__ber_eavements
curettements1652486__curet_tements
debasements1666176__de__basements
debatement1547076__de__batement_
defacements1946076__de__facements
denotements1446866__de__notements
depravements2054456__de_pravements
derailments1446106__der__ailments
derangements1665826__der_angements
despisements1785166__de_spisements
detachments1954596__de__tachments
detainments1485896__de__tainments
devotements1745616__de__votements
endearments14115386ende___a_rments
endorsement1456306endors___ement_
enframements1954626en_fr__amements
enslavements1754126___enslavements
entertainment1563056enter_tainment_
entreatments14114396en_tr_eat_ments
escapements1744826___e_scapements
forestallments1961186fore_stallments
indorsement1455776indors___ement_
installments1453276in___stallments
instalments1354416in___sta_lments
interlacement1753486inter_lacement_
interstates11710206interstat__e__s
intertwinements2071536intertwinements
investments1665906inve_s__t_ments
misstatement16113366__misstatement_
reinstatement1562276_reinstatement_
statement1148796_____statement_
testaments1265356__te_sta__ments
underclassmen18171796underclassmen__
undercoatings1753066undercoat__ings
undercurrents1692026under__currents
undereaten1149546under_eat__en__
underpants1346916under_pa____nts
underrates11410566under_rat__e__s
undersets10129326unders_____e_ts
understaffed2052816understa_ffe__d
understaffing21102736understa_ffin_g
understand1246186understa____n_d
understanding1673776understa_ndin_g
understeer1145816unders__te_e__r
understeered1452926unders__te_ered
understeering1573066underst_eerin_g
understories1365566underst_orie__s
understrappers1961426understrappe_rs
understrength1861456underst_re_ngth
understudies1453326underst_udie__s
undertaken1545986under_ta__ken__
undertakers1643816under_ta__ke_rs
undertakes1547696under_ta__ke__s
undertakings1894036under_ta__kings
undertaxes1847026under_ta__xe__s
undertenant1284506under___tenant_
undertints1148286under___t__ints
unsettlement1462886unse__ttlement_

Search took 9 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.406440125.6
2DLD Change Limit95024927.81312162.3
3Display Results92920.0601533.3
 (SQL Overall)178691928.27921583.6
 
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.