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

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

83 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
announcements176290(None) 
announcement1663071announcement_
denouncements18143802denouncements
renouncements17163902renouncements
denouncement17174093denouncement_
pronouncements2071863pronouncements
renouncement16184363renouncement_
accouchements2161984accouchements
accoutrements1972374accoutrements
advancements2052814a_dvancements
announcers1242684announc__e_rs
announces1144484announc__e__s
annulments1244654ann_u__lments
anointments1355434a_noin_tments
atonements1247204a_to_n_ements
attunements1353724a_ttun_ements
avouchments2152714a_vou_chments
denouements1446474denou__ements
enforcements1954954enfo_rcements
enhancements1954894_enhancements
ennoblements1654124enno_blements
entrancements17105174entrancements
inducements1655534_indu_cements
pronouncement1962114pronouncement_
accouchement2062125accouchement_
accouterments1992065accouterments
accoutrement1892605accoutrement_
accruements1753775accru__ements
acquirements2552695a_cquirements
adjournments2251975adjou_rnments
adornments1345165a_dorn__ments
advancement1953165a_dvancement_
alinements1247135a__lin_ements
allurements1353655a_llu_rements
amercements1755265a__mercements
amusements1446235a__mu_sements
announce1044325announc__e___
announced1243295announc__e__d
announcer1143295announc__e__r
announcing1342995announc__in_g
annulment1145685ann_u__lment_
anointment1256465a_noin_tment_
antecedents1453345a_n_tecedents
appointments1863155appoin_tments
arrangements1554325a_rrangements
assuagements1552975a_ssuagements
atonement1149055a_to_n_ement_
attornments1353955attorn__ments
attunement1254375a_ttun_ement_
avouchment2053085a_vou_chment_
cantonments1554415canto_n__ments
commencements20112445commencements
confinements1954945confin_ements
couplements1756195__couplements
debouchments2272445debou_chments
deforcements2054665defo_rcements
denotements1446865deno__tements
denouement1357505denou__ement_
denudements1545335den_u_dements
divorcements2054415divo_rcements
encouragements1962175encouragements
endorsements1555495endo_rsements
enforcement1855685enfo_rcement_
engorgements1694665engo_rgements
enhancement1855625_enhancement_
enlacements1546995_en_lacements
ennoblement1554855enno_blement_
enticements1598165_en_ticements
entrancement1686135entrancement_
entrenchments2052805entrenchments
impoundments1972435impoun_dments
indorsements1565185indo_rsements
inducement1546085_indu_cement_
infringements1963355infringements
innocents1145315inno__c__ents
inurements1249145_in_u_rements
involvements2053375invo_lvements
nonevents1247485__no_n_events
nonincumbents1961905_nonincumbents
rousements1247335__rou_sements
seducements1654495_sedu_cements
solacements1554385__solacements
traducements1752575tradu_cements

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 Filter1786911247900.393454684.5
2DLD Change Limit124790837.93615724.5
3Display Results83830.0631317.5
 (SQL Overall)178691838.39221293.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.