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 “crestfallenness” 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
crestfallenness20760(None) 
crestfallen1651924crestfalle_n___
crestfallenly217834crestfalle_n_ly
creditableness1954345creditable_ness
restfulness1447235_restf_ul__ness
acceptableness2263266accept_able_ness
cravenness1543876cr____a_venness
creativeness1747766creat__ive_ness
creatureliness1681136creaturel_iness
crestless1146786crest___l___ess
crystalline16154566cryst_all_ine__
crystallises17134196cryst_all_ise_s
crystallites17143906cryst_all_ite_s
crystallizers27182896cryst_all_izers
crystallizes26134106cryst_all_ize_s
desirableness1666956_desirable_ness
detailedness1453196_de_t_ailedness
detestableness1763776detest_able_ness
estimableness1754756__estimable_ness
fretfulness1776226fre_tf_ul__ness
ineffableness2155606ine_ffable_ness
irritableness1576136irrit_able_ness
personableness1853966personable_ness
presentableness1963306presentable_ness
readableness1576266_re_adable_ness
reasonableness1663626_reasonable_ness
rechallenges1851676_re_challenge_s
reliableness1457136_re_liable_ness
removableness2054856_removable_ness
restfullest1454136_restfull___est
restfulnesses1646626_restfulnesse_s
restiveness1449666_rest__ive_ness
restlessness1146516_rest__lessness
stableness1248826___st_able_ness
staleness9310786___st_a_le_ness
sullenness1054156___s__ullenness
tractableness1755036tract_able_ness
tristfulness1564986tristf_ul__ness
trustfulness1565066trustf_ul__ness
unstableness1457126_unst_able_ness
veritableness1856516verit_able_ness
zestfulness2345316_zestf_ul__ness

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.1261418182.5
2DLD Change Limit95024427.82612142.1
3Display Results42420.0331272.7
 (SQL Overall)178691427.98522378.3
 
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.