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

64 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
authoritatively2471201authoritatively_
authoritative1961983authoritative___
assortatively1962325a_ssor_tatively_
hortatively2054055___hor_tatively_
alternatively1952726alt_er_natively_
associatively2162376a_ssoci_atively_
attributively2161816a_t_tributively_
authoritarian16112476authoritari___an
authoritarians17102526authoritari__ans
authorities1446336authori__ti_e__s
authorization2555856authorizati___on
authorizations2655096authorizati__ons
exploitatively2961676explo_itatively_
nutritively1753876nut__ri__tively_
qualitatively2862096qu__alitatively_
quantitatively29101456qu_antitatively_
abortively1844347a__bor___tively_
adumbratively2462057adumbr__atively_
adversatively2352277a_dver_satively_
affirmatively2761817a_ffir_matively_
aggregatively2262137a__ggregatively_
applicatively2562547a__pplicatively_
appositively2252767a_pposi__tively_
appreciatively2672307appreci_atively_
argumentatively2481157argumentatively_
assortative1473957a_ssor_tative___
attractively2053587a_t_tr_actively_
authorial1247087authori_a____l__
authority1545697authori__t____y_
autorotate1054827aut_orotat__e___
autorotated1253487aut_orotat__e__d
autorotates1154707aut_orotat__e__s
autorotating1373847aut_orotati___ng
autorotation1255017aut_orotati___on
autorotations1354557aut_orotati__ons
connotatively21102687conno__tatively_
curatively1845737cu___r__atively_
decoratively2154447_decor__atively_
derivatively2264317___derivatively_
exhortative2453057_exhor_tative___
exploratively2862427explor__atively_
formatively2254527___for_matively_
hortative1546437___hor_tative___
imitatively1954257____imitatively_
inchoatively2353037incho___atively_
informatively2453297_infor_matively_
interrogatively2271967interrogatively_
iteratively1745917_it_er__atively_
lucratively1984017lu__cr__atively_
meditatively2153567___meditatively_
normatively1954637___nor_matively_
optatively1864647____o_ptatively_
oxidatively2553067____oxidatively_
pejoratively2753677_pejor__atively_
privatively2245087____privatively_
putatively1845067pu_____tatively_
retributively2162327ret__ributively_
rotatively1645407_____rotatively_
ruminatively2053487ru___minatively_
substitutively22121607su_bstitutively_
superlatively2174057su_per_latively_
tentatively1754347__t__entatively_
terminatively2153177__terminatively_
unhesitatingly21101657_unhesitatingly_

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.360496363.9
2DLD Change Limit95024649.48310020.5
3Display Results64640.0461391.3
 (SQL Overall)178691649.88918069.7
 
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.