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

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

88 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
counteracting185628(None) 
contracting16610472co_nt_racting
counteraction1755382counteraction
counteractions1855022counteractions
counteractive2055952counteractive
contacting15610073co_nt__acting
contrasting1459353co_nt_rasting
countenancing1853133countenancing
counteract1449603counteract___
counteracted1747363counteract_ed
counteracts1547513counteract__s
counterarguing18113403counterarguing
counterfeiting2054023counterfeiting
countering13314473counter___ing
countermanding2053743countermanding
countermarching2562603countermarching
countermoving2154163countermoving
counterposing1885443counterposing
counterstating1755193counterstating
countersuing1547083counter_suing
countertactic1663913countertacti_c
countertactics1763363countertactics
countervailing2063733countervailing
interacting14411713__interacting
noninteracting1762663noninteracting
underacting1547523__underacting
adulterating1453244adultera_ting
chuntering1647804chunter___ing
coenacting1545874co___enacting
coerecting15218784co___erecting
coinfecting1944574coinfe__cting
cointerring1447144cointer__ring
concerting15313894co_ncer__ting
confecting18310554co_nfe__cting
connecting15310384co_nne__cting
consecrating1747944co_nsecra_ting
consternating1654974consternating
constricting1747024co_nstricting
constructing1746754co_nstructing
contenting13313324co_nte__nting
contesting13312214co_nte__sting
contorting13410104co_ntor__ting
contractile1547354co_nt_ractile
contraction15411244co_nt_raction
contractions16410404co_nt_ractions
contractive1849524co_nt_ractive
contradicting1954074co_nt_radicting
convecting18310434co_nve__cting
converting16313134co_nver__ting
cooperating1648424co_opera_ting
counteragent1557694countera_gent
counterattack2172734counterattack
counterchange2194864counter_change
counterchanging24162974counterchanging
countercharging24183064countercharging
counterchecking2662554counterchecking
counterclaiming2262924counterclaiming
countercries1648994counter_cries
counterfactual2161824counterfactual
countermine1549744counter__mine
counterplotting2062804counterplotting
counterpoint1658174counter_point
counterpointing2063034counterpointing
counterpoising19164194counterpoising
counterpunching2562364counterpunching
counterrallying2162274counterrallying
counterreaction19102374counterreaction
countershading2163834countershading
countersign1447244counter__sign
countersigning1863224countersigning
countersink1748064counter__sink
countersinking2163484countersinking
counterstain14156784counterstain_
counterstaining1863244counterstaining
counterstains15156624counterstains
deuterating1347274deu_tera_ting
exenterating2054214exentera_ting
mountebanking2261544mountebanking
nonteaching1753584no_nte_aching
outacting1239214_ou_t__acting
outeating10814494_ou_te_a_ting
outracing12912164_ou_t_rac_ing
outrating10916404_ou_t_ra_ting
outreaching1744914_ou_treaching
overacting16310914_o__veracting
subtracting1645274_subt_racting
unteaching1645494__unte_aching
untracking1746934__unt_racking

Search took 6 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 Limit95024884.93619251.2
3Display Results88880.0461913.0
 (SQL Overall)178691885.34233450.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.