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

39 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
counterchecking2662551counterchecking_
counterchanging24162974counterchanging_
countercharging24183064countercharging_
countercheck2254114countercheck____
counterchecked2562644countercheck__ed
counterchecks2353324countercheck___s
counteracting1856285counter__acting_
counterchange2194865counterch___ange
counterclaiming2262925counterclaiming_
counterfeiting2054025counter_feiting_
countermarching2562605countermarching_
counterpunching2562365counterpunching_
countershading2163835countersh_ading_
countershadings2272705countersh_adings
countersinking2163485counter_sinking_
counterstriking2262945counterstriking_
countenancing1853136counte_nanc_ing_
counterarguing18113406counter_arguing_
countercampaign2471676countercampai_gn
counterchanged23103776counterch___anged
counterchanges22124226counterch___anges
countercharge2194296counterch___arge
countercyclical2081076counterc_yclical
counterguerilla1871416countergue_rilla
countering13314476counter_____ing_
countermanding2053746counter_manding_
countermoving2154166counter__moving_
counterordering19162416counterordering_
counterplotting2062806counterplotting_
counterpointing2063036counterpointing_
counterpoising19164196counter_poising_
counterposing1885446counter__posing_
counterrallying2162276counterrallying_
countersigning1863226counter_signing_
counterstaining1863246counterstaining_
counterstating1755196counter_stating_
countersuing1547086counter___suing_
countervailing2063736counter_vailing_
forechecking2751766fo__re_checking_

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.326548131.9
2DLD Change Limit65874395.42312147.2
3Display Results39390.0301300.0
 (SQL Overall)178691395.77930920.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.