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

57 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
counterattacks227225(None) 
counterattack2172731counterattack_
counterattacked2471952counterattacked
counterattacker2371792counterattacker
counteractions1855024counteractions
counteracts1547514counter___acts
counterchecks2353324counter_checks
counterstains15156624counter_stains
counterstates1586644counter_states
counterstruck2163194counterstruck_
countertactics1763364countertactic_s
countertrades1655894counter_trades
cornerbacks2151925corn_er__backs
countenances1655735countena__nces
counteract1449605counter___ac_t
counteracted1747365counteract__ed
counteracting1856285counteract_ing
counteraction1755385counteract_ion
counteractive2055955counteract_ive
counteragents1655175countera_gents
counterargues1685045countera_rgues
counterassault1682055counterassault
counterassaults1791445counterassaults
counterbalances21122825counterbalances
counterblasts1754005counter_blasts
countercheck2254115counter_check_
counterclaims1954445counter_claims
counterdemands2062395counterdemands
counterforces2085555counter_forces
counterimages1854615counter_images
countermands1746235counter__mands
countermyths2253555countermyt__hs
counterpanes1649305counter__panes
counterparts1646715counter__parts
counterplans1687145counter_pla_ns
counterplays1995605counter_pla_ys
counterpleas1655805counterplea__s
counterraids1556605counter__raids
countersinks1846165counter__sinks
counterstain14156785counter_sta_in
counterstate1457035counter_sta_te
counterstated1665635counter_stated
counterstating1755195counterstating
countersteps1655885counter_st_eps
counterstreams18102805counterstreams
counterstricken2372745counterstricken
counterstrike1965295counter_strike
counterstrikes2094745counterstrikes
counterstroke1954785counter_stroke
counterstrokes2064625counterstrokes
counterstyles1854785counter_styles
countertactic1663915counter__tactic
countertenors1554065counter_tenors
countertops1546355counter__t_ops
countertrade1556295counter_tra_de
countertrends1674355counter_trends
countervails1755995counter__vails

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 Limit95024577.36012910.9
3Display Results57570.0301900.0
 (SQL Overall)178691577.75023056.9
 
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.