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

73 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
counterattack217273(None) 
counterattacks2272251counterattacks
counterattacked2471952counterattacked
counterattacker2371792counterattacker
counterstruck2163193counterstruck
counteract1449604counter___act
counteracted1747364counteract_ed
counteracting1856284counteracting
counteraction1755384counteraction
counteractive2055954counteractive
counteracts1547514counteract__s
countercheck2254114counter_check
counterstain14156784counter_stain
counterstate1457034counter_state
counterstated1665634counterstated
counterstates1586644counterstates
countertactic1663914countertactic_
countertactics1763364countertactics
countertrade1556294counter_trade
cornerback2052115corn_er__back
countenance1555875countena__nce
counteractions1855025counteractions
counteragent1557695countera_gent
counteragents1655175counteragents
counterargue1555305countera_rgue
counterargued1754225counterargued
counterargues1685045counterargues
counterassault1682055counterassault
counterbalance20123245counterbalance
counterblast1655405counter_blast
counterchecks2353325counter_checks
counterclaim1854755counter_claim
counterdemand1963215counterdemand
counterfactual2161825counterfactual
counterforce1985795counter_force
counterimage1754985counter_image
counterinstance19101795counterinstance
counterman1448555counter__ma_n
countermand1647125counter__mand
countermarch2154465counter_march
countermyth2153795countermyt__h
countermyths2253555countermyt_hs
counterpane1549315counter__pane
counterpart1547805counter__part
counterparts1646715counterpart__s
counterplan1586775counter_pla_n
counterplans1687145counter_plans
counterplay18105605counter_pla_y
counterplays1995605counter_plays
counterplea1547035counterplea__
counterpleas1655805counterplea_s
counterpunch2154195counter_punch
counterraid1446755counter__raid
countersink1748065counter__sink
counterstains15156625counterstains
counterstating1755195counterstating
counterstep1547115counter_st_ep
countersteps1655885counter_steps
counterstream1773735counterstream
counterstreams18102805counterstreams
counterstricken2372745counterstricken
counterstrike1965295counterstrike
counterstroke1954785counterstroke
counterstyle1755055counter_style
counterstyles1854785counterstyles
countersunk1755265counter__sunk
countertenor1454755counter_tenor
countertop1445845counter__t_op
countertops1546355counter__tops
countertrades1655895counter_trades
countertrend1575945counter_trend
countervail1655655counter__vail
postattack1851775po_st__attack

Search took 10 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.390458182.1
2DLD Change Limit124790739.08013743.4
3Display Results73730.0461587.0
 (SQL Overall)178691739.51618778.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.