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

107 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
counterchanges2212422(None) 
counterchange2194861counterchange_
counterchanged23103771counterchanged
countercharges22104111countercharges
countercharge2194292countercharge_
countercharged23113612countercharged
counterchanging24162973counterchanging
counterimages1854613counterima_ges
counterpanes1649303counter_pan_es
interchanges1894263__interchanges
countenances1655734counte__nances
counterargues1685044counter__argues
counterbalances21122824counterbalances
countercharging24183064countercharging
counterchecked2562644counterchecked
counterchecks2353324counterch_ecks
counterclaimed2163524counterclaimed
counterclaims1954444countercla_ims
countercries1648994counterc__ries
counterimage1754984counterima_ge_
countermanded1974684counter_manded
countermands1746234counter_man_ds
countermines1649154counter_min_es
counterpane1549314counter_pan_e_
counterplans1687144counterplan__s
countershadings2272704countershading_s
counterstates1586644countersta_tes
countertrades1655894countertra_des
interchange17104584__interchange_
interchanged19103444__interchanged
interchanger1883464__interchanger
interchangers1972644__interchangers
undercharges1963634__undercharges
contredanses1552885co_nt_redanses
contrivances1954135co_nt_rivances
conversances1975725co_nver_sances
countenance1555875counte__nance_
countenanced1754205counte__nanced
countenancer1654225counte__nancer
countenancers1752985counte__nancers
counteracted1747365counter__acted
counteracting1856285counteracting__
counteracts1547515counter__a_cts
counteragent1557695counter__a_gent
counteragents1655175counteragen_ts
counterargue1555305counter__argue
counterargued1754225counter__argued
counterbalance20123245counterbalance_
counterbalanced22142575counterbalanced
counterblasts1754005counterbla_sts
countercheck2254115counterch__eck
counterclaim1854755countercla__im
countercoups1854605counterc__oups
countercultures1962235countercultures
counterdemands2062395counterdeman_ds
counterexamples28251535counterexamples
counterfires1747065counter__fires
counterforces2085555counter_forces
countering13314475counter__ing__
counterions1349825counter_ion__s
counterman1448555counter_man___
countermand1647125counter_man__d
countermarches2373745countermarches
countermeasures19122295countermeasures
countermine1549745counter_min_e_
countermoves1956015counter__moves
counterparts1646715counter_pa_rts
counterplan1586775counterplan___
counterplayer2055045counterpla_yer
counterplayers2153805counterplayers
counterplays1995605counterpla__ys
counterpointed1953595counterpointed
counterpoints1755625counterpoin_ts
counterpoises1756415counter_poises
counterposes1647625counter__poses
counterpunches2383245counterpunches
counterraids1556605counter_ra_ids
counterrallies1683955counterrallies
countershading2163835countershading
countershots1755935countersh__ots
countersigned1784355countersign_ed
countersigns1546425counter__signs
countersinks1846165counter_sin_ks
counterspies1648315counter__spies
counterstained1754845counterstained
counterstains15156625countersta_ins
counterstate1457035countersta_te_
counterstated1665635countersta_ted
counterstrikes2094745counterstrikes
counterstrokes2064625counterstrokes
counterstyles1854785counter_styles
countersues1348535counter___sues
countersuing1547085countersuing__
countertenors1554065counter_tenors
counterthreats1962875counterthreats
counterthrusts1982465counterthrusts
countertrade1556295countertra_de_
countertrends1674355countertren_ds
countervailed19154895counter_vailed
countervails1755995counter_va_ils
interchannel1752535__interchannel
outcharges1644835_ou_t__charges
outranges102510015_ou_t_r__anges
overcharges2044515_o__vercharges
supercharges20114535_su_percharges
undercharge1863865__undercharge_
undercharged2073505__undercharged

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 Filter178691950240.360496363.9
2DLD Change Limit950241076.57614450.1
3Display Results1071070.0801337.5
 (SQL Overall)1786911077.01625469.1
 
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.