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 “countercampaign” 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.

87 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
countercampaign247167(None) 
counteracting1856285counter_a_cting
counteraction1755385counter_a_ction
counterarguing18113405counter_arguing
counterchange2194865counterc__hange
counterchanging24162975counterchanging
countercharge2194295counterc__harge
countercharging24183065countercharging
counterchecking2662555counterchecking
counterclaim1854755counterc__lai_m
counterclaiming2262925counterclaiming
counterclaims1954445counterc__laims
counterimage1754985counter_im_a_ge
counterman1448555counter__m_a__n
countermanding2053745counterma_nding
countermarching2562605countermarching
countermoving2154165counter__moving
counterrallying2162275counterrallying
countersign1447245counter____sign
counterstain14156785counter__stai_n
countervailing2063735counterva_iling
contraception1953756co_nt_raception
contraption1548106co_nt_r_a_ption
countenancing1853136counte_na_ncing
counteractions1855026counter_a_ctions
counteractive2055956counter_a_ctive
counterassault1682056counter_assault
counterattack2172736counter_atta_ck
counterattacks2272256counter_attacks
counterbalance20123246counterba_lance
counterchanged23103776counterc__hanged
counterchanges22124226counterc__hanges
countercharged23113616counterc__harged
countercharges22104116counterc__harges
counterclaimed2163526counterc__laimed
countercoup1774496countercoup____
countercoups1854606countercoup___s
countercries1648996counterc___ries
counterdemand1963216counterdem_a_nd
counterdemands2062396counterdem_ands
counterexample27151726counterexamp__le
counterexamples28251536counterexamp_les
counterfeiting2054026counter_feiting
counterimages1854616counter_im_ages
countering13314476counter_____ing
counterion1249536counter_____ion
countermand1647126counter__m_a_nd
countermands1746236counter__m_ands
countermarch2154466counter__m_arch
countermen1449296counter__m___en
countermine1549746counter__m__ine
counterordering19162416counterordering
counterpane1549316counter___pa_ne
counterpanes1649306counter___panes
counterpart1547806counter___pa_rt
counterparts1646716counter___parts
counterpetition1961946counterpetition
counterplan1586776counter___p_lan
counterplotting2062806counterplotting
counterpoint1658176counter___point
counterpointing2063036counterpointing
counterpoise1657356counter___poise
counterpoising19164196counter_poising
counterposing1885446counter__posing
counterpunching2562366counterpunching
counterquestion2671216counterquestion
counterraid1446756counter___rai_d
counterraids1556606counter___raids
counterrallied1763256counterra_llied
counterrallies1683956counterra_llies
counterreaction19102376counterreaction
countershading2163836counter_shading
countersigning1863226counter_signing
countersigns1546426counter____signs
countersinking2163486counter_sinking
counterspies1648316counter__sp_ies
counterstaining1863246counterstaining
counterstains15156626counter__stains
counterstating1755196counter_stating
counterstriking2262946counterstriking
countersuing1547086counter___suing
countertactic1663916counterta_cti_c
countertactics1763366counterta_ctics
countervail1655656counter___vai_l
countervails1755996counter___vails
countryman1753576count_r_ym_a__n
intercomparing2162286__intercomparing

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.343520965.0
2DLD Change Limit95024877.64012437.7
3Display Results87870.093935.5
 (SQL Overall)178691878.07622126.2
 
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.