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

50 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
supercalendered219113(None) 
supercalender18122872supercalender__
supercalenders19122382supercalender_s
calendered1443395_____calendered
superceded1676255superc__e_d__ed
supercenter1547115superc__enter__
supercenters1655765superc__enter_s
supercollider1862295supercollider__
supercolliders1961645supercollider_s
superhardened2062555superha__rdened
superintended1763055superintend__ed
surrendered1361575su__r__rendered
calendared1442596_____calendared
calenderer1342986_____calenderer
superableness17127526superablen_e_ss
superablenesses1964906superablenesses
superabounded1961936superabound__ed
superadded1544986super_a___d_ded
superagencies1854746super_agen_cies
superaltern1354746super_al__ter_n
superalterns1453886super_al__terns
superannuated1683256super_a_nnuated
supercabinet1855966supercabin___et
supercabinets1953856supercabin_e_ts
supercarrier1663606superca_rrier__
supercarriers1763106superca_rrier_s
supercede1478486superc__e_d__e_
supercedes1578456superc__e_d__es
supercluster1663506superc_luster__
superclusters1752796superc_luster_s
superconducted2272626superc__onducted
superelevated1972146super_ele_vated
superinduced1853116super___induced
superintendence2072296superintendence
superintendency2372086superintendency
superintendent1773696superintende_nt
superintendents1872556superintendents
superliner1249206super__lin_er__
superliners1347386super__lin_er_s
superpowered2052276super___powered
supersalesmen1761946supersale__smen
superseded1466936super__se_d__ed
superseder1377346super__se_der__
superseders1476386super__se_der_s
supersedure1454696super__se_dure_
supersedures1564496super__se_dures
supertanker17104526superta__nker__
supertankers18113726superta__nker_s
supervened1676876super__ven___ed
suspendered1552046su____spendered

Search took 9 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 Filter178691950240.360496363.9
2DLD Change Limit95024508.19011602.4
3Display Results50500.0301666.7
 (SQL Overall)178691508.58020826.5
 
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.