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 “countersinking” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
countersinking216348(None) 
countersigning1863222countersigning
countermanding2053743countermanding
counterpointing2063033counterpointing
countershading2163833countershading
countersink1748063countersink___
countersinks1846163countersink__s
counterstaining1863243counterstain_ing
counterstating1755193counterstating
counterstriking2262943counterstriking
countersuing1547083counters__uing
countenancing1853134counte_nancing
counteracting1856284counter_acting
counterarguing18113404counterarguing
counterchanging24162974counterchanging
counterchecking2662554counterchecking
counterfeiting2054024counterfeiting
countering13314474counter____ing
countermoving2154164counter_moving
counterpoising19164194counterpoising
counterposing1885444counter_posing
counterpunching2562364counterpunching
countershadings2272704countershadings
countersign1447244countersi__gn_
countersigns1546424countersi__gns
counterstain14156784counters_tain_
counterstains15156624counters_tains
countersunk1755264countersunk___
countervailing2063734countervailing
interlinking1755054__interlinking
mountebanking2261544mounte_banking
outdrinking1743964_ou_tdr_inking
cauterizing2345945cau_ter_i_zing
chuntering1647805chunter____ing
cointerring1447145cointer___ring
concerning1548905co_ncer__n_ing
concertizing2655635co_ncerti_zing
conferencing2053855co_nfer_encing
constraining1554545co_nstrain_ing
constringing1653565co_nstr_inging
containing13410935co_nt__ain_ing
contemning1577065co_nte__mn_ing
contending1449125co_nte___nding
contenting13313325co_nte___nting
contesting13312215co_nte_s__ting
continuing1348195co_nt___inuing
contriving1648195co_nt_r_i_ving
conversing16310545co_nvers___ing
countercharging24183065countercharging
counterclaiming2262925counterclaiming
counterion1249535counter_i__on_
counterions1349825counter_i__ons
countermarching2562605countermarching
countermine1549745counter___mine
countermines1649155countermin__es
counterordering19162415counterordering
counterpicket2355165counterpick_et
counterpickets2463315counterpickets
counterplotting2062805counterplotting
counterpoint1658175counter__point
counterrallying2162275counterrallying
countersigned1784355countersi_gned
countersniper17104555counters_niper
countersnipers1893275countersnipers
counterspies1648315counters__pies
counterstained1754845counters_tained
counterstricken2372745counterstricken_
counterstrike1965295counters_trike
counterstrikes2094745counterstrikes
countersuit13137505counters__ui_t
countersuits14126595counters__uits
courtesying1743125courte_s__ying
fountaining15103645fount__ain_ing
interlining1249135__interlin_ing
nondrinking1753415no_n_dr_inking
nonterminating1773125no_nterminating
nonthinking1953515no_nt__hinking
outgrinning1353695_ou_tgr_inning
outranking1537675_ou_t_r_anking
outringing1247815_ou_t_r_inging
outsinging1246275_ou_t__singing
outsinning1146175_ou_t__sinning
outthinking1943655_ou_t_thinking
outtricking1844145_ou_ttr_icking
underlining1346685__underlin_ing
undermining1546365__undermin_ing
underpinning1653425__underpinning
undersigning1553465__undersigning
unthinking1844665__unt__hinking

Search took 8 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.360496363.9
2DLD Change Limit95024897.37312888.1
3Display Results89890.0631412.7
 (SQL Overall)178691897.79622920.9
 
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.