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

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
preternaturally20111061preternaturally_
preternatural1561343preternatura_l__
premenstrually2181285preme_nstrually_
supernaturally1962605_supernaturally_
preferentially2262836preferent_ially_
prenatally1544996pr__e_nat__ally_
antenatally1453047_ante_nat__ally_
connaturally1752897___connaturally_
eternally1247497__etern____ally_
eventually1644587__eve_n_tu_ally_
extramurally2462737__extr_amurally_
fraternally1753497fratern____ally_
interculturally2072327_interculturally_
internationally1873717_internationally_
intramurally1763447_int_r_amurally_
naturally1246527______naturally_
parenterally1752957p_are_n_terally_
paternally1545867p_atern____ally_
perceptually2153067perce__ptu_ally_
perinatally1653447p_e_rinat__ally_
perpetually1853867p___erpetu_ally_
postnatally1652297post__nat__ally_
potentially1656807p_ote_n_t_ially_
prefectural1882807prefe__ctura_l__
premaritally1963207premar_it__ally_
prematurely1852847pr__e_matur_ely_
premenstrual1661877preme_nstrua_l__
preparatorily2091537prepar_ator_ily_
presentably1855287prese_n_t__ably_
presynaptically2771797pre_synaptically_
pretentiously1883787prete_n_tiously_
procedurally2081927proce___durally_
proteolytically2562457proteolytically_
prudentially1854157prude_n_t_ially_
referentially1963527_referent_ially_
reverentially1963277_reverent_ially_
structurally1763087__st_ructurally_
supernatural1453667_supernatura_l__
supernaturalism1992417_supernaturalism
supernaturalist17102627_supernaturalist
supernaturals1572987_supernatura_l_s
texturally2043857___te__xturally_
unnaturally1453347____unnaturally_

Search took 10 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.356501941.0
2DLD Change Limit95024439.02010534.8
3Display Results43430.0301433.3
 (SQL Overall)178691439.40618997.6
 
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.