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 “counterevidence” 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
counterevidence239158(None) 
counterviolence2271563counter_violence
countertendency2371924countertendency
counterbalance20123245counter_balance
counterinstance19101795counterinstance
countermine1549745counter_mi__n_e
counterview19116685counter_vi_e__w
counterviews20134875counter_vi_e_ws
nonevidence1754085no_n___evidence
nonresidence1554145no_n__residence
antecedence1652916__antece__dence
centerpiece1762516c_enter_pi_e_ce
codependence2063596co__depe_ndence
coincidence1583606coin____cidence
concrescence1484506co_n_cre_scence
condescendence19132466co_ndescendence
conference1799016co_nfer____ence
conferrence1896576co_nfer___rence
confidence1847066co_n____fidence
continence1489136co_nt____inence
contravene1545096co_nt_rav__en_e
contredanse1452756co_nt_re__danse
contrivance1854266co_nt_r__ivance
convenience1886446co_n__veni_ence
convergence19116546co_nver___gence
countenance1555876count__e__nance
counteragent1557696counter__agen_t
counteragents1655176counter__agents
counterbalanced22142576counter_balanced
counterbalances21122826counter_balances
counterbid1546096counter_bid____
counterbids1646046counter_bid___s
counterchange2194866counter__change
countercheck2254116counter__che_ck
countercries1648996countercri_e__s
countercurrent1863466countercurren_t
countercurrents1962336countercurrents
countered12313006countere__d____
counterexample27151726countere_xample
counterfeited1974776counterfeite__d
counterfeiter1874746counterfeite__r
counterfeiters19103746counterfeite_rs
counterfeiting2054026counterfeitin_g
counterfire1647006counter_fi___re
counterfires1747066counter_fire__s
counterforce1985796counter___force
counterimage1754986counter__i_mage
countering13314476counter__i__n_g
counterion1249536counter__i_on__
counterions1349836counter__i_on_s
countermanded1974686countermande__d
countermanding2053746countermandin_g
countermen1449296counter___men__
countermines1649156counter_mi__nes
countermovement2471816countermovemen_t
countermoving2154166countermovi__n_g
counterorder1555626counter_orde__r
counterordered1862536counter_ordered
counterorders1654476counter_orde_rs
counterpane1549316counter___pan_e
counterpoint1658176counterpoi__n_t
counterpointed1953596counterpoi__nted
counterpoints1755626counterpoi__nts
counterpoise1657366counterpoi___se
counterpoised1855306counterpoise__d
counterpoises1756416counterpoise__s
counterpoising19164196counterpoisin_g
counterproject2763196counterproje_ct
counterpunch2154196counter___punch
counterraid1446756counterraid____
counterraids1556616counterraid___s
counterresponse1961766counterresponse
countershading2163836countershadin_g
countershadings2272706countershadings
countersign1447246counter_si_gn__
countersigned1784356counter_si_gned
countersigns1546426counter_si_gn_s
countersink1748066counter_si__n_k
countersinks1846166counter_si__nks
countersniper17104556countersnipe__r
countersnipers1893276countersnipe_rs
counterspies1648316counterspi_e__s
countersuing1547086countersui__n_g
countertenor1454756counter___tenor
countertrade1556296countertrad___e
countertrades1655896countertrade__s
countertrend1575946counter__tren_d
countertrends1674356counter__trends
countervailed19154896countervaile__d
countervailing2063736countervailin_g
countryside1752366count_rysid___e
countrysides1852056count_ryside__s
countrywide2051806count_rywid___e
nonevidences1853806no_n___evidences
nonresidences1663766no_n__residences
nonresidency1862806no_n__residency
subservience1962156_subser_vi_ence
supereminence1962686_su_pereminence

Search took 10 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.390458182.1
2DLD Change Limit95024989.23310291.8
3Display Results98980.0631555.6
 (SQL Overall)178691989.68618448.4
 
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.