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

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

70 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
counterreformer227162(None) 
counterreform2062582counterreform__
counterreforms2162172counterreform_s
counterforce1985794counte_r_force_
counterforces2085554counte_r_forces
counterorder1555614counte_r__order
countereffort2182845countereffor__t
counterefforts2282055countereffor_ts
counterfeiter1874745counte_r_feiter
counterfire1647005counte_r_fir_e_
counterfires1747065counte_r_fir_es
countermelodies2092165countermelodies
counteroffer2054115counte_r__offer
counterorders1654475counte_r__orders
counterpower1965865counte_r_po_wer
counterresponse1961765counterresponse_
countertenor1454755counterteno___r
countertenors1554065countertenor__s
counterterror1562555counterte__rror
nonperformer19162345no_npe_r_former
conformer1667466co_n_____former
counterattacker2371796counterattacker
countercharge2194296counte_rcharge_
countercharged23113616counte_rcharged
countercharges22104116counte_rcharges
counterclaimed2163526counte_rclaimed
countercries1648996counte_r__cries
counterfeited1974776counte_r_feited
counterfeiters19103746counte_r_feiters
counterfoil1655206counte_r_fo__il
counterfoils1755396counte_r_fo_ils
countermeasure18122636countermeasure_
countermeasures19122296countermeasures
countermelody2162656countermelo__dy
countermemo1754726counterme___m_o
countermemos1854436counterme___mos
countermen1449296count___e__rmen
countermove1855856counte_r_mo_ve_
countermoved2054996counte_r_mo_ved
countermoves1956016counte_r_mo_ves
counteroffers2153266counteroffer__s
counterordered1862536counterorder_ed
counterplayer2055046counte_r_player
counterplotted1963416counte_rplotted
counterpoise1657356counte_r_poise_
counterpoised1855306counte_r_poised
counterpoises1756416counte_r_poises
counterpose1547506counte_r_po_se_
counterposed1756326counte_r_po_sed
counterposes1647626counte_r_po_ses
counterpowers2064826counte_r_po_wers
counterpressure1971516counterpressure_
counterpuncher2382636counte_rpuncher
counterrallied1763256counterr_allied
counterrallies1683956counterr_allies
counterreaction19102376counterreaction
countersniper17104556counte_r_sniper
counterstroke1954786counterstro_ke_
counterstrokes2064626counterstro_kes
counterterrors1662486counterte_rrors
counterweighted25101586counterweighted
counterworld1854226counte_r_wor_ld
counterworlds1953466counte_r_worlds
countrywomen2291946count__rywo_men
nonperformers20152176no_npe_r_formers
outperformed2051346_ou_tper_formed
terraformed1751686____terraformed
underreported1761716__underreported
unperformed1972496__unpe_r_formed
unreformed1643566__un___reformed

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.343520965.0
2DLD Change Limit95024707.28013052.7
3Display Results70700.0631111.1
 (SQL Overall)178691707.68623248.9
 
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.