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

44 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
concatenations187372(None) 
concatenation1764091concatenation_
concatenating1853262concatenati_ng
catenations1348363___catenations
concatenates1654533concatenat__es
consternations16116043con_sternations
contaminations1886103contaminations
contentions13412093con__ten_tions
cancelations1657094canc__elations
catenation1249524___catenation_
concatenate1554404concatenat___e
concatenated1753524concatenat__ed
concelebrations21103164concelebrations
concentrations1877074concentrations
conceptions17410594conc__e_ptions
conciliations1747204conc_iliations
concretions1549294conc_re__tions
concretizations2854034concretizations
condemnations1845404con_demnations
condensations1646274con__densations
condonations1548004con__donations
confabulations2162804confabulations
confederations20104604confederations
confutations1767794confut__ations
congelations1549734con__gelations
conglutinations1862544conglutinations
congratulations1882784congratulations
congregations17186414con_gregations
connations12312944con____nations
connotations1447284connot__ations
considerations1764844considerations
consignations16105934con_signations
constellations1654404con_stellations
consternation15106364con_sternation_
constipations1747684con_stipations
contamination1766954contamination_
contention12412224con__ten_tion_
contentious1347014con__ten_tious
contestations1547734con__testations
continuations1547144con__tinuations
contraventions19103574contraven_tions
conventions16410534con__ven_tions
cunctations1576154cunc_t__ations
incarnations1446664_inca_rnations

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 Limit65874443.12321093.2
3Display Results44440.0162750.0
 (SQL Overall)178691443.45251764.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.