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

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

36 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
cocultivations215276(None) 
cocultivation2053051cocultivation_
cocultivating2162342cocultivati_ng
cultivations1745592__cultivations
noncultivations20182752noncultivations
cocultivates1962573cocultivat__es
cultivation16116413__cultivation_
noncultivation19183063noncultivation_
occultations1644373occult__ations
acculturations18182904acculturations
activations1669264_ac__tivations
captivations1945344__captivations
cocainizations2755434cocainizations
cocultivate1852714cocultivat___e
cocultivated2052254cocultivat__ed
colligations1556834co__lligations
collimations1656874co__llimations
columniations1764794columni_ations
complications2147434compl_ications
conciliations1747204concil_i_ations
concretizations2854034concretizations
conglutinations1862544conglutinations
constipations1747684co_nstipations
consultations1546934consult__ations
copulations151111114copul___ations
culminations1646534__culminations
cultivating1744944__cultivati_ng
cultivators1653844__cultivat_ors
cyclizations2845754cyc_l_izations
enculturations1652424enculturations
focalizations2748994focal_izations
localizations2449794local_izations
motivations1647094mo___tivations
occultation1545134occult__ation_
recultivating1953014recultivati_ng
vocalizations2749274vocal_izations

Search took 4 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.313570897.8
2DLD Change Limit65874363.46619005.8
3Display Results36360.0162250.0
 (SQL Overall)178691363.79547085.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.