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

88 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
counterpunches238324(None) 
counterpunched2492711counterpunched
counterpuncher2382631counterpuncher
counterpunchers2482011counterpunchers
counterpunch2154192counterpunch__
countermarches2373743countermarches
counterpanes1649303counterpan__es
counterpunching2562363counterpunching
countenances1655734counte_nanc_es
counterforces2085554counterforc_es
countermarched2483184countermarched
countermines1649154countermin__es
counterpane1549314counterpan__e_
counterpicket2355164counterp_icket
counterpickets2463314counterp_ickets
counterpoises1756414counterp_oises
counterposes1647624counterp__oses
countersues1348534countersu___es
outpunches1742824_ou_t__punches
centerpieces1852545c_enterpiec_es
conferences1898815co_nfer_enc_es
conferrences19106075co_nferrenc_es
conservancies2054105co_nservancies
convergences20146255co_nvergenc_es
convergencies21143905co_nvergencies
conversances1975715co_nversanc_es
conversancies2053595co_nversancies
countenance1555875counte_nanc_e_
countenanced1754205counte_nanc_ed
countenancer1654225counte_nanc_er
countenancers1752985counte_nancers
counteracted1747365counter__acted
counteracts1547515counter__ac_ts
counterargues1685045counter_argues
counterbalances21122825counterbalanc_es
counterchanges22124225counterchanges
countercharges22104115countercharges
countercheck2254115counter___check
counterchecked2562645counterchecked
counterchecks2353325counterchec_ks
countercries1648995counter__cries
countercultures1962235countercultures
counterfires1747065counter__fires
counterforce1985795counterforc_e_
counterimages1854615counter_images
counterions1349825counterion___s
countermanded1974685counterman_ded
countermands1746235counterman__ds
countermarch2154465countermarch__
countermine1549745countermin__e_
countermoves1956015counter__moves
countermyths2253555counter_myth_s
counterparts1646715counterp__arts
counterplans1687145counterp__lans
counterplayer2055045counterp_layer
counterplayers2153805counterplayers
counterplays1995605counterp__lays
counterplea1547035counterp___lea
counterpleas1655805counterp__leas
counterplots16106235counterp__lots
counterplotted1963415counterplotted
counterploys1995355counterp__loys
counterpointed1953595counterpointed
counterpoints1755625counterp_oints
counterpoise1657355counterp_oise_
counterpoised1855305counterp_oised
counterpose1547505counterp__ose_
counterposed1756325counterp__osed
counterpower1965865counterp__ower
counterpowers2064825counterp_owers
counterprotest1864435counterp_rotest
counterrallies1683955counterrallies
countersinks1846165countersin__ks
countersniper17104555counter_sniper
countersnipers1893275counter_snipers
counterspies1648315counter__spies
counterstates1586645counter_states
counterstrikes2094745counterstrikes
counterstrokes2064625counterstrokes
counterstyles1854785counter_styles
countersue1247745countersu___e_
countersued1447075countersu___ed
countersuits14126595countersu__its
countersunk1755265countersun___k
countertenors1554065counterten_ors
countertrades1655895counter_trades
counterweights2372535counterweights
outpunched1842775_ou_t__punched

Search took 11 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.720248181.9
2DLD Change Limit95024889.5809919.0
3Display Results88880.0601466.7
 (SQL Overall)1786918810.36017248.2
 
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.