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

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

64 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
counterstaining1863241counterstaining_
counterstating1755193countersta_ting_
counterstriking2262943counterstriking_
counterclaiming2262924counterclaiming_
countershading2163834countersha_ding_
countershadings2272704countersha_dings
countersigning1863224counters_igning_
countersinking2163484counters__inking_
counterstain14156784countersta__in__
counterstained1754844countersta__ined
counterstains15156624countersta__in_s
countervailing2063734counter_vailing_
counteracting1856285counter__acting_
counterchanging24162975counterchanging_
countercharging24183065countercharging_
counterfeiting2054025counter_feiting_
countermanding2053745counter_manding_
counterpointing2063035counter_pointing_
counterpoising19164195counter_poising_
countersuing1547085counters___uing_
entertaining1354385__enter_taining_
concertizing2655636co_ncer_t_izing_
conservatizing2983096co_nservatizing_
constraining1554546co_n___straining_
containing13410936co_n____taining_
contesting13312216co_nte_st___ing_
countenancing1853136counte__nancing_
counterarguing18113406counter_arguing_
counterchange2194866countercha___nge
counterchecking2662556counterchecking_
countering13314476counter_____ing_
countermarching2562606countermarching_
countermoving2154166counter__moving_
counterordering19162416counterordering_
counterplotting2062806counterplotting_
counterposing1885446counter__posing_
counterpunching2562366counterpunching_
counterrallying2162276counterrallying_
countersign1447246counters____i_gn
countersigned1784356counters__i_gned
countersigns1546426counters__i_gn_s
countersink1748066counters____in_k
countersinks1846166counters____inks
countersniper17104556counters___niper
counterstate1457036countersta____te
counterstated1665636countersta___ted
counterstates1586646countersta___tes
counterstrategy2182136counterst_rategy
counterstricken2372746counterstri_cken
counterstrike1965296counterst__ri_ke
counterstrikes2094746counterst__rikes
countertactic1663916counter_tacti__c
countertactics1763366counter_tacti_cs
curtaining1345536c_u___r_taining_
entertainingly1861196__enter_tainingly
fountaining15103646foun____taining_
intertwining1654226__inter_twining_
overstraining1754136_o__verstraining_
thunderstriking2481426thunderstriking_
understaffing21102736__understaffing_
understaffings22121596__understaffings
understanding1673776__understanding_
understandings17112376__understandings
understating1446546__understa_ting_

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit65874645.76311430.5
3Display Results64640.0501280.0
 (SQL Overall)178691645.90630255.8
 
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.