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

97 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
countersteps165588(None) 
counterstep1547111counterstep_
countersues1348532countersue_s
countertops1546352counter_tops
contesters12410183co_nte_sters
countercoups1854603countercoups
counterpleas1655803counterpleas
countershots1755933countershots
countersigns1546423countersigns
countersinks1846163countersinks
counterspell1653913counterspell
counterspells1753463counterspells
counterspies1648313counterspies
counterspy1744663counters__py
counterstain14156783counterstain
counterstains15156623counterstains
counterstate1457033counterstate
counterstates1586643counterstates
counterstream1773733counterstream
counterstreams18102803counterstreams
counterstyle1755053counterstyle
counterstyles1854783counterstyles
countersue1247743countersue__
countersued1447073countersue_d
countersuits14126593countersuits
countertop1445843counter_top_
counterviews20134873counterviews
countesses1248843counte_sse_s
contested12310694co_nte_ste_d
contester11311184co_nte_ste_r
contests103413384co_nte_st__s
contretemps1751774co_nt_retemps
conversers1547354co_nvers_ers
converses14311164co_nvers_e_s
converters1539634co_nver_ters
counteracted1747364counteracte_d
counteracts1547514counter_acts
counteragent1557694counteragent
counteragents1655174counteragents
counterbids1646034counter_bids
counterblows1954214counterblows
countercheck2254114countercheck
counterchecks2353324counterchecks
countercoup1774494countercoup_
countercries1648994countercries
countered12313004counter__e_d
counterfeit1657734counter_feit
counterfeiters19103744counterfeiters
counterfeits1756214counterfeits
counterfires1747064counterfires
counterflows2054354counterflows
counterfoils1755394counterfoils
counterions1349824counter_ions
countermands1746234countermands
countermemo1754724counter_memo
countermemos1854434countermemos
countermen1449294counter_me_n
countermines1649154countermines
countermoves1956014countermoves
countermyths2253554countermyths
counteroffers2153264counteroffers
counterorders1654474counterorders
counterpanes1649304counterpanes
counterparts1646714counterparts
counterplans1687144counterplans
counterplays1995604counterplays
counterplea1547034counterple_a
counterplots16106234counterplots
counterploys1995354counterploys
counterposes1647624counterposes
counterpowers2064824counterpowers
counterraids1556604counterraids
counters103320194counter____s
countershot1656634counters_hot
countersign1447244counters_ign
countersink1748064counters_ink
countersniper17104554countersniper
countersnipers1893274countersnipers
counterstated1665634counterstated
counterstrike1965294counterstrike
counterstrikes2094744counterstrikes
counterstroke1954784counterstroke
counterstrokes2064624counterstrokes
counterstruck2163194counterstruck
countersuing1547084countersuing
countersuit13137504counters_uit
countersunk1755264counters_unk
countertenor1454754counter_tenor
countertenors1554064counter_tenors
countertrend1575944countertrend
countertrends1674354countertrends
countervails1755994countervails
counterview19116684countervie_w
countess103710054counte_s___s
countries11313614count_r_ie_s
courtesies1246454courte_sie_s
oversteps1436304_o__versteps

Search took 8 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 Filter1786911247900.1561145455.1
2DLD Change Limit124790976.92318025.4
3Display Results97970.0462108.7
 (SQL Overall)178691977.12525079.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.