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

89 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
counterpoint165817(None) 
counterpoints1755621counterpoints
counterpointed1953592counterpointed
counterpoise1657352counterpoise
counterposing1885442counterposing
counteragent1557693counteragent
counterfeit1657733counterfei_t
counterfoil1655203counterfoi_l
counterfoils1755393counterfoils
countering13314473counter__ing
counterion1249533counterio_n_
counterions1349823counterio_ns
countermine1549743counter_mine
countermoving2154163countermoving
counterpane1549313counterp_ane
counterpart1547803counterp_art
counterplan1586773counterplan_
counterplans1687143counterplans
counterplot1596813counterp_lot
counterpointing2063033counterpointing
counterpoised1855303counterpoised
counterpoises1756413counterpoises
counterpoising19164193counterpoising
counterpose1547503counterpo_se
counterposed1756323counterposed
counterposes1647623counterposes
counterpower1965863counterpower
countersink1748063counter_sink
countersuing1547083countersuing
countersuit13137503countersui_t
interpoint12411883__interpoint
chuntering1647804chunter__ing
cointerring1447144cointer_ring
colorpoint1455634co__lorpoint
counteract1449604counter__act
counteracting1856284counteracting
counteragents1655174counteragents
counterbid1546084counter_bi_d
counterbids1646034counter_bids
counterblast1655404counterblast
countercoup1774494counterco_up
countercoups1854604countercoups
countercries1648994countercries
counterfeits1756214counterfeits
counterfire1647004counter_fire
counterforce1985794counterforce
counterman1448554counter_man_
countermand1647124counter_mand
countermen1449294counter_men_
countermines1649154counter_mines
countermove1855854countermo_ve
countermoved2054994countermoved
countermoves1956014countermoves
counterpanes1649304counterpanes
counterparts1646714counterparts
counterpicket2355164counterpicket
counterplay18105604counterp_lay
counterplays1995604counterplays
counterplea1547034counterp_lea
counterpleas1655804counterpleas
counterplots16106234counterplots
counterplotting2062804counterplotting
counterploy18105204counterp_loy
counterploys1995354counterploys
counterpowers2064824counterpowers
counterproject2763194counterproject
counterprotest1864434counterprotest
counterpunch2154194counterpunch
counterraid1446754counterrai_d
counterraids1556604counterraids
countershot1656634counter_shot
countersign1447244counter_sign
countersigns1546424countersigns
countersinks1846164counter_sinks
counterspies1648314counterspies
counterstain14156784counterstain_
counterstains15156624counterstains
countersuits14126594countersuits
countersunk1755264counter_sunk
countertop1445844counterto__p
countertops1546354counterto_ps
countertrend1575944countertrend
countervail1655654countervai_l
countervails1755994countervails
counterview19116684counter_view
counterweight2263544counterweight
counterworld1854224counterworld
outpoint10311514_ou_t__point
pourpoint1345214pou___rpoint

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 Filter1786911247900.530337152.8
2DLD Change Limit124790897.26617174.5
3Display Results89890.0631412.7
 (SQL Overall)178691897.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.