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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
pictorialness176252(None) 
pictorialnesses1962142pictorialnesses
dictatorialness1871043dictatorialness
historicalness1962133historicalness
pastoralness1453603pastor_alness
pictorialism1864953pictorial_ism
pictorialisms1984583pictorialisms
pictorialist1675373pictorial_ist
pictorialists1774113pictorialists
pictorializes2653453pictorializes
pictorials1445493pictorial___s
cordialness1444774__c_ordialness
literalness1145494li_ter_alness
materialness1454664_materialness
pictorial1348404pictorial____
pictorialize2553584pictorial_ize
pictorialized2753024pictorialized
pictorially1854814pictorial__ly
victoriousness1963914victoriousness
colonialness1453465_colonialness
corporealness1762015corporealness
diabolicalness1971295diabolicalness
dilatoriness1352605dilatori__ness
doctorless1342585doctor__l_ess
eternalness1153825__eternalness
factorials1544705factorial___s
factualness1652995fact__ualness
fictiveness1946315fict__iveness
formalness1544835___formalness
historians13106305historia_n__s
illogicalness1662145_illogicalness
initialness1155735_i_nitialness
ironicalness1463085_i_ronicalness
jitteriness1843275jitteri__ness
liberalness1354515li_ber_alness
lickerishness2261415lickerishness
lictorian1166615lictoria_n___
mercurialness1761675mercurialness
naturalness1153955_natur_alness
neutralness1154375neut_r_alness
palatialness1453235p_alatialness
paltriness1244995palt_ri__ness
pastorales1247145pastor_al_e_s
pastoralnesses1653135pastor_alnesses
pectorals13128155pector_al___s
picholines1746305picholi__ne_s
pickiness1737625pic__ki__ness
picolines1339625pic_oli__ne_s
pictorializing2863185pictorializing
picturizes2344565picturi__ze_s
pithiness1437565pi_t_hi__ness
pitiableness1655525pi_t__iableness
pitifulness1665485pi_t_ifulness
pitiless10127335pi_t__i_l_ess
pityriases1552315pi_tyria_se_s
poeticalness1653455poet_icalness
practicalness1953325pract_icalness
pretorians1258315pretoria_n__s
sectorials1286525sectorial___s
specialness1554055spec___ialness
suctorians12114725suctoria_n__s
victimless1751815vict__iml_ess
victorias1446525victoria____s
victories1448925victori___e_s
vitalness1245415vi_t___alness
wintriness1345545wint_ri__ness

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.390458182.1
2DLD Change Limit124790668.37614898.5
3Display Results66660.0461434.8
 (SQL Overall)178691668.81220278.1
 
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.