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

50 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
parajournalisms2671351parajournalisms_
parajournalism2571572parajournalism__
journalisms2053475____journalisms_
fraternalisms1863796_fra_ternalisms_
journalism1953876____journalism__
journalists1853636____journalists_
paraphernalia2071046paraphernali___a
parochialisms2262046par__ochialisms_
pastoralisms1654956pa_sto_r_alisms_
paternalisms1656086p__a_ternalisms_
personalisms1676096per_so__nalisms_
photojournalism2981426photojournalism__
amoralisms1447047___amo_r_alisms_
atonalisms1247967___ato__nalisms_
factionalisms20106367factio__nalisms_
fraternalism1784377_fra_ternalism__
gradualisms1552707_gra_du__alisms_
irrationalisms1664687irra_tionalisms_
journaleses1852107____journaleses_
journalist1755007____journali__st
journalistic2152777____journalistic
journalizes27103977____journalizes_
manorialisms1664487__mano_rialisms_
nationalisms14259797na_tio__nalisms_
naturalisms1346507__na_tur_alisms_
operationalisms1963717opera_tionalisms_
parallelisms1652447para___llelisms_
paralogisms1654127paralo____gisms_
paramagnetisms2171977para_magnetisms_
paramountcies1961467paramou_ntci_es_
paranormalities1981787parano_rmalities
paranormality2061757parano_rmali__ty
paranormals1552527parano_rmal___s_
pararosanilines17111037pararosanilines_
parochialism2162187par__ochialism__
particularisms20113777particu_larisms_
pastoralism1555807pa_sto_r_alism__
pastoralists1454957pa_sto_r_alists_
paternalism1556777p__a_ternalism__
paternalists1456167p__a_ternalists_
personalises1476527per_so__nalises_
personalism15137397per_so__nalism__
personalists1476507per_so__nalists_
phenomenalisms2362947p_henomenalisms_
photojournalist2781497photojournali__st
pictorialisms1984587p_icto_rialisms_
pluralisms1445257p____lur_alisms_
rationalisms14219497__ra_tionalisms_
ruralisms1147357__r___ur_alisms_
structuralisms1872227structur_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 Filter178691950240.373479064.3
2DLD Change Limit95024508.82610766.4
3Display Results50500.0501000.0
 (SQL Overall)178691509.24919320.0
 
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.