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

98 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
counterexamples2825153(None) 
counterexample27151721counterexample_
counterargues1685045counter__argues
counterchanges22124225countercha_nges
countercharges22104115countercha_rges
counterimages1854615counter__images
countermarches2373745counter_marches
countermeasures19122295countermeasures
countermines1649155counter___mines
countermoves1956015counter___moves
counterpanes1649305counter_pa__nes
counterplea1547035counter____plea
counterpleas1655805counter____pleas
counterrallies1683955counter_rallies
counterspies1648315counter___spies
counterstates1586645countersta__tes
counterstyles1854785counter__styles
countertrades1655895countertra__des
countervailed19154895counter_va_iled
countervails1755995counter_va_il_s
chanterelles1751906chantere___lles
contredanses1552886co_nt_reda_nses
contretemps1751776co_nt_retemp__s
countenances1655736count__ena_nces
counteracted1747366counter__a_cted
counteracts1547516counter__a__cts
counteragents1655176counter__agents
counterargue1555306counter__argue_
counterargued1754226counter__argued
counterassaults1791446counterassaults
counterbalances21122826counterbalances
counterblasts1754006counterbla__sts
countercampaign2471676counter_campaign
counterchange2194866countercha_nge_
counterchanged23103776countercha_nged
countercharge2194296countercha_rge_
countercharged23113616countercha_rged
counterclaimed2163526countercla_imed
counterclaims1954446countercla__ims
countercoups1854606counter_coup__s
countercries1648996counter___cries
countercultures1962236countercultures
counterdemands2062396counter_demands
counterefforts2282056countere_fforts
counterfires1747066counter___fires
counterfoils1755396counter__foil_s
counterforces2085556counter__forces
counterimage1754986counter__image_
countermanded1974686counter_ma_nded
countermands1746236counter___mands
countermarched2483186counter_marched
countermeasure18122636countermeasure_
countermelodies2092166countermelodies
countermemos1854436counter___memos
countermen1449296counter___m__en
countermine1549746counter___mine_
countermove1855856counter___move_
countermoved2054996counter___moved
countermyths2253556counter___myths
counterpane1549316counter_pa__ne_
counterparts1646716counter_pa__rts
counterplan1586776counter____plan
counterplans1687146counter____plans
counterplay18105606counter____play
counterplayer2055046counterpla__yer
counterplayers2153806counterpla_yers
counterplays1995606counter____plays
counterplot1596816counter____plot
counterplots16106236counter____plots
counterploy18105206counter____ploy
counterploys1995356counter____ploys
counterpoises1756416counter__poises
counterpose1547506counter____pose
counterposes1647626counter___poses
counterpunches2383246counter_punches
counterraids1556606counter_ra__ids
counterrallied1763256counter_rallied
counterrally1755526counter_ra__lly
countershadings2272706countershadings
countersniper17104556counter_snip_er
countersnipers1893276counter_snipers
counterspell1653916counter___spell
counterspells1753466counter__spells
counterstained1754846countersta_ined
counterstains15156626countersta__ins
counterstate1457036countersta__te_
counterstated1665636countersta__ted
countersteps1655886counter_step__s
counterstrikes2094746counter_strikes
counterstrokes2064626counter_strokes
counterstyle1755056counter__style_
countersues1348536counter____sues
countertactics1763366counter_tactics
countertops1546356counter__top__s
countertrade1556296countertra__de_
countervail1655656counter_va_il__
counterworlds1953466counter__worlds
unexampled2241696__un___exampled

Search took 9 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.343520965.0
2DLD Change Limit95024988.20311584.1
3Display Results98980.0631555.6
 (SQL Overall)178691988.60920756.3
 
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.