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

94 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
paranormalities198178(None) 
abnormalities1752573_a_bnormalities
paranormality2061753paranormalit__y
lognormalities1761704_lognormalities
normalities13148114____normalities
paranormals1552514paranormal____s
parasexualities2472334parasexualities
parfocalities2053714par_fo_calities
subnormalities1861724_subnormalities
abnormities1553055_a_bnorm__ities
amoralities1347425___amor_alities
animalities1348995___an_imalities
carnalities1348775car_n___alities
corporalities1755295cor_por_alities
corporealities1863205cor_porealities
formalities16137825____formalities
informalities1864295__informalities
paranormal1453895paranormal_____
paranormally1962165paranormal___ly
partialities14108035par___tialities
personalities1556475per_so_nalities
practicalities2053565p_racticalities
primalities1548295p_r___imalities
principalities2083205p_rincipalities
abnormality1852076_a_bnormalit__y
analities9715876___an___alities
anomalies1149286___ano_mal__ies
apriorities1345406apr_ior___ities
arabilities13413106_ara___bilities
atonalities1148406___ato_nalities
auralities10410226___a_ur_alities
banalities1249816__ban___alities
cardinalities1654376car__dinalities
centralities1448626__centr_alities
enormities1246906___enorm__ities
farcicalities2053576far__cicalities
frangibilities2054036_frangibilities
frontalities1555576_fr__ontalities
garrulities1243516gar___r_ulities
generalities1347016__gener_alities
granularities1452986_gran_ularities
horizontalities2771766horizontalities
immaterialities1962876immaterialities
immoralities1655736__immor_alities
immortalities1754206__immortalities
irrationalities1563126irrationalities
irrealities1146216_ir___realities
mammalities1444856__ma__mmalities
marginalities1654326mar__ginalities
materialities1566396__materialities
mayoralties1652466__mayor_al_ties
moralities121111926____mor_alities
mortalities1348426____mortalities
nationalities1356916na_tio_nalities
nodalities11138586____no_dalities
normalcies1443836____normal_cies
normalises12228506____normali_ses
normalizes21259646____normali_zes
oralities91214126_____or_alities
palatabilities1846806pala_tabilities
pancreatitides196946p__ancreatitides
pancreatitis1661886p__ancreatiti_s
pansexualities2362936pa_nsexualities
parajournalisms2671356parajournali_sms
pararosanilines17111036pararo_sanilines
parfocalizes2852836par_fo_cali_zes
paronomasias1662096parono_ma__sias
paronomastic1862766parono_ma_sti_c
partibilities1748096par__tibilities
particularities1993376particularities
patentabilities1995346patentabilities
penalities121313476p__en___alities
performatives2392686per_formati_ves
personalties1485156per_so_nal_ties
planarities1345326p_lan___arities
pluralities1345686p___lur_alities
polytonalities1982746polyto_nalities
potentialities1674206poten_tialities
preformulates2062226p_reformulat_es
printabilities1847326p_rintabilities
priorities1249156p_r_ior___ities
prodigalities1763936p_r_odigalities
profanities1676256p_r__o_fanities
punctualities1753466p__unctualities
rascalities1347226__ra__scalities
rationalities1357286__rationalities
reformabilities2264536__reformabilities
ruralities1048576__r__ur_alities
seasonalities1353576_seaso_nalities
temporalities1753496_tempor_alities
tranquilities2253906_tran_quilities
tranquillities2362466_tranquillities
unmoralities1485566__unmor_alities
unrealities1147536___un_realities

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.360496363.9
2DLD Change Limit95024947.50012669.9
3Display Results94940.0801175.0
 (SQL Overall)178691947.94022505.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.