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

85 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
counterclaimed216352(None) 
counterclaim1854752counterclaim__
counterclaims1954442counterclaim_s
counterchanged23103773counterchanged
countercharged23113613countercharged
counterclaiming2262923counterclaiming
counterstained1754843counterstained
countervailed19154893counter_vailed
counteracted1747364counter__acted
counterbalanced22142574counterbalanced
counterchange2194864counterchange_
counterchanges22124224counterchanges
countercharge2194294countercharge_
countercharges22104114countercharges
counterchecked2562644counterchecked
countercries1648994counterc_ri_es
counterfeited1974774counter_feited
countermanded1974684counter_manded
counterplayer2055044counterpla_yer
counterplotted1963414counterplotted
counterpoised1855304counter_poised
counterraid1446754counter_rai__d
counterrallied1763254counterrallied
counterstated1665634countersta_ted
overclaimed1944684_o__verclaimed
unreclaimed1652174__unre_claimed
contemplated1954445co_ntempla_ted
countenanced1754205counte__nanced
counteractive2055955counteractive_
counterargued1754225counter_argued
counterattacked2471955counterattacked
counterbalance20123245counterbalance_
counterbalances21122825counterbalances
counterbid1546095counter__bi__d
counterblast1655405counterbla__st
counterblasts1754005counterbla_sts
counterculture1862325counterculture_
countercultures1962235countercultures
countered12313005counter_____ed
counterfeiter1874745counter_feiter
counterfire1647005counter__fire_
counterfires1747065counter__fires
counterimage1754985counterima_ge_
counterimages1854615counterima_ges
countermand1647125counter_ma__nd
countermarched2483185countermarched
countermen1449295counter____men
countermine1549745counter__mine_
countermines1649155counter__mines
countermoved2054995counter__moved
counterordered1862535counterordered
counterpane1549315counter_pa_ne_
counterpanes1649305counter_pa_nes
counterplan1586775counterpla___n
counterplans1687145counterpla__ns
counterplay18105605counterpla___y
counterplayers2153805counterplayers
counterplays1995605counterpla__ys
counterplea1547035counterpl___ea
counterpointed1953595counterpointed
counterpoise1657365counter_poise_
counterpoises1756415counter_poises
counterposed1756325counter__posed
counterpunched2492715counterpunched
counterraids1556615counter_rai_ds
counterrallies1683955counterrallies
countersigned1784355counter_signed
countersniper17104555counter_sniper
counterspies1648315counter_spi_es
counterstain14156785counterstai__n
counterstains15156625counterstai_ns
counterstate1457035countersta_te_
counterstates1586645countersta_tes
counterstrike1965295counterstrike_
counterstrikes2094745counterstrikes
countersued1447075counter___sued
countertrade1556295countertra_de_
countertrades1655895countertra_des
countervail1655655counter_vai__l
countervails1755995counter_vai_ls
counterview19116685counter__vi_ew
countrified1754115count_r_ifi_ed
countryfied2052435count_r_yfi_ed
quitclaimed255895_quit__claimed
unclaimed1435795__un___claimed

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.623286823.4
2DLD Change Limit95024857.23613132.1
3Display Results85850.0461847.8
 (SQL Overall)178691857.90522604.8
 
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.