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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
pictorialisms198458(None) 
pictorialism1864951pictorialism_
pictorialists1774111pictorialists
pictorialist1675372pictorialis_t
pictorializes2653452pictorializes
pastoralisms1654943pastor_alisms
pictorialize2553583pictoriali_ze
pictorialized2753023pictorialized
pictorialness1762523pictorialness
pictorials1445493pictorial___s
editorialists1463414editorialists
historicisms1953074histori_cisms
immoralisms1454634_immor_alisms
imperialisms18105904_imperialisms
literalisms1357704li_ter_alisms
manorialisms1664484_manorialisms
materialisms1657304_materialisms
pastoralism1555794pastor_alism_
pastoralists1454954pastor_alists
paternalisms1656084p_aternalisms
pictorial1348404pictorial____
pictorializing2863184pictorializing
pictorially1854814pictorial__ly
pictorialnesses1962144pictorialnesses
sectarianisms17203684sectarianisms
amoralisms1447045__amor_alisms
antirealisms1477135_antirealisms
atonalisms1247965__ato_nalisms
bicameralisms2162465bicameralisms
biculturalisms2071915bicultur_alisms
bilateralisms1763315bilater_alisms
biracialisms1853585bi_racialisms
centralisms1547405cent_r_alisms
clericalisms1893975__clericalisms
colonialisms1674755_colonialisms
dichromatisms2362615dichromatisms
editorialist1364655editorialis_t
editorializes2353775editorializes
epicureanisms1961535epic_ureanisms
externalisms2154955_externalisms
factionalisms20106365factionalisms
factorials1544695factorial___s
factualisms1853535fact__ualisms
fictionalises1855835fictionalises
formalisms17227245___formalisms
fraternalisms1863795fraternalisms
gutturalisms1552265guttur_alisms
historicism1853415histori_cism_
historicists1752655histori_cists
immaterialisms1793835immaterialisms
immobilisms1652655_immobi_lisms
immoralism1355175_immor_alism_
immoralists1554765_immor_alists
immortalises1693935_immortalises
imperialism17106935_imperialism_
imperialists16105405_imperialists
initialisms1356145_i_nitialisms
internalises12149115_internalises
liberalisms1546205li_ber_alisms
literalism1248855li_ter_alism_
literalists1148075li_ter_alists
manorialism1574985_manorialism_
materialises1447325_materialises
materialism1548265_materialism_
materialists1456985_materialists
memorialises1655545_memorialises
memorialists1654665_memorialists
microorganisms2181525microorganisms
moralisms13410295___mor_alisms
naturalisms1346505_natur_alisms
neorealisms1374885__neorealisms
neutralisms13116465neut_r_alisms
oralisms10610975____or_alisms
parochialisms2262045parochialisms
pastoralist1357465pastor_alis_t
paternalism1556775p_aternalism_
paternalists1456165p_aternalists
patriotisms1553815p_at_riotisms
pectorals13128155pector_al___s
personalisms1676095perso_nalisms
piclorams1544165piclor_a___ms
picornavirus1961195pic_ornavirus
pictograms1744625pictogra___ms
picturizations2764685picturizations
pityriases1552315pi_tyria__ses
pityriasis1552255pi_tyria__sis
pluralisms1445255p__lur_alisms
pointillisms1662565point__illisms
priapisms1545465p____riapisms
ptyalisms1685305p__t__yalisms
puerilisms1444375p__ueri_lisms
racialisms1447225rac___ialisms
ritualisms1246005ri_t__ualisms
sectarianism16173845sectarianism_
sectionalisms1756525sectionalisms
sectorials1286525sectorial___s
serialisms12610275___serialisms
socialisms1447645___socialisms
specialisms1745975spec___ialisms
teetotalisms14153835teeto_talisms
territorialisms1772735territorialisms
totalisms1139815___to_talisms
triadisms1246455___t_riadisms
tribalisms1446515___t_ribalisms
troilisms1146415___troi_lisms
unitarianisms1563915unitarianisms
utopianisms1552705__utopianisms
victorias1446525victoria____s
virilisms1446245vi___ri_lisms
vitalisms1448515vi_t___alisms

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901109.31313399.5
3Display Results1101100.0601833.3
 (SQL Overall)1786911109.77918272.9
 
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.