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

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

64 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
counterproposal2110133(None) 
counterprotest1864434counterprotes_t
counterprotests1962424counterprotests
counterplots16106235counterplo_ts__
counterploys1995355counterplo_ys__
counterpoise1657355counterp_o_is_e
counterpoised1855305counterp_o_ised
counterpoises1756415counterp_o_ises
counterpose1547505counte__r_pos_e
counterposed1756325counte__r_posed
counterposes1647625counte__r_poses
counterproject2763195counterpro_ject
counterprojects2862155counterprojects
countertops1546355counter_top_s__
counterargues1685046counterargues__
counterblows1954216counterblo_ws__
countercoups1854606counter_coups__
countercries1648996countercr_ies__
countercultural1971746countercultural
countercyclical2081076countercyclical
counterfactual2161826counter_factual
counterflows2054356counterflo_ws__
counterfoil1655206counte__r_fo_il
counterfoils1755396counter_foils__
counterforces2085556counterforces__
counterions1349826counter_io_ns__
countermemos1854436counter_memos__
countermoves1956016counter_moves__
counterorders1654476counterorders__
counterpanes1649306counterp_anes__
counterparts1646716counterp_arts__
counterplan1586776counte__r_p_lan
counterplans1687146counterp_lans__
counterplay18105606counte__r_p_lay
counterplays1995606counterp_lays__
counterplea1547036counte__r_plea_
counterpleas1655806counte__r_pleas
counterplot1596816counterp__lo__t
counterplotted1963416counterplo_tted
counterplotting2062806counterplotting
counterploy18105206counterp__lo__y
counterpoint1658176counte__r_point
counterpointed1953596counterp_ointed
counterpoints1755626counterp_o_ints
counterpoising19164196counterp_oising
counterposing1885446counterp_o_sing
counterpower1965866counte__r_power
counterpowers2064826counterp_o_wers
counterpressure1971516counterpressure
counterraids1556606counter_raids__
counterreform2062586counter_refo_rm
counterreforms2162176counter_reforms
counterresponse1961766counterresponse
countershots1755936countersho_ts__
counterspell1653916counte__rsp_ell
countersteps1655886counterstep_s__
counterstrokes2064626counterstrokes__
countertop1445846counter_top____
countertrades1655896countertrades__
countertrends1674356countertrends__
counterworlds1953466counterworlds__
interproximal2461866__interproximal
intertropical1762736__intertropical
underprops1554416__underprop_s__

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.190940478.9
2DLD Change Limit95024647.62312465.4
3Display Results64640.0461391.3
 (SQL Overall)178691647.85922737.1
 
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.