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

105 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
counterfeiters1910374(None) 
counterfeiter1874741counterfeiter_
counterfeited1974772counterfeite_d
counterfeits1756212counterfeit__s
counterfeit1657733counterfeit___
counterfeiting2054023counterfeiting
counterfires1747063counterf_ire_s
countersnipers1893273countersnipers
countercries1648994countercri_e_s
counterfire1647004counterf_i__re
counterfoils1755394counterfoi__ls
counterforces2085554counterforce_s
countermines1649154counter_mine_s
counteroffers2153264counter_offers
counterorders1654474counter_orders
counterplayers2153804counterplayers
counterpoises1756414counterpoise_s
counterpowers2064824counter_powers
countersniper17104554countersniper_
counterspies1648314counterspi_e_s
counterstates1586644counterstate_s
countersteps1655884counter__steps
countersuits14126594countersuit__s
countertenors1554064counterte_nors
counterterrors1662484counterterrors
counterviews20134874counter_vi_ews
counterweights2372534counterweights
concertmeisters21141195co_ncertmeisters
contesters12410185co_nt___esters
contrivers1547255co_nt_r__ivers
controverters1852465co_ntroverters
converters1539635co_nver___ters
countenancers1752985counte_nancers
counteracted1747365counter_acte_d
counteractions1855025counteractions
counteracts1547515counter_act__s
counteragents1655175counteragent__s
counterargues1685045counterargue_s
counterbids1646035counter_bi__ds
counterculture1862325counterculture
countercultures1962235countercultures
counterdemands2062395counterdemands
countereffort2182845counter_effort
counterefforts2282055counterefforts
counterfactual2161825counterfactual
counterflows2054355counterf__lows
counterfoil1655205counterfoi___l
counterforce1985795counterforce__
counterimages1854615counterimage_s
counterions1349825counter__i_ons
countermeasure18122635countermeasure
countermeasures19122295countermeasures
countermemos1854435counterme__mos
countermine1549745counter_mine__
countermoves1956015counter_move_s
countermyths2253555counter_myt_hs
counteroffer2054115counter_offer_
counterorder1555615counter_order_
counterpanes1649305counter_pane_s
counterparts1646715counterpart__s
counterpetition1961945counterpetition
counterpickets2463315counterpickets
counterplayer2055045counterplayer_
counterpleas1655805counter__pleas
counterplots16106235counterplot__s
counterpointed1953595counterpointe_d
counterpoints1755625counterpoi_nts
counterpoise1657355counterpoise__
counterpoised1855305counterpoise_d
counterposes1647625counter_pose_s
counterpower1965865counter_power_
counterprotest1864435counterprotest
counterprotests1962425counterprotests
counterpunchers2482015counterpunchers
counterraids1556605counterrai__ds
counterreform2062585counterre_form
counterreforms2162175counterreforms
countershots1755935countershot__s
countersigns1546425counter_si_gns
countersinks1846165counter_si_nks
counterstate1457035counterstate__
counterstated1665635counterstate_d
counterstep1547115counter__ste_p
counterstrikes2094745counterstrike_s
counterstyles1854785counterstyle_s
countersues1348535counter__sue_s
countersuit13137505countersuit___
countertactics1763365countertactics
countertenor1454755counterte_nor_
counterterror1562555counterterror_
countertops1546355counter___tops
countertrades1655895countertrade_s
countervailed19154895countervaile_d
countervails1755995countervai__ls
counterview19116685counter_vi_e_w
counterweight2263545counterwei_ght
counterweighted25101585counterweighte_d
countries11313615count_r__i_e_s
countrysides1852055count_ryside_s
couturiers1243855cou_tur__i_ers
forfeiters1643785fo____rfeiters
intercepters16126395__intercepters
interferers1446185__interfe_rers
surfeiters1343635_su___rfeiters
underwriters1652805__underwriters

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.356501941.0
2DLD Change Limit950241057.40612830.7
3Display Results1051050.0801312.5
 (SQL Overall)1786911057.84222786.4
 
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.