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

95 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
counterprotest186443(None) 
counterprotests1962421counterprotests
counterproject2763192counterproject
counterplots16106223counterplot_s_
counterposes1647613counterp_oses_
counterprojects2862153counterprojects
counterargues1685044counterargues_
countercries1648994countercr_ies_
counterforces2085554counterforces_
countermoves1956014counter_moves_
counterpanes1649304counterp_anes_
counterparts1646704counterpart_s_
counterpicket2355164counterpicke_t
counterpickets2463314counterpickets
counterplot1596814counterplo___t
counterplotted1963414counterplotted
counterploys1995354counterplo_ys_
counterpoint1658174counterp_o_int
counterpoints1755614counterp_oints
counterpoise1657354counterp_o_ise
counterpoised1855304counterp_oised
counterpoises1756404counterp_oises
counterpose1547504counterp_o__se
counterposed1756324counterp_ose_d
counterpower1965864counterp_owe_r
counterpowers2064824counterp_owers
counterproposal21101334counterproposal
countershots1755934countershot_s_
counterstates1586644counterstates_
counterstrokes2064624counterstrokes_
countertrades1655894countertrades_
contemplates1855285co_ntemplates_
counteracted1747365counter_acte_d
counteracts1547495counter_act_s_
counteragent1557695counte__ragent
counterargue1555305counterargue__
counterargued1754225counterargue_d
counterargument2072025counterargument
counterblast1655405counte__rblast
counterblows1954215counterblo_ws_
countercoups1854605counter_coups_
countercurrent1863465countercurrent
counterfeit1657735counte__r_feit
counterfeited1974775counterfeite_d
counterfeiter1874745counterfeite_r
counterfeiters19103745counterfeiters
counterfeits1756205counterfeit_s_
counterfires1747065counter_fires_
counterflows2054355counterflo_ws_
counterfoils1755395counter_foils_
counterforce1985795counterforce__
counterimages1854615counterimages_
counterions1349815counter_io_ns_
counterirritant1771735counterirritant
countermarches2373745countermarches_
countermines1649155counter_mines_
countermove1855855counter_move__
countermoved2054995counter_move_d
countermyths2253555counter_myths_
counterorder1555605counteror_de_r
counterorders1654475counteror_ders
counterpane1549315counterp_ane__
counterpart1547805counterp___art
counterplans1687145counterp_lans_
counterplayer2055045counterplaye_r
counterplayers2153805counterplayers
counterplays1995605counterp_lays_
counterplea1547035counterp__le_a
counterpleas1655805counterp__leas
counterplotting2062805counterplotting
counterploy18105205counterplo___y
counterpointed1953595counterpointe_d
counterposing1885445counterp_osing
counterpunches2383245counterpunches_
counterraids1556595counter_raids_
countershot1656635countersho___t
counterspies1648305counter_spies_
counterstate1457035counterstate__
counterstated1665635counterstate_d
counterstep1547115counte__rste_p
countersteps1655885counte__rsteps
counterstrategy2182135counterstrategy
counterstrikes2094745counterstrikes_
counterstroke1954785counterstroke__
counterstyles1854785counterstyles_
countersues1348535counte__rsues_
countersuits14126585countersuit_s_
counterthreat1854055counter_threat
counterthrust1873605counter_thrust
countertops1546355counter_to_ps_
countertrade1556295countertrade__
countertrend1575945countertr__end
countertrends1674355countertrends_
counterworlds1953455counterworlds_
overprotect1854575_o__verprotect

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 Filter178691950240.1401276364.3
2DLD Change Limit95024959.03310519.7
3Display Results95950.0761250.0
 (SQL Overall)178691959.24919320.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.