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

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
parochialisms226204(None) 
parochialism2162181parochialism_
archaisms1646074_ar_ch_a_isms
biracialisms1853584birac_ialisms
manorialisms1664484mano_rialisms
parochial1646184parochial____
parochially2153184parochial__ly
racialisms1447224__rac_ialisms
socialisms1447644__soc_ialisms
adoptianisms1752615_adoptianisms
alcoholisms1852495_alcoh_olisms
amoralisms1447045_amo__ralisms
archaises1448405_ar_ch_a_ises
archaism1547105_ar_ch_a_ism_
archaists1446585_ar_ch_a_ists
archivists1853915_ar_chi_vists
atonalisms1247965_ato__nalisms
barbarianisms1982335barbarianisms
biracialism1753965birac_ialism_
colonialisms1674755colo_nialisms
factualisms1853535fa__ctualisms
localisms13148735__loc__alisms
manorialism1574985mano_rialism_
masochisms1953505masoch___isms
materialisms1657305ma_terialisms
narcissisms1551805nar_c_issisms
necrophilisms2272725necrophi_lisms
officialisms2262315offic_ialisms
pachalics1844985pa__ch_ali_cs
pacifisms1845095pa__c_i_fisms
parachutists1952415parach_utists
parajournalisms2671355parajournalisms
parallelisms1652435par_allelisms
parasitisms1575505par_asi_tisms
parchisis16318575par_ch___isis
parecisms1547165parec____isms
parfocalizes2852835parfoc__alizes
parotitises1346425paro_ti_tises
particularisms20113765particularisms
pastoralisms1654945pa_storalisms
paternalisms1656085pa_ternalisms
personalisms1676095per_sonalisms
pictorialisms1984585pictorialisms
pleochroisms2162025pleoch_roisms
priapisms1545465p_r___iapisms
probabilisms2062285p_robabilisms
proclaims1545075p_roc_la_i_ms
proclises1339545p_roc___lises
proclisis1346775p_roc___lisis
proctitises15106325p_rocti_tises
prosaisms1346275p_ro__sa_isms
prostatisms1555865p_ro_statisms
provincialisms23102225p_rovincialisms
racialism1348335__rac_ialism_
racialists1247705__rac_ialists
radicalisms1644875radic__alisms
royalisms14127265__ro__yalisms
serialisms12610275ser___ialisms
socialises1258255__soc_ialises
socialism1348665__soc_ialism_
socialists1248495__soc_ialists
specialisms1745975_spec_ialisms
troilisms1146415_tro__i_lisms
vocalisms16138055__voc__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 Limit124790648.86014084.7
3Display Results64640.0331939.4
 (SQL Overall)178691649.29919216.2
 
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.