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

42 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
exceptionalness267123(None) 
exceptionalism27112893exceptional_ism
exceptionalisms28162533exceptionalisms
exceptionable2682374exceptionable__
exceptional2254444exceptional____
exceptionality2872114exceptional_ity
exceptionally2753524exceptional__ly
acceptingness2061735accepti_n_gness
captionless1552505__caption_l_ess
essentialness1363265essenti__alness
exceptionably2972575exceptiona__bly
exceptions2146865exceptio___n__s
rationalness1254465___rationalness
actionless1244156_ac__tion_l_ess
affectionless2161876affection_l_ess
captiousness1647486__captio_usness
criticalness1653506__criti_calness
deceptional1654776deceptional____
deceptiveness2155696decepti__veness
directionless1661936direction_l_ess
effectualness2171936effect__ualness
emotionless1352856e__motion_l_ess
eternalness1153826___e_ternalness
exactingness2252126ex_acti_n_gness
exception2046856exceptio___n___
excerptions2244986excerptio___n__s
excessiveness2554966excessi__veness
executioners2172196executio___ners
expeditiousness2562286expeditio_usness
expressionless2361926expression_l_ess
facetiousness18106076face_tio_usness
fictionalises1855836fic__tionalises
identicalness1662666_identi_calness
licentiousness1654236licentio_usness
perceptional1854906perceptional____
perceptiveness2354786percepti__veness
poeticalness1653456_poe_ti_calness
questionless2152006_question_l_ess
receptiveness2056126recepti__veness
unexceptionable2881886unexceptionable__
unexceptional2462516unexceptional____
verticalness1754216__verti_calness

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.406440125.6
2DLD Change Limit95024429.01310543.0
3Display Results42420.0331272.7
 (SQL Overall)178691429.45218905.1
 
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.