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

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

49 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
parajournalisms267135(None) 
parajournalism2571571parajournalism_
journalisms2053474____journalisms
fraternalisms1863795_fra_ternalisms
journalism1953875____journalism_
journalists1853635____journalists
parochialisms2262045par__ochialisms
pastoralisms1654945pa_sto_r_alisms
paternalisms1656085p__a_ternalisms
personalisms1676095per_so__nalisms
photojournalism2981425photojournalism_
amoralisms1447046___amo_r_alisms
atonalisms1247966___ato__nalisms
factionalisms20106366factio__nalisms
fraternalism1784376_fra_ternalism_
gradualisms1552706_gra_du__alisms
irrationalisms1664686irra_tionalisms
journaleses1852106____journaleses
journalist1755006____journalis_t
journalizes27103976____journalizes
manorialisms1664486__mano_rialisms
nationalisms14259796na_tio__nalisms
naturalisms1346506__na_tur_alisms
operationalisms1963716opera_tionalisms
parallelisms1652436para___llelisms
paralogisms1654116paralo____gisms
paramagnetisms2171976para_magnetisms
paramountcies1961466paramou_ntci_es
paranormalities1981786parano_rmalities
paranormality2061756parano_rmali_ty
paranormals1552516parano_rmal___s
paraphernalia2071046paraphernali__a
pararosanilines17111036pararosanilines
parochialism2162186par__ochialism_
particularisms20113766particu_larisms
pastoralism1555796pa_sto_r_alism_
pastoralists1454956pa_sto_r_alists
paternalism1556776p__a_ternalism_
paternalists1456166p__a_ternalists
personalises1476526per_so__nalises
personalism15137396per_so__nalism_
personalists1476506per_so__nalists
phenomenalisms2362946p_henomenalisms
photojournalist2781496photojournalis_t
pictorialisms1984586p_icto_rialisms
pluralisms1445256p____lur_alisms
rationalisms14219486__ra_tionalisms
ruralisms1147356__r___ur_alisms
structuralisms1872226structur_alisms

Search took 8 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.343520965.0
2DLD Change Limit95024496.75014077.6
3Display Results49490.0301633.3
 (SQL Overall)178691497.12325086.5
 
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.