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

75 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
countertactics176336(None) 
countertactic1663911countertactic_
counteracting1856283counter_acting
counteraction1755383counter_action
counteractions1855023counter_actions
counteractive2055953counter_active
counteracts1547513counter_act__s
counteract1449604counter_act___
counteracted1747364counter_act_ed
counterattack2172734counter_attack
counterattacks2272254counter_attacks
countercries1648994counter__cries
counterfactual2161824counterfactual
counterparts1646714counterpart__s
counterraids1556614counterra__ids
counterrallies1683954counterrallies
counterreaction19102374counterreaction
counterstains15156624countersta__ins
counterstates1586644countersta_t_es
counterstating1755194countersta_ting
countervails1755994counterva__ils
contestants1356805co_ntestant__s
contestation1448665co_ntesta_tion
contestations1547745co_ntesta_tions
contractile1547355co_nt_r_actile
contracting16610475co_nt_r_acting
contraction15411245co_nt_r_action
contractions16410405co_nt_r_actions
contractive1849525co_nt_r_active
contractors1549165co_nt_r_actors
contracts132212015co_nt_r_act__s
counteragents1655175counter_agents
counterargues1685045counter_argues
counterbalance20123245counterbalance
counterbalances21122825counterbalances
counterbids1646045counter___bids
counterblasts1754005counterblast__s
countercheck2254115counter__check
counterchecks2353325counter__checks
counterclaims1954445counter_claims
countercoups1854605counter__coups
countercyclical2081075countercyclical
counterfeiters19103745counterfeiters
counterfeiting2054025counterfeiting
counterfeits1756215counter__feits
counterfoils1755405counter__foils
countermanding2053745countermanding
countermands1746235counterma__nds
countermarch2154465counterma__rch
countermarches2373745countermarches
countermarching2562605countermarching
countermyths2253555counter_myt_hs
counterpanes1649305counterpa__nes
counterpart1547805counterpart___
counterpickets2463315counterpickets
counterplots16106235counterplot__s
counterraid1446755counterra__i_d
counterrallied1763255counterrallied
countershots1755935countershot__s
counterspies1648315counter__spies
counterstain14156785countersta__i_n
counterstaining1863245counterstaining
counterstate1457035countersta_t__e
counterstated1665635countersta_t_ed
countersteps1655885counter__steps
countersuits14126595counter__suits
countertenors1554065countert_enors
counterterrors1662485counterterrors
counterthreats1962875counterthreats
counterthrusts1982465counterthrusts
countertops1546355counter___tops
countertrades1655895countert_rades
countertrends1674355countert_rends
countervail1655655counterva__i_l
countervailing2063735countervailing

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 Filter178691950240.360496363.9
2DLD Change Limit95024757.18613223.5
3Display Results75750.0461630.4
 (SQL Overall)178691757.59223536.7
 
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.