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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
countermeasures1912229(None) 
countermeasure18122631countermeasure_
countercultures1962234countercultures
countermarches2373744counterm_arches
countermelodies2092164countermelodies
counterpressure1971514counterpressure_
countersues1348534counter___su_es
counterargues1685045counter__argues
counterassaults1791445counterassaults
counterblasts1754005counterblas__ts
counterchanges22124225countercha_nges
countercharges22104115countercha_rges
counterculture1862325counterculture_
counterefforts2282055counter_efforts
counterexamples28251535counterexamples
counterfeiters19103745counterfeiter_s
counterfires1747065counter___fires
counterimages1854615counterima__ges
countermanded1974685counterm_a_nded
countermands1746235counterm_a__nds
countermarch2154465counterm_a__rch
countermarched2483185counterm_arched
countermemos1854435counterme___mos
countermines1649155counterm___ines
countermoves1956015counterm___oves
counterpanes1649305counter_pa__nes
counterparts1646715counter_pa__rts
counterplayers2153805counterplayer_s
counterpoises1756415counterpois__es
counterposes1647625counter_pos__es
counterrallies1683955counter_rallies
counterreforms2162175counterre_forms
counterspies1648315counter___spies
counterstates1586645countersta__tes
countersue1247745counter___su_e_
countersued1447075counter___su_ed
countersuits14126595counter___suits
countertenors1554065counterte_nor_s
counterterrors1662485counterterror_s
countertrades1655895countertra__des
cointreaus1242696coint_r_ea_u__s
concertmasters2061546co_ncertmasters
concertmeisters21141196co_ncertmeisters
conterminous1653286co_nterminou__s
contextures2054126co_nt___extures
contrabasses1652296co_nt_rabas_ses
contractures1676046co_nt_r_actures
countenancers1752986counte__nancers
countenances1655736counte__na_nces
counteracted1747366counter__a_cted
counteracts1547516counter__a__cts
counteragents1655176counter__agents
counterargue1555306counter__argue_
counterargued1754226counter__argued
counterassault1682056counterassau_lt
counterbalances21122826counterbalances
counterblast1655406counterblas___t
counterchange2194866countercha_nge_
counterchanged23103776countercha_nged
countercharge2194296countercha__rge
countercharged23113616countercha_rged
counterclaimed2163526countercla_imed
counterclaims1954446countercla__ims
countercoups1854606counter__cou_ps
countercries1648996counter___cries
countercultural1971746countercultural
counterdemands2062396counterde_mands
countereffort2182846counter_effor_t
counterexample27151726counterexample_
counterfeited1974776counterfe__ited
counterfeiter1874746counterfe__iter
counterfeits1756216counterfe___its
counterfire1647006counter___fire_
counterforces2085556counter__forces
counterimage1754986counterima__ge_
counterman1448556counterm_a____n
countermand1647126counterm_a___nd
countermanding2053746counterm_anding
countermelody2162656counterme__lody
countermemo1754726counterme____mo
countermen1449296counterm_____en
countermine1549746counterm___ine_
countermove1855856counterm___ove_
countermoved2054996counterm___oved
countermyths2253556counterm___yths
counteroffers2153266counter_offer_s
counterordered1862536counter_ordered
counterorders1654476counter_order_s
counterpane1549316counter_pa__ne_
counterpart1547806counter_pa__r_t
counterplans1687146counterpla___ns
counterplayer2055046counterpla__yer
counterplays1995606counterpla___ys
counterpleas1655806counterplea____s
counterpoise1657366counterpois__e_
counterpoised1855306counterpois__ed
counterpose1547506counter_pos__e_
counterposed1756326counter_pos__ed
counterpowers2064826counter_power_s
counterpunchers2482016counterpunchers
counterpunches2383246counter_punches
counterraids1556616counter_ra__ids
counterrallied1763256counter_rallied
counterreaction19102376counterreaction
counterreform2062586counterre_for_m
counterreformer2271626counterreformer
counterresponse1961766counterre_sponse
countershadings2272706countershadings
countershots1755936counter___shots
countersigns1546426counter___signs
countersinks1846166counter___sinks
countersnipers1893276countersniper_s
counterstained1754846countersta_ined
counterstains15156626countersta__ins
counterstate1457036countersta__te_
counterstated1665636countersta__ted
counterstep1547116counter___s_tep
countersteps1655886counter___steps
counterstream1773736counter___stream
counterstreams18102806counter___streams
counterstrikes2094746counter_strikes
counterstrokes2064636counter_strokes
counterstyles1854786counter__styles
countersuing1547086counter___suing
countersuit13137506counter___su_it
countersunk1755266counter___su_nk
countertactics1763366counter_tactics
countertenor1454756counterte_nor__
counterterror1562556counterte__rror
counterthrusts1982466counter_thrusts
countertrade1556296countertra__de_
countervailed19154896counter_va_iled
countervails1755996counter_va__ils
counterweighted25101586counterweighted
counterweights2372536counterwe_ights
countesses1248846count___e_s_ses
countrysides1852056count_r__ysides
couturieres1352046cou_turie___res
intermeshes1645566__interme_s_hes
intermixtures2252046__intermixtures
premeasures1552826___pre_measures
remeasures1243856____re_measures
subtreasuries1571046_subt_r_easuries
treasures946636____t_r_easures
unmeasured1343306__un___measured

Search took 10 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 Limit950241458.65610977.8
3Display Results1451450.1101318.2
 (SQL Overall)1786911459.12219589.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.