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

59 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
counterplotting2062801counterplotting_
counterplotted1963414counterplott__ed
counterpointing2063034counterpointing_
counterpoising19164194counterp_oising_
counterposing1885444counterp_o_sing_
contemplating2054125co_ntempl_ating_
counteracting1856285counter__acting_
counterclaiming2262925counterclaiming_
counterfeiting2054025counter_feiting_
countermoving2154165counter_mo_ving_
counterplot1596815counterplo_t____
counterplots16106235counterplo_t___s
counterpoint1658175counterp_o__in_t
counterpoints1755625counterp_o__ints
counterpunching2562365counterpunching_
counterstating1755195counter_stating_
outplotting1443755_ou_t__plotting_
overplotting1845045_o__verplotting_
complotting18124266co____mplotting_
coplotting1555956co_____plotting_
counterarguing18113406counter_arguing_
counterchanging24162976counterchanging_
countercharging24183066countercharging_
counterchecking2662556counterchecking_
countering13314476counter_____ing_
countermanding2053746counter_manding_
countermarching2562606countermarching_
counterordering19162416counterordering_
counterpetition1961946counterp_etition
counterplan1586776counterpl___an__
counterplans1687146counterpl___an_s
counterplea1547036counterpl_____ea
counterploy18105206counterplo_____y
counterploys1995356counterplo____ys
counterpointed1953596counterp_o__inted
counterpoise1657356counterp_o__i_se
counterpoised1855306counterp_o__ised
counterpoises1756416counterp_o__ises
counterprotest1864436counterpro_t_est
counterprotests1962426counterpro_tests
counterrallying2162276counterrallying_
countershading2163836counter_shading_
countershadings2272706counter_shadings
countersigning1863226counter_signing_
countersinking2163486counter_sinking_
counterstain14156786counter__stain__
counterstained1754846counter__stained
counterstaining1863246counterstaining_
counterstains15156626counter__stain_s
counterstriking2262946counterstriking_
countersuing1547086counter___suing_
countervailing2063736counter_vailing_
interknotting1852666__interknotting_
interplanting1655346__interplanting_
interpolating1657796__interpolating_
outtrotting1244106_ou_ttr__otting_
underclothing2061896__underclothing_
underclothings216966__underclothings
underletting1454186__under_letting_

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.330541487.9
2DLD Change Limit65874594.78013781.2
3Display Results59590.0331787.9
 (SQL Overall)178691595.14334744.5
 
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.