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

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

54 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
originality155435(None) 
criminality1855222criminality
originally1445222original_ly
criticality1854213criticality
marginality1754403marginality
original956793original___
originalities1464883originalities
originals1044843original__s
originate1047023origina__te
originating1344903originating
origination1267093origination
originative1553933originative
triviality1644443trivi_ality
aboriginally1851794aboriginal_ly
cardinality1754344cardinality
cordiality1645614cor_di_ality
corrigibility2163314corrigibility
criminalize2455284criminalize
criminally1746194criminal_ly
eligibility1754834eligibility
finality1448344___finality
fragility1645554fragi__lity
frigidity1743004frigi__dity
frugality1653264frug__ality
horizontality2861704horizontality
logicality1644184_logicality
notionality14126234noti_onality
optimality1753354o_ptimality
optionality1654544optionality
orality101111684or____ality
ordinally1346284or_dinal_ly
ordinarily1453114or_dinarily
organicity1654154or_ganicity
originated1244814origina_ted
originates1145964origina_tes
originations13106184originations
originatively2062314originatively
originator1154064origina_tor
originators1253924originators
orthogonality2072214orthogonality
primality1687334pr__imality
principality2162664principality
prodigality18113664prodigality
rationality1458094_rationality
regality1249314_reg__ality
rigidity1345254_rigi__dity
risibility1547544_risibility
triaxiality2162624triaxiality
trigonally1454064trigonal_ly
veridicality2152784veridicality
virginalist15153764virginalist
virginalists16152834virginalists
virginally1743554virginal_ly
virginity1642814virgin__ity

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819548.14018282.4
3Display Results54540.0331636.4
 (SQL Overall)178691548.59620787.7
 
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.