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

43 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
counterprojects2862151counterprojects_
counterproject2763192counterproject__
counterprotests1962423counterprotests_
counterprotest1864434counterprote__st
counterpickets2463315counterpicke_ts_
counterplots16106235counterplo___ts_
counterpoints1755625counterp_o_ints_
counterposes1647625counterp_ose__s_
counterpowers2064825counterp_owe_rs_
counterproposal21101335counterpro__posal
counteracts1547516counte__r__acts_
counteragents1655176counte__ragents_
counterargues1685046counterargue__s_
counterchecks2353326counte__rchecks_
countercries1648996countercr_ie__s_
countercurrents1962336countercurrents_
counterfeits1756216counte__r_feits_
counterforces2085556counter_fo_rces_
countermoves1956016counter_move__s_
counterorders1654476counteror_de_rs_
counterpanes1649306counterp_ane__s_
counterparts1646716counterp___arts_
counterpicket2355166counterpicke_t__
counterpicketed2671626counterpicke_ted
counterplayers2153806counterplaye_rs_
counterplea1547036counterp__le___a
counterpleas1655806counterp__le_as_
counterplot1596816counterplo___t__
counterplotted1963416counterplo__tted
counterploys1995356counterplo___ys_
counterpoint1658176counterp_o_int__
counterpointed1953596counterp_o_inted
counterpoise1657366counterp_o___ise
counterpoises1756416counterp_o_ises_
counterpose1547506counterp_o____se
counterposed1756326counterp_ose___d
counterpower1965866counterp_owe___r
countershots1755936countersho___ts_
counterstrokes2064636counterstroke__s_
counterthreats1962876counter_threats_
countertrades1655896countertrade__s_
countertrends1674356countertr__ends_
overprotects1953036_o__verprotects_

Search took 7 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 Limit65874436.17310671.3
3Display Results43430.0331303.0
 (SQL Overall)178691436.53227356.2
 
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.