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 “counterprojects” with Change Limit: [1] [2] [3] [4] [5] [6]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
counterprojects286215(None) 
counterproject2763191counterproject_
counterprotests1962422counterprotests
counterprotest1864433counterprotest_
counterpickets2463314counterpicke_ts
counterplots16106234counterplo___ts
counterpoints1755624counterp_o_ints
counterposes1647624counterp_ose__s
counterpowers2064824counterp_owe_rs
counteracts1547515counte__r__acts
counteragents1655175counte__ragents
counterargues1685045counterargue__s
counterchecks2353325counte__rchecks
countercries1648995countercr_ie__s
countercurrents1962335countercurrents
counterfeits1756215counte__r_feits
counterforces2085555counter_fo_rces
countermoves1956015counter_move__s
counterorders1654475counteror_de_rs
counterpanes1649305counterp_ane__s
counterparts1646715counterp___arts
counterpicket2355165counterpicke_t_
counterplayers2153805counterplaye_rs
counterpleas1655805counterp__le_as
counterplot1596815counterplo___t_
counterploys1995355counterplo___ys
counterpoint1658175counterp_o_int_
counterpoises1756415counterp_o_ises
counterpose1547505counterp_ose___
counterposed1756325counterp_ose__d
counterpower1965865counterp_owe__r
counterproposal21101335counterproposal
countershots1755935countersho___ts
counterstrokes2064635counterstroke__s
counterthreats1962875counter_threats
countertrades1655895countertrade__s
countertrends1674355countertr__ends
overprotects1953035_o__verprotects
centerpieces1852546c_enterp__ieces
controverts1654286co_nt___roverts
counteract1449606counte__r__act_
counteragent1557696counte__ragent_
counterargue1555306counterargue___
counterargued1754226counterargue__d
counterargument2072026counterargument_
counterassaults1791446counterassaults
counterattacks2272256counter_attacks
counterbalances21122826counterbalances
counterblasts1754006counte__rblasts
counterblows1954216counterblo___ws
countercheck2254116counte__rchec_k
countercoups1854606counter_co__ups
countercurrent1863466countercurrent_
counterefforts2282056counter_efforts
counterfeit1657736counte__r_feit_
counterfeiters19103746counterfeite_rs
counterfires1747066counter_fire__s
counterflows2054356counterflo___ws
counterfoils1755406counter_fo__ils
counterforce1985796counter_fo_rc_e
counterimages1854616counterimage__s
counterions1349846counter_io___ns
countermarches2373746countermarche__s
countermemos1854436counte__r_memos
countermines1649156counter_mine__s
countermove1855856counter_move___
countermoved2054996counter_move__d
counteroffers2153266counte__roffers
counterorder1555626counteror_de__r
counterordered1862536counteror_dered
counterpane1549316counterp_ane___
counterpart1547806counterp___art_
counterpicketed2671626counterpicketed
counterplans1687146counterp___lans
counterplayer2055046counterplaye__r
counterplays1995606counterp___lays
counterplea1547036counterp__le__a
counterplotted1963416counterplo_tted
counterplotting2062806counterplotting
counterploy18105206counterplo____y
counterpointed1953596counterp_ointed
counterpoise1657376counterp_o__ise
counterpoised1855306counterp_o_ised
counterpoising19164196counterp_oising
counterposing1885446counterp_o_sing
counterpressure1971516counterpressure
counterpunch2154196counterp__unc_h
counterpunchers2482016counterpunchers
counterpunches2383246counterp_unches
counterraids1556616counter_r__aids
counterrallies1683956counter_rallies
counterreforms2162176counter_reforms
countershot1656636countersho___t_
countersnipers1893276countersnipe_rs
counterspells1753466counte__rspells
counterspies1648316counter_spie__s
counterstates1586646counterstate__s
countersteps1655886counte__rste_ps
counterstreams18102806counter_streams
counterstrikes2094746counterstrike__s
counterstroke1954786counterstroke___
counterstyles1854786counterstyle__s
countersues1348536counte__rsue__s
countersuits14126596counte__r_suits
countertactics1763366countertactic_s
counterthreat1854056counter_threat_
counterthrusts1982466counter_thrusts
countertops1546356counter_to___ps
countertrade1556296countertrade___
countertrend1575946countertr__e_nd
counterviews20134876counte__rvie_ws
counterviolence2271566counterviolence
counterweights2372536counter_weights
counterworlds1953466counter_wo_rlds
countryseats1751486count___ryseats
interjects1947536__inte__r_jects
interprets1249336__interpr__e_ts
introjects1953706__int___rojects
outreproduces1861426_ou_treproduces
overprotect1854576_o__verprotect_
reinterprets1452176reinterpr__e_ts
subprojects2451626_su___bprojects

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.376475242.0
2DLD Change Limit950241228.50011179.3
3Display Results1221220.0931311.8
 (SQL Overall)1786911228.96919923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.