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

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

146 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
counterprotests1962421counterprotests_
counterprotest1864432counterprotest__
counterprojects2862153counterprojects_
counterproject2763194counterproject__
counterpickets2463315counterpicke_ts_
counterplots16106235counterplo___ts_
counterplotted1963415counterplot__ted
counterpoints1755625counterp_o_ints_
counterpoises1756415counterp_o_ises_
counterposes1647625counterp_o__ses_
counterpowers2064825counterp_owe_rs_
counterproposal21101335counterpropos_al
counteragents1655176counte__ragents_
counterargues1685046counterargue__s_
counterblasts1754006counte__rblasts_
countercries1648996countercr_ie__s_
countercurrents1962336countercurrents_
counterfeiters19103746counterfeite_rs_
counterfeits1756216counte__r_feits_
counterforces2085556counterforce__s_
countermoves1956016counter_move__s_
counterorders1654476counteror_de_rs_
counterpanes1649306counterp_ane__s_
counterparts1646716counterp___arts_
counterpicket2355166counterpicke_t__
counterpicketed2671626counterpicke_ted
counterplayers2153806counterplaye_rs_
counterplea1547036counterp__le___a
counterpleas1655806counterp__le_as_
counterplot1596816counterplo___t__
counterplotting2062806counterplot_ting
counterploys1995356counterplo___ys_
counterpoint1658176counterp_o_int__
counterpointed1953596counterp_o_inted
counterpoise1657376counterp_o___ise
counterpoised1855306counterp_o_is_ed
counterpoising19164196counterp_o_ising
counterpose1547506counterp_o____se
counterposed1756326counterp_o__s_ed
counterposing1885446counterp_o__sing
counterpower1965866counterp_owe___r
counterpressure1971516counterpr_essure
countershots1755936countersho___ts_
counterstates1586646counterstate__s_
countersteps1655886counte__rste_ps_
counterstrokes2064636counterstroke__s_
counterthreats1962876counter_threats_
counterthrusts1982466counter_thrusts_
countertrades1655896countertrade__s_
countertrends1674356countertr__ends_
overprotects1953036_o__verprotects_
contemplates1855287co_ntemplate__s_
contortionists16103367co_ntortionists_
contrapuntists1871847co_ntrapuntists_
contrariness1455487co_nt_rarines_s_
controverts1654287co_nt___roverts_
counteracted1747367counter_acte___d
counteractions1855027counter_actions_
counteracts1547517counte__r__acts_
counteragent1557697counte__ragent__
counterargue1555307counterargue____
counterargued1754227counterargue___d
counterargument2072027counterargument__
counterassaults1791447counterassaults_
counterattacks2272257counter_attacks_
counterblast1655407counte__rblast__
counterblows1954217counterblo___ws_
counterchecks2353327counte__rchecks_
countercoups1854607counter_co__ups_
countercultures1962237countercultures_
countercurrent1863467countercurrent__
counterefforts2282057counter_efforts_
counterfeit1657737counte__r_feit__
counterfeited1974777counte__r_feited
counterfeiter1874747counte__r_feiter
counterfires1747067counter_fire__s_
counterflows2054357counterflo___ws_
counterfoils1755407counter_fo__ils_
counterforce1985797counterforce____
counterimages1854617counterimage__s_
counterions1349847counter_io___ns_
counterirritant1771737counterirritant__
countermarches2373747countermarche__s_
countermemos1854437counte__r_memos_
countermines1649157counter_mine__s_
countermove1855857counter_move____
countermoved2054997counter_move___d
countermovement2471817counter_movement
countermyths2253557counter_myt__hs_
counteroffers2153267counte__roffers_
counterorder1555627counteror_de___r
counterordered1862537counteror_de_red
counterordering19162417counteror_dering
counterpane1549317counterp_ane____
counterpart1547807counterp___art__
counterpetition1961947counterp_etition
counterplans1687147counterp___lans_
counterplayer2055047counterplaye___r
counterplays1995607counterp___lays_
counterploy18105207counterplo_____y
counterpointing2063037counterp_ointing
counterpunchers2482017counterpunchers_
counterpunches2383247counterp_unches_
counterquestion2671217counte__rquestion
counterraids1556617counter_r__aids_
counterrallies1683957counter_rallies_
counterreform2062587counter_r__eform
counterreforms2162177counter_reforms_
counterresponse1961767counter_response
countershot1656637countersho___t__
countersnipers1893277countersnipe_rs_
counterspells1753467counte__rspells_
counterspies1648317counter_spie__s_
counterstains15156627counte__rstains_
counterstate1457037counte__rst_at_e
counterstated1665647counte__rst_ated
counterstep1547117counte__r___step
counterstrategy2182137counterstrate__gy
counterstreams18102807counter_streams_
counterstrikes2094747counterstrike__s_
counterstroke1954787counterstroke____
counterstyles1854787counte__rstyles_
countersues1348537counte__rsue__s_
countersuits14126597counte__r_suits_
countertactic1663917counte__r_tactic
countertactics1763367countertact_ics_
countertenor1454757counte__r_te_nor
countertenors1554067counte__r_tenors
counterterror1562557counte__r_terror
counterthreat1854057counter_threat__
counterthrust1873607counte__r_thrust
countertops1546357counte__r_t_ops_
countertrade1556297countertrade____
countertrend1575947countertr__e__nd
counterviews20134877counte__rvie_ws_
counterviolence2271567counterviole_nce
counterweights2372537counter_weights_
counterworlds1953467counter_wo_rlds_
countryseats1751487count___ryseats_
ecoterrorists1561307eco__ter_rorists_
interpreters1456187__interprete_rs_
interprets1249337__interpr__e_ts_
overprocess1853957_o__verproces_s_
overprotect1854577_o__verprotect__
overprotected2162847_o__verprotected
reinterprets1452177reinterpr__e_ts_

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.406440125.6
2DLD Change Limit950241468.65610977.8
3Display Results1461460.1101327.3
 (SQL Overall)1786911469.17219482.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.