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 “supercilious” 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
supercilious166452(None) 
superciliously2162352superciliously
supercautious1753923supercautious
superciliary1952643superciliary
supercities15411533superciti_es
superfluous1663163super_fluous
superstitious15175163superstitious
supervisions1755033supervisions
perfidious1653674__perfidious
perilous10310694__per_il_ous
pernicious1445504__pernicious
specious1247484s_pe_c__ious
superalloys1663074super_alloys
superambitious2072504superambitious
supercargoes1753944supercargoes
supercargos1654184supercargo_s
superclass1446624superc_l_ass
superclub1544884superc_l__ub
superclubs1644514superc_l_ubs
supercoiling1754524supercoili_ng
supercoils1487494superc_oi_ls
supercools14106184superc__ools
supercops1547734superc___ops
superficies1846754superfici_es
superhelices1954314superhelices
superhelixes2453624superhelixes
superiors11410954super___iors
superlies11314554super__li_es
supermicros1753754supermicro_s
superminis1448554supermini__s
supernations14410874supernations
superstitions15176784superstitions
supervision1655024supervisio_n
supervisors1653714supervi_sors
suppositious1653044suppositious
tuberculous1561924tubercul_ous

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790368.68614366.8
3Display Results36360.0162250.0
 (SQL Overall)178691368.85820172.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.