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

71 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
counterpoints175562(None) 
counterpoint1658171counterpoint_
counterpointed1953592counterpointed
counterpoises1756412counterpoises
counteragents1655173counteragents
counterfeits1756213counterfei_ts
counterfoils1755393counterfoi_ls
counterions1349823counterio_n_s
countermines1649153counter_mines
counterpanes1649303counterp_anes
counterparts1646713counterp_arts
counterplans1687143counterplan_s
counterplots16106233counterp_lots
counterpointing2063033counterpointing
counterpoise1657353counterpoi_se
counterpoised1855303counterpoised
counterposes1647623counterpo_ses
counterposing1885443counterposin_g
counterpowers2064823counterpowers
countersinks1846163counter_sinks
countersuits14126593countersui_ts
colorpoints1552784co__lorpoints
counteracts1547514counter__acts
counteragent1557694counteragent_
counterbids1646034counter_bi_ds
counterblasts1754004counterblasts
countercoups1854604counterco_ups
countercries1648994countercri_es
counterfeit1657734counterfei_t_
counterfires1747064counter_fires
counterfoil1655204counterfoi__l
counterforces2085554counterforces
countering13314474counter__in_g
counterion1249534counterio_n__
countermands1746234counter_mands
countermine1549744counter_min_e
countermoves1956014countermo_ves
countermoving2154164countermovin_g
counterpane1549314counterp_an_e
counterpart1547804counterp_art_
counterpickets2463314counterpickets
counterplan1586774counterplan__
counterplays1995604counterp_lays
counterpleas1655804counterp_leas
counterplot1596814counterp_lot_
counterploys1995354counterp_loys
counterpoising19164194counterpoising
counterpose1547504counterpo__se
counterposed1756324counterpo_sed
counterpower1965864counterpo_wer
counterprojects2862154counterprojects
counterprotest1864434counterprotest
counterprotests1962424counterprotests
counterpunch2154194counterp_unch
counterraids1556604counterrai_ds
countershots1755934counter_shots
countersigns1546424counter_signs
countersink1748064counter_sin_k
counterspies1648314counterspi_es
counterstains15156624counterstain_s
countersuing1547084countersuin_g
countersuit13137504countersui_t_
countertops1546354counterto__ps
countertrends1674354countertrends
countervails1755994countervai_ls
counterviews20134874counter_views
counterweights2372534counterweights
counterworlds1953464counterworlds
interpoint12411884__interpoint_
outpoints1145704_ou_t__points
pourpoints1442584pou___rpoints

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.373479064.3
2DLD Change Limit95024715.53317174.0
3Display Results71710.0461543.5
 (SQL Overall)178691715.95230022.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.