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

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

124 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
counterstrikes209474(None) 
counterstrike1965291counterstrike_
counterstrokes2064621counterstrokes
counterstricken2372742counterstricken
counterstroke1954782counterstroke_
countercries1648993counter_cri_es
counterspies1648313counters_pi_es
counterstained1754843counterstained
counterstains15156623counterstai_ns
counterstates1586643counterst_ates
counterstreams18102803counterstreams
counterstriking2262943counterstriking
counterstyles1854783counterst_yles
countertrades1655893counter_trades
thunderstrikes2261743thunderstrikes
counterargues1685044counter_argues
counterfires1747064counter__fires
counterforces2085554counterfor_ces
countermarches2373744countermarches
countermines1649154counter__mines
counterpoises1756414counter_poises
countersigns1546424counters__igns
countersinks1846164counters__inks
countersniper17104554counters_niper
countersnipers1893274counters_nipers
counterstain14156784counterstai__n
counterstate1457034counterst_ate_
counterstated1665634counterst_ated
counterstep1547114counterst___ep
countersteps1655884counterst__eps
counterstrategy2182134counterstrategy
counterstream1773734counterstr_eam
counterstruck2163194counterstr_uck
counterstyle1755054counterst_yle_
countersues1348534counters___ues
countersuits14126594counters_ui_ts
countertrade1556294counter_trade_
countertrends1674354counter_trends
superstrikes1855864_su_perstrikes
thunderstrike2161894thunderstrike_
thunderstrokes2271734thunderstrokes
concertizes24158585co_ncer_t_izes
contemporizes2853205co_ntemporizes
contraries12711935co_nt_r_ari_es
cornerstones1452875corn_erst_ones
counteractions1855025counteractions
counteractive2055955counteractive_
counterargue1555305counter_argue_
counterargued1754225counter_argued
counterattacked2471955counterattacked
counterattacker2371795counterattacker
counterattacks2272255counterattacks
counterbids1646035counter__bi_ds
counterchanges22124225counterchanges
countercharges22104115countercharges
counterchecked2562645counterchecked
counterchecks2353325countercheck_s
counterclaimed2163525counterclaimed
counterclaims1954445counterclai_ms
counterfeited1974775counter_feited
counterfeiter1874745counter_feiter
counterfeiters19103745counter_feiters
counterfeits1756215counter_fei_ts
counterfire1647005counter__fire_
counterfoils1755395counter_foi_ls
counterforce1985795counterfor_ce_
counterimages1854615counter_images
counterions1349825counte___rions
countermarched2483185countermarched
countermine1549745counter__mine_
countermoves1956015counter__moves
counterorder1555615counter_or_der
counterorders1654475counter_orders
counterpanes1649305counter__panes
counterparts1646715counterpar__ts
counterpicket2355165counter_picket
counterpickets2463315counter_pickets
counterpoints1755625counter_points
counterpoise1657355counter_poise_
counterpoised1855305counter_poised
counterposes1647625counter__poses
counterprotest1864435counter_protest
counterpunches2383245counterpunches
counterraids1556605counter__raids
counterrallies1683955counterrallies
countershadings2272705countershadings
countershots1755935counters__hots
countersign1447245counters__i_gn
countersigned1784355counters_igned
countersink1748065counters__i_nk
countersinking2163485countersinking
counterspells1753465counters_pells
counterstaining1863245counterstaining
counterstating1755195counterstating
countersue1247745counters___ue_
countersued1447075counters___ued
countersuing1547085counters_ui_ng
countersuit13137505counters_ui__t
countersunk1755265counters_unk__
countertenors1554065counter_tenors
counterterrors1662485counterterrors
counterthreats1962875counterthreats
counterthrusts1982465counterthrusts
countertops1546355counter_t__ops
countertrend1575945counter_tr_end
countervailed19154895counter_vailed
countervails1755995counter_vai_ls
counterview19116685counter__vi_ew
counterviews20134875counter__views
counterworlds1953465counterwor_lds
countesses1248845counte_s___ses
countries11313615coun____tri_es
countrysides1852055count_r_ysides
courtesies1246455courte_s__i_es
interstices1348525__interst_ices
masterstrokes1961185_masterstrokes
outstrides1154745_ou_t__strides
outstrives1374255_ou_t__strives
outstrokes1464585_ou_t__strokes
overstrides1545875_o__verstrides
superstrike1755765_su_perstrike_
thunderstricken2581305thunderstricken
thunderstroke2161915thunderstroke_
understories1365565__understori_es

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.343520965.0
2DLD Change Limit950241246.09315595.6
3Display Results1241240.0761631.6
 (SQL Overall)1786911246.51227440.3
 
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.