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

137 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
countercurrents196233(None) 
countercurrent1863461countercurrent_
undercurrents1692023__undercurrents
concurrents1554564co_n___currents
counteragents1655174counter__agents
countercries1648994counterc_rie__s
counterthreats1962874counter_threats
countertrends1674354counter__trends
intercurrent1454354__intercurrent_
supercurrents17113474_su_percurrents
undercurrent1573014__undercurrent_
concurrent1446315co_n___current_
counteragent1557695counter__agent_
countercharges22104115counterchar_ges
counterchecks2353325counterc__hecks
countercultures1962235countercultures
counterfeits1756215counte___rfeits
counterfires1747065counter_fire__s
counterforces2085555counterforce__s
counterorders1654475counter_orde_rs
counterparts1646715counter_par__ts
counterpickets2463315counterpicke_ts
counterpoints1755625counter__points
counterprojects2862155counterprojects
counterprotests1962425counterprotests
counterstreams18102805counter_streams
countersues1348535countersu__e__s
countersuits14126595countersu___its
counterterrors1662485counterterr_ors
counterthreat1854055counter_threat_
counterthrusts1982465counter_thrusts
countertrend1575945counter__tren_d
nonrecurrent1462965no_nre_current_
supercurrent16114455_su_percurrent_
concernments1865246co_ncer__nments
concurrence1454796co_n___currence
concurrences1554406co_n___currences
concurrency1753426co_n___currency
concurrently1952896co_n___currently
conferments1848326co_nfe___rments
consequents2274466co_nse_qu__ents
contentments1655486co_nte__ntments
contextures2054126co_ntextu_re__s
controlments1684446co_nt_r_olments
counteractions1855026counteraction_s
counteracts1547516counte____racts
counterargues1685046counter__argues
counterargument2072026counterargument_
counterassaults1791446counterassaults
counterblasts1754006counter__blasts
counterchange2194866counterc__hange
counterchanges22124226counterc_hanges
countercharge2194296counterchar__ge
countercharged23113616counterchar_ged
countercharging24183066countercharging
countercheck2254116counterc__he_ck
counterclaims1954446counterc__laims
countercoups1854606counterc___oups
countercry1745096counterc__r___y
countercultural1971746countercultural
counterculture1862326countercu_lture
counterdemands2062396counter_demands
counterefforts2282056counter_efforts
counterevidence2391586counterevidence
counterfeit1657736counte___rfeit_
counterfeiters19103746counterfeite_rs
counterfire1647006counter_fire___
counterforce1985796counterforce___
counterguerilla1871416counterguerilla
counterimages1854616counterimage__s
counterions1349836counte___rion_s
counterirritant1771736counterirritant_
countermands1746236counte___rmands
countermarches2373746counter_marches
countermemos1854436counte___rmemos
countermen1449296counte___rmen__
countermines1649156counte___rmines
countermovement2471816countermovement_
countermoves1956016counter_move__s
counteroffers2153266counter_offe_rs
counterorder1555626counter_orde__r
counterordered1862536counter_ordered
counterpanes1649306counte___rpanes
counterpart1547806counter_par__t_
counterpicket2355166counterpicke_t_
counterplans1687146counter__plan_s
counterplayers2153806counterplaye_rs
counterpleas1655806counter__ple_as
counterplots16106236counte___rplots
counterpoint1658176counter__point_
counterpoises1756416counterpoise__s
counterposes1647626counter_pose__s
counterpowers2064826counter_powe_rs
counterproject2763196counterproject_
counterprotest1864436counterprotest_
counterpunch2154196counterpu___nch
counterpunchers2482016counterpunchers
counterpunches2383246counterpu_nches
counterraids1556616counte___rraids
countershadings2272706countershadings
countershots1755936counte___rshots
countersigns1546426counter__sign_s
countersinks1846166counte___rsinks
countersnipers1893276countersnipe_rs
counterspells1753466counter__spells
counterspies1648316counter_spie__s
counterstains15156626counter_stain_s
counterstates1586646counterstate__s
countersteps1655886counter__ste_ps
counterstream1773736counter_stre_am
counterstrikes2094746counter_strikes
counterstrokes2064636counter_strokes
counterstyles1854786counterstyle__s
countersue1247746countersu__e___
countersued1447076countersu__e__d
countersuing1547086countersu__in_g
countersuit13137506countersu___it_
countersunk1755266countersu___n_k
countertendency2371926countertendency
countertenor1454756counte___rtenor
countertenors1554066counte___rtenors
counterterror1562556counterterr__or
counterthrust1873606counter_thrust_
countertrades1655896counter__trades
counterviews20134876counter__vie_ws
counterviolence2271566counterviolence
counterweights2372536counter_weights
counterworlds1953466counter_wor_lds
countryseats1751486count_r__yseats
crosscurrents1761036c__rosscurrents
nonconcurrent1763216no_nconcurrent_
noncurrent1255516no_n___current_
occurrents1453006_o____ccurrents
overcorrects19153006_o__vercorrects
photocurrents2072136_phot_ocurrents
uncurrent1145676__un___current_
undergarments1762806__undergarments

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.376475242.0
2DLD Change Limit950241378.84310745.7
3Display Results1371370.0931473.1
 (SQL Overall)1786911379.31219189.3
 
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.