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

54 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
counterpuncher238263(None) 
counterpunched2492711counterpunched
counterpunchers2482011counterpunchers
counterpunches2383241counterpunches
counterpunch2154192counterpunch__
counterpunching2562363counterpunching
countenancer1654224counte_nanc_er
countermarched2483184countermarched
countermarches2373744countermarches
counterpane1549314counterpan__e_
counterpanes1649304counterpan__es
counterpicket2355164counterp_icket
counterplayer2055044counterp_layer
counterpower1965864counterp__ower
countersniper17104554counter_sniper
countenance1555875counte_nanc_e_
countenanced1754205counte_nanc_ed
countenancers1752985counte_nanc_ers
countenances1655735counte_nanc_es
counteracted1747365counter__acted
counterattacker2371795counterattacker
countercheck2254115counter___check
counterchecked2562645counterchecked
counterculture1862325counterculture
counterfeiter1874745counter_feiter
counterforce1985795counterforc_e_
counterforces2085555counterforc_es
countermanded1974685counterman_ded
countermarch2154465countermarch__
countermine1549745countermin__e_
countermines1649155countermin__es
counteroffer2054115counter__offer
counterorder1555615counter__order
counterpickets2463315counterp_ickets
counterplayers2153805counterp_layers
counterplea1547035counterp___lea
counterplotted1963415counterplotted
counterpointed1953595counterpointed
counterpoise1657355counterp_oise_
counterpoised1855305counterp_oised
counterpoises1756415counterp_oises
counterpose1547505counterp__ose_
counterposed1756325counterp__osed
counterposes1647625counterp__oses
counterpowers2064825counterp__owers
countersnipers1893275counter_snipers
countersue1247745countersu___e_
countersued1447075countersu___ed
countersues1348535countersu___es
countersunk1755265countersun___k
countertenor1454755counterten__or
cowpuncher2251235co____wpuncher
outpunched1842775_ou_t__punched
outpunches1742825_ou_t__punches

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.360496363.9
2DLD Change Limit95024547.09313396.9
3Display Results54540.0331636.4
 (SQL Overall)178691547.48623870.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.