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

139 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
counterspells175346(None) 
counterspell1653911counterspell_
counterpleas1655803counter_pleas
counterspies1648313countersp_ies
countersteps1655883counterste_ps
counterstyles1854783counterstyles
countersues1348533countersue__s
counteragents1655174counteragents
counterchecks2353324counterchecks
counterfeits1756214counter_feits
counterfoils1755394counter_foils
countermemos1854434counter_memos
counterpanes1649304counter_panes
counterparts1646714counter_parts
counterplan1586774counter_p_lan
counterplans1687144counter_plans
counterplay18105604counter_p_lay
counterplays1995604counter_plays
counterplea1547034counter_p_lea
counterplot1596814counter_p_lot
counterplots16106234counter_plots
counterploy18105204counter_p_loy
counterploys1995354counter_ploys
counterposes1647624counter_poses
counterrally1755524counter_rally
countershots1755934counters_hots
countersigns1546424counters_igns
countersinks1846164counters_inks
countersnipers1893274countersnipe_rs
counterspy1744664countersp___y
counterstains15156624counterstains
counterstates1586644counterstates
counterstep1547114counterste__p
counterstreams18102804counterstreams
counterstyle1755054counters_tyle
countersue1247744countersue___
countersued1447074countersue__d
countersuits14126594counters_uits
countertrends1674354countertrends
countervails1755994counter_vails
counterviews20134874countervie_ws
counterworlds1953464counterworlds
countesses1248844counte_sse__s
outspells11104604_ou_t__spells
undersells1144734__unders_ells
bonspells1343195bo_n___spells
chanterelle1651735chanter__elle
chanterelles1751905chanter__elles
cockleshells2313815cockle_shells
contesters12410185co_nte_ste_rs
conversely1844905co_nvers_e_ly
conversers1547355co_nvers_e_rs
converses14311165co_nvers_e__s
counsels1037575coun___s_e_ls
counteracts1547515counter__acts
counteragent1557695counterage_nt
counterargues1685045counterargues
counterassault1682055counterassault
counterassaults1791445counterassaults
counterbids1646035counter__bids
counterblast1655405counter__blast
counterblasts1754005counterblasts
counterblow1853905counter__blow
counterblows1954215counter_blows
countercheck2254115counterche_ck
counterclaims1954445counterclaims
countercoups1854605counter_coups
countercries1648995counter_cries
countered12313005counter__e__d
counterfeit1657735counter_fe_it
counterfires1747065counter_fires
counterflow1954005counter__flow
counterflows2054355counter_flows
counterfoil1655205counter_foil_
counterforces2085555counterforces
counterguerilla1871415counterguerilla
counterimages1854615counterimages
counterions1349825counter__ions
countermands1746235counter_mands
countermelody2162655counter_melody
countermemo1754725counter_me_mo
countermen1449295counter_me__n
countermines1649155counter_mines
countermoves1956015counter_moves
countermyths2253555counter_myths
counteroffers2153265counteroffers
counterorders1654475counterorders
counterpane1549315counter_p_ane
counterpart1547805counter_p_art
counterpoint1658175counter_point
counterpoints1755625counterpoints
counterpoise1657355counter_poise
counterpoises1756415counterpoises
counterpose1547505counter_p_ose
counterposed1756325counter_posed
counterpower1965865counter_power
counterpowers2064825counterpowers
counterpunch2154195counter_punch
counterraids1556605counter_raids
counterrallies1683955counterrallies
counters103320195counter_____s
countershot1656635counters__hot
countersign1447245counters__ign
countersigned1784355countersigned
countersink1748065counters__ink
countersniper17104555countersniper
counterstain14156785counters_tain
counterstate1457035counters_tate
counterstated1665635counterstated
counterstream1773735counterstream
counterstrike1965295counterstrike
counterstrikes2094745counterstrikes
counterstroke1954785counterstroke
counterstrokes2064625counterstrokes
counterstruck2163195counterstruck
countersuing1547085counters_uing
countersuit13137505counters__uit
countersunk1755265counters__unk
countertenor1454755counter_tenor
countertenors1554065countertenors
counterthreats1962875counterthreats
countertops1546355counter__tops
countertrades1655895countertrades
countertrend1575945countertre_nd
countervail1655655counter_vail_
countervailed19154895countervailed
counterview19116685countervie__w
counterworld1854225counter_world
countess103710055counte_s____s
countries11313615count_r_ie__s
countryseats1751485count_ryseats
courtesies1246455courte_sie__s
outsells888645_ou_t__s_ells
outsmells1194105_ou_t__smells
outspell10125455_ou_t__spell_
oversells1236975_o__vers_ells
overspills1543865_o__verspills
supersells1246465_su_pers_ells
undersell1045765__unders_ell_

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.436409841.7
2DLD Change Limit1247901398.53314624.4
3Display Results1391390.0931494.6
 (SQL Overall)1786911399.06219718.7
 
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.