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

110 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
counterthrust187360(None) 
counterthrusts1982461counterthrusts
counterthreat1854052counterthreat
counterthreats1962873counterthreats
underthrust1552733__underthrust
counterblast1655404counter_blast
counterfires1747064counterfires_
counterpart1547804counterpar__t
counterparts1646714counterparts_
countershot1656634countersh__ot
countershots1755934countershots_
counterstruck2163194counterstruck
countersuit13137504counter__suit
counterterror1562554counterterror
countertops1546354countert_ops_
countertrade1556294countert_rade
countertrend1575944countert_rend
outthrust1243644_ou_t__thrust
underthrusts1651674__underthrusts
contentious1347015co_ntentious_
contesters12410185co_ntester_s_
contextures2054125co_ntextures_
converters1539635co_nverter_s_
convertors1549135co_nvertor_s_
counteract1449605counte___ract
counteracts1547515counter_acts_
counteragent1557695counter_agent
counteragents1655175counteragents
counterargue1555305counter_argue
counterargued1754225counterargued
counterargues1685045counterargues
counterassault1682055counterassault
counterbids1646035counter_bids_
counterblasts1754005counter_blasts
counterblows1954215counterblows_
counterchange2194865counterchange
countercharge2194295countercharge
countercharged23113615countercharged
countercharges22104115countercharges
countercheck2254115counterch_eck
counterchecks2353325counterchecks
countercoup1774495counter_cou_p
countercoups1854605counter_coups
countercries1648995counter_cries
countercry1745095counter_cr__y
countercurrent1863465countercurrent
countereffort2182845countereffort
counterfeit1657735counter__feit
counterfeits1756215counterfeits_
counterfire1647005counterfir__e
counterflows2054355counterflows_
counterfoils1755395counterfoils_
counterforce1985795counterfor_ce
counterforces2085555counterforces
counterions1349825counter_ions_
countermands1746235countermands_
countermarch2154465countermar_ch
countermemos1854435countermemos_
countermines1649155countermines_
countermoves1956015countermoves_
countermyths2253555countermyths_
counterorder1555615counter_order
counterpanes1649305counterpanes_
counterpicket2355165counterpicket
counterplans1687145counterplans_
counterplays1995605counterplays_
counterpleas1655805counterpleas_
counterplot1596815counter__plot
counterplots16106235counterplots_
counterploys1995355counterploys_
counterpoint1658175counter_point
counterpoints1755625counterpoints
counterpoise1657355counter_poise
counterpose1547505counter__pose
counterposes1647625counterposes_
counterprotest1864435counterprotest
counterraid1446755counter__raid
counterraids1556605counterraids_
counters103320195counte___r_s_
countersigns1546425countersigns_
countersinks1846165countersinks_
counterspies1648315counterspies_
counterstains15156625counterstains_
counterstates1586645counterstates_
countersteps1655885countersteps_
counterstream1773735counterstream
counterstrike1965295counterstrike
counterstroke1954785counterstroke
counterstyles1854785counterstyles_
countersue1247745counter__su_e
countersued1447075counter__sued
countersues1348535counter__sues
countersuits14126595counter__suits
countersunk1755265counter__sunk
countertactic1663915countertactic
countertenor1454755countert_enor
countertenors1554065countertenors
counterterrors1662485counterterrors
countertop1445845countert___op
countertrades1655895countertrades
countertrends1674355countertrends
countervails1755995countervails_
counterviews20134875counterviews_
counterweight2263545counterweight
counterworld1854225counterwor_ld
counterworlds1953465counterworlds
countinghouse1981045countinghouse
courthouse1543905cou___rthouse
outthrusts1352005_ou_t__thrusts
waterthrush2061175__waterthrush

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.406440125.6
2DLD Change Limit1247901109.17313604.1
3Display Results1101100.0761447.4
 (SQL Overall)1786911109.65518507.6
 
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.