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

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

108 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
countersinks184616(None) 
countersink1748061countersink_
countermines1649152countermines
countersigns1546422countersigns
countersunk1755262countersunk_
counterbids1646033counterbi_ds
counterfires1747063counterfires
countering13314473counter_in_g
counterions1349823counter_ions
countermands1746233countermands
countermine1549743countermin_e
counterpanes1649303counterpanes
counterpoints1755623counterpoints
countershots1755933countershots
countersign1447243countersi_gn
countersigned1784353countersigned
countersinking2163483countersinking
counterspies1648313counterspies
counterstains15156623counterstain_s
countersteps1655883countersteps
countersues1348533counters_ues
countersuing1547083countersuin_g
countersuits14126593countersuits
counterviews20134873counterviews
centerings13247664c_enter_ings
centerlines1346994c_enterlines
chuntering1647804chunter_in_g
cointerring1447144cointerrin_g
concertinas15107554co_ncertinas
concertinos15158124co_ncertinos
conterminous1653284co_nterminous
conversing16310544co_nversin_g
conversions1648274co_nversions
counselings1442714counse_lings
counsellings1552114counsellings
counteracts1547514counter_acts
counteragents1655174counteragents
counterbid1546084counterbi__d
counterblows1954214counterblows
counterchecks2353324counterchecks
countercoups1854604countercoups
countercries1648994countercries
counterfeits1756214counterfeits
counterfire1647004counterfi_re
counterflows2054354counterflows
counterfoils1755394counterfoils
counterion1249534counter_i_on
counterman1448554counterman__
countermand1647124counterman_d
countermemos1854434countermemos
countermen1449294countermen__
countermoves1956014countermoves
countermyths2253554countermyths
counterpane1549314counterpan_e
counterparts1646714counterparts
counterpicket2355164counterpicket
counterpickets2463314counterpickets
counterplans1687144counterplans
counterplays1995604counterplays
counterpleas1655804counterpleas
counterplots16106234counterplots
counterploys1995354counterploys
counterpoint1658174counterpoin_t
counterpoises1756414counterpoises
counterposes1647624counterposes
counterposing1885444counterposin_g
counterpunch2154194counterpunch
counterraids1556604counterraids
counters103320194counter____s
countershadings2272704countershadings
countershot1656634counters_hot
countersigning1863224countersigning
countersniper17104554countersniper
countersnipers1893274countersnipers
counterspell1653914counterspell
counterspells1753464counterspells
counterspy1744664counters__py
counterstain14156784counterstain
counterstained1754844counterstained
counterstate1457034counterstate
counterstates1586644counterstates
counterstep1547114counters_tep
counterstrike1965294counterstrike
counterstrikes2094744counterstrikes
counterstroke1954784counterstroke
counterstrokes2064624counterstrokes
counterstyle1755054counterstyle
counterstyles1854784counterstyles
countersue1247744counters__ue
countersued1447074counters_ued
countersuit13137504counters_uit
countertenor1454754countertenor
countertenors1554064countertenors
countertops1546354counter_tops
countertrends1674354countertrends
countervails1755994countervails
counterview19116684countervi_ew
countess103710054counte_s___s
countesses1248844counte_s_ses
countries11313614count_r_i_es
countrysides1852054countrysides
coursings12235874cou___rsings
courtesans1244254courte_san_s
courtesies1246454courte_si_es
coversines15128634co__versines
interlinks14137504__interlinks
mountebanks1951574mounte_banks
outdrinks1443684_ou_tdr_inks

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.373479064.3
2DLD Change Limit1247901087.03317743.5
3Display Results1081080.0601800.0
 (SQL Overall)1786911087.46623934.0
 
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.