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

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

86 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
counterchanged2310377(None) 
counterchange2194861counterchange_
counterchanges22124221counterchanges
countercharged23113611countercharged
countercharge2194292countercharge_
countercharges22104112countercharges
counterchanging24162973counterchanging
counterchecked2562643counterchecked
counterclaimed2163523counterclaimed
countermanded1974683counter_manded
interchanged19103443__interchanged
countenanced1754204counte__nanced
counteracted1747364counter__acted
counterargued1754224counter__argued
counterbalanced22142574counterbalanced
countercharging24183064countercharging
counterimage1754984counterima_ge_
counterimages1854614counterima_ges
countermand1647124counter_man__d
counterpane1549314counter_pan_e_
counterpanes1649304counter_pan_es
counterpointed1953594counterpointed
countersigned1784354countersign_ed
counterstained1754844counterstained
counterstated1665634countersta_ted
countervailed19154894counter_vailed
interchange17104584__interchange_
interchanger1883464__interchanger
interchanges1894264__interchanges
undercharged2073504__undercharged
countenance1555875counte__nance_
countenancer1654225counte__nancer
countenances1655735counte__nances
counteracting1856285counteracting__
counteragent1557695counter__a_gent
counterargue1555305counter__argue
counterargues1685045counter__argues
counterattacked2471955counterattacked
counterbalance20123245counterbalance_
counterbalances21122825counterbalances
countercheck2254115counterch__eck
counterchecks2353325counterch_ecks
counterclaim1854755countercla__im
counterclaims1954445countercla_ims
countercries1648995counterc__ries
counterdemand1963215counterdeman__d
countered12313005counter_____ed
counterfeited1974775counter_feited
countering13314475counter__ing__
counterman1448555counter_man___
countermands1746235counter_man_ds
countermarched2483185countermarched
countermine1549745counter_min_e_
countermines1649155counter_min_es
countermoved2054995counter__moved
counterordered1862535counterordered
counterplan1586775counterplan___
counterplans1687145counterplan__s
counterplayer2055045counterpla_yer
counterplotted1963415counterplotted
counterpoised1855305counter_poised
counterposed1756325counter__posed
counterpunched2492715counterpunched
counterraid1446755counter_ra__id
counterrallied1763255counterrallied
countershading2163835countershading
countershadings2272705countershading_s
counterstate1457035countersta_te_
counterstates1586645countersta_tes
countersued1447075counter___sued
countersuing1547085countersuing__
countertrade1556295countertra_de_
countertrades1655895countertra_des
countertrend1575945countertren__d
interchangers1972645__interchangers
interchannel1752535__interchannel
mountebanked2181595mounte__banked
outcharged1744215_ou_t__charged
outranged11239045_ou_t_r__anged
overcharged2144415_o__vercharged
supercharged21113295_su_percharged
unchanged1636285__un___changed
undercharge1863865__undercharge_
undercharges1963635__undercharges
underhanded1744665__under_handed
unenchanted1752455__un_enchanted

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 Limit95024866.42014801.2
3Display Results86860.0631365.1
 (SQL Overall)178691866.82626178.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.