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

102 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
counterchecking266255(None) 
counterchanging24162973counterchanging
countercharging24183063countercharging
countercheck2254113countercheck___
counterchecked2562643countercheck_ed
counterchecks2353323countercheck__s
counteracting1856284counter__acting
counterclaiming2262924counterclaiming
counterfeiting2054024counter_feiting
countermarching2562604countermarching
counterpunching2562364counterpunching
countershading2163834countersh_ading
countersinking2163484counter_sinking
counterstriking2262944counterstriking
countenancing1853135counte_nanc_ing
counterarguing18113405counter_arguing
countercampaign2471675countercampaign
counterchange2194865counterch___ange
countering13314475counter_____ing
countermanding2053745counter_manding
countermoving2154165counter__moving
counterordering19162415counterordering
counterplotting2062805counterplotting
counterpointing2063035counterpointing
counterpoising19164195counter_poising
counterposing1885445counter__posing
counterrallying2162275counterrallying
countershadings2272705countersh_adings
countersigning1863225counter_signing
counterstaining1863245counterstaining
counterstating1755195counter_stating
countersuing1547085counter___suing
countervailing2063735counter_vailing
forechecking2751765fo__re_checking
bodychecking306896bo___dychecking
chuntering1647806chunter_____ing
coerecting15218786co___er__ecting
cointerring1447146cointer____ring
condescending2052286co_ndesc_ending
conferencing2053856co_nfer__encing
contracting16610476co_nt_r__acting
contradicting1954076co_nt_radicting
contravening1853566co_nt_rave_ning
controverting1953366co_nt_roverting
counteraction1755386counter__action
counteractions1855026counter__actions
counteractive2055956counter__active
counteragent1557696counterage___nt
counterblockade2671016counterblockade
counterchanged23103776counterch_anged
counterchanges22124226counterch_anges
countercharge2194296counterch__arge
countercharged23113616counterch_arged
countercharges22104116counterch_arges
counterclaim1854756counterc__lai_m
counterclaims1954446counterc__laims
countercries1648996counter___cries
countercurrent1863466counterc_urrent
countercyclical2081076counterc_yclical
counterdemand1963216counter_de_mand
counterfeit1657736counter_fe__i_t
counterfeits1756216counter_fe__its
countermen1449296counter_me___n_
countermine1549746counter____mine
counterpicket2355166counter_pick_et
counterpickets2463316counter_pickets
counterpoint1658176counter___point
counterquestion2671216counterquestion
counterreaction19102376counterreaction
countersign1447246counter____sign
countersink1748066counter____sink
counterstain14156786counter__stain_
counterstains15156626counter__stains
counterstricken2372746counterstricken_
countertactic1663916counter_tacti_c
countertactics1763366counter_tactics
countertrend1575946countertre___nd
interceding1568046__interc_e_ding
intercepting1748876__interc_epting
interchanging2052996__interchanging
interjecting2248396__inter_jecting
interlocking1954906__inter_locking
intersecting1549716__inter_secting
mountebanking2261546mounte__banking
nonintersecting1871546noninter_secting
nonteaching1753586no_nteach___ing
outcheating1744876_ou_t__cheating
outechoing1644626_ou_te_ch__oing
outrocking1747056_ou_t_r__ocking
outscheming1942856_ou_t_sche_ming
outtricking1844146_ou_ttr__icking
overdecking2246056_o__ver_decking
prechecking2543076___pre_checking
rechecking2244466____re_checking
rubbernecking246956_rubber_necking
undercharging2152596__undercharging
undercooking2063246__underc_ooking
underheating1785136__under_heating
underwhelming2361536__underwhelming
unteaching1645496__unteach___ing
untethering1543686__unte_the_ring
untracking1746936__unt_r__acking

Search took 9 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.343520965.0
2DLD Change Limit950241028.26611495.8
3Display Results1021020.0761342.1
 (SQL Overall)1786911028.68520574.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.