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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
counterstates158664(None) 
counterstate1457031counterstate_
counterstated1665631counterstated
counterstains15156622counterstains
counterstyles1854782counterstyles
counterimages1854613counterimages
counterpanes1649303counter_panes
countershots1755933countershot_s
counterspies1648313counters_pies
counterstain14156783countersta_in
counterstained1754843counterstained
counterstating1755193counterstating
counterstep1547113counters__tep
countersteps1655883counterst_eps
counterstrategy2182133counterstrategy
counterstrikes2094743counterstrikes
counterstrokes2064623counterstrokes
counterstyle1755053counterstyle_
countersues1348533counters__ues
countersuits14126593countersuit_s
countertrades1655893countertrades
interstates11710203__interstates
understates1247703__understates
condensates1445314co_ndens_ates
consternates1455054conster_nates
contemplates1855284co_ntemplates
contestants1356804co_nte_stants
cornerstones1452874corn_erstones
counteracted1747364counter_acted
counteracts1547514counter__acts
counterargues1685044counterargues
counterattack2172734counterattack
counterattacks2272254counterattacks
counterblasts1754004counterblasts
counterchanges22124224counterchanges
countercharges22104114countercharges
counterclaims1954444counterclaims
countercries1648994counter_cries
counterfeited1974774counterfeited
counterfeiter1874744counterfeiter
counterfeiters19103744counterfeiters
counterfeits1756214counterfeit_s
counterfires1747064counter_fires
counterforces2085554counterforces
counterimage1754984counterimage_
countermands1746234counter_mands
countermines1649154counter_mines
countermoves1956014counter_moves
countermyths2253554counter_myths
counterpane1549314counter_pane_
counterparts1646714counter_parts
counterplans1687144counterpla_ns
counterplayer2055044counterplayer
counterplayers2153804counterplayers
counterplays1995604counterpla_ys
counterplots16106234counterplot_s
counterpoises1756414counterpoises
counterposes1647624counter_poses
counterprotest1864434counterprotest
counterraids1556604counter_raids
countershot1656634countershot__
countersigned1784354countersigned
countersigns1546424counters_igns
countersinks1846164counters_inks
countersniper17104554countersniper
countersnipers1893274countersnipers
counterspells1753464counterspells
counterstream1773734counterstream
counterstreams18102804counterstreams
counterstrike1965294counterstrike
counterstroke1954784counterstroke
counterstruck2163194counterstruck
countersue1247744counters__ue_
countersued1447074counters__ued
countersuit13137504countersuit__
countertactic1663914counter_tactic
countertactics1763364counter_tactics
countertops1546354counter_t_ops
countertrade1556294countertrade_
countervails1755994counter_vails
countesses1248844counte_s__ses
countryseats1751484countryseat_s
interstate10710974__interstate_
intestates10159434__inte_states
outstates91710754_ou_t__states
overstates131110114_o__verstates
superstates1349554_su_perstates
understate1148864__understate_
understated1347834__understated

Search took 7 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.1261418182.5
2DLD Change Limit95024895.87316179.8
3Display Results89890.0631412.7
 (SQL Overall)178691896.06229477.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.