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

178 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
counterpowers206482(None) 
counterpower1965861counterpower_
counterposes1647622counterpose_s
countermoves1956013countermove_s
counteroffers2153263counteroffers
counterorders1654473counterorders
counterpanes1649303counterpane_s
counterplayers2153803counterplayers
counterpleas1655803counterp_leas
counterpoints1755623counterpoints
counterpoises1756413counterpoises
counterpose1547503counterpose__
counterposed1756323counterpose_d
coneflowers19113154co_n_eflowers
countenancers1752984countenancers
counterblows1954214counterblow__s
countercoups1854604counterco_ups
countercries1648994countercrie_s
counterfeiters19103744counterfeiters
counterfires1747064counterfire_s
counterflows2054354counterflow__s
counterfoils1755394counterfo_ils
counterforces2085554counterforces
counterions1349824counterio__ns
countermines1649154countermine_s
countermove1855854countermove__
countermoved2054994countermove_d
counteroffer2054114counteroffer_
counterorder1555614counterorder_
counterpane1549314counterpane__
counterpart1547804counterp__art
counterparts1646714counterp_arts
counterpickets2463314counterpickets
counterplans1687144counterp_lans
counterplayer2055044counterplayer_
counterplays1995604counterp_lays
counterplea1547034counterp_le_a
counterplots16106234counterp_lots
counterploys1995354counterp_loys
counterpoint1658174counterpo_int
counterpoise1657354counterpo_ise
counterpoised1855304counterpoised
counterposing1885444counterposing
counterproject2763194counterproject
counterprojects2862154counterprojects
counterprotest1864434counterprotest
counterprotests1962424counterprotests
counterpunchers2482014counterpunchers
countersnipers1893274countersnipers
counterspies1648314counterspie_s
countersteps1655884counter_steps
countersues1348534counter_sue_s
countertenors1554064countertenors
countertops1546354counterto__ps
counterviews20134874counter_views
counterworlds1953464counterworlds
interposers1346264__interposers
outpowers1445194_ou_t__powers
overpowers1844724_o__verpowers
superpowers1894804_su_perpowers
waterpowers1953514__waterpowers
candlepowers20101515c_andlepowers
concertgoers1752585co_ncertgoers
coneflower1873215co_n_eflower_
conferrers1546455co_nfer__rers
conservers1547685co_nser__vers
contemners1447075co_nte__mners
contemnors1445245co_ntemno__rs
contemporary2162385co_ntemporary
contenders1348625co_nte__nders
contesters12410185co_nte__sters
contrivers1547255co_nt_r_ivers
controllers1344785co_nt_rollers
controversy1952585co_nt_r_oversy
controvert1547175co_nt_r_overt
controverts1654265co_nt_r_overts
conversers1547355co_nver__sers
converters1539635co_nver__ters
convertors1549135co_nverto__rs
cornflowers1952585corn__flowers
costermongers1871185co_stermongers
counsellors1352965counsello__rs
counselors1243655counse_lo__rs
countdowns1642025count__dow_ns
countenancer1654225countenancer_
countenances1655735countenance_s
counteracted1747365counteracte_d
counteracts1547515counter__acts
counteragent1557695counter_agent
counteragents1655175counteragents
counterargues1685045counterargues
counterbids1646035counter__bids
counterblasts1754005counterblasts
counterblow1853905counterblow___
countercheck2254115counter_check
counterchecks2353325counterchecks
counterclaims1954445counterclaims
countercoup1774495counterco__up
countercry1745095counter___cry
countered12313005counter___e_d
countereffort2182845countereffort
counterefforts2282055counterefforts
counterfeit1657735counter__feit
counterfeiter1874745counterfeiter_
counterfeits1756215counter_feits
counterfire1647005counter__fire
counterflow1954005counterflow___
counterfoil1655205counterfo__il
counterforce1985795counterfo_rce
counterimages1854615counterimages
counterion1249535counterio___n
countermands1746235counter_mands
countermemo1754725counter__memo
countermemos1854435counter_memos
countermen1449295counter__me_n
countermine1549745countermine__
countermoving2154165countermoving
countermyths2253555counter_myths
counterordered1862535counterordered
counterpicket2355165counterpicket
counterplan1586775counterp__lan
counterplay18105605counterp__lay
counterplot1596815counterp__lot
counterplotted1963415counterplotted
counterploy18105205counterp__loy
counterpointed1953595counterpointed
counterpoising19164195counterpoising
counterpunch2154195counterp_unch
counterpuncher2382635counterpuncher_
counterpunches2383245counterpunches
counterraids1556605counter_raids
counterreform2062585counterreform
counterreforms2162175counterreforms
counters103320195count_____ers
countershots1755935counter_shots
countersigns1546425counter_signs
countersinks1846165counter_sinks
countersniper17104555countersniper_
counterspell1653915counter_spell
counterspells1753465counterspells
counterstains15156625counterstains
counterstates1586645counterstates
counterstep1547115counter_ste_p
counterstream1773735counterstream
counterstreams18102805counterstreams
counterstrokes2064625counterstroke_s
counterstyles1854785counterstyles
countersue1247745counter_sue__
countersued1447075counter_sue_d
countersuits14126595counter_suits
countertenor1454755countertenor_
counterterrors1662485counterterrors
counterthreat1854055counterthreat
counterthreats1962875counterthreats
countertop1445845counterto___p
countertrades1655895countertrades
countertrend1575945counter_trend
countertrends1674355countertrends
countervails1755995counter_vails
counterview19116685counter_vie_w
counterworld1854225counterwo_rld
countesses1248845counte__sse_s
countries11313615count_r__ie_s
couturiers1243855cou_tur__iers
horsepowers1952935ho_rse_powers
interlopers1346195__interlopers
interposer1248115__interposer_
interposes12410565__interpose_s
outpower1336675_ou_t__power_
outtowers1244765_ou_t__towers
overpower1746235_o__verpower_
poulterers1244565poulter___ers
saunterers1044385saunter___ers
superpower1785455_su_perpower_
thundershowers24171265thundershowers
undergoers1245005__undergo_ers
underpowered1952145__underpowered
waterpower1854085__waterpower_

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901789.08013743.4
3Display Results1781780.1101618.2
 (SQL Overall)1786911789.58018652.5
 
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.