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

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
crestfallenness207601crestfallenness_
crestfallen1651935crestfalle_n____
crestfallenly217835crestfalle_n__ly
creditableness1954346creditable_ness_
restfulness1447236_restf_ul__ness_
acceptableness2263267accept_able_ness_
cravenness1543887cr____a_venness_
creativeness1747767creat__ive_ness_
creatureliness1681137creaturel_iness_
crestless1146787crest___l___ess_
crystalline16154567cryst_all_ine___
crystallises17134197cryst_all_ise_s_
crystallites17143907cryst_all_ite_s_
crystallizers27182897cryst_all_izers_
crystallizes26134107cryst_all_ize_s_
desirableness1666957_desirable_ness_
detailedness1453197_de_t_ailedness_
detestableness1763777detest_able_ness_
estimableness1754757__estimable_ness_
fretfulness1776227fre_tf_ul__ness_
ineffableness2155607ine_ffable_ness_
irritableness1576137irrit_able_ness_
personableness1853967personable_ness_
presentableness1963307presentable_ness_
readableness1576267_re_adable_ness_
reasonableness1663627_reasonable_ness_
rechallenges1851677_re_challenge_s_
reliableness1457137_re_liable_ness_
removableness2054857_removable_ness_
restfullest1454157_restfull___e_st
restfulnesses1646627_restf_ul__nesses
restiveness1449667_rest__ive_ness_
restlessness1146517_rest__lessness_
stableness1248827___st_able_ness_
staleness9310787___st_a_le_ness_
sullenness1054157___s__ullenness_
tractableness1755037tract_able_ness_
tristfulness1564987tristf_ul__ness_
trustfulness1565067trustf_ul__ness_
unstableness1457127_unst_able_ness_
veritableness1856517verit_able_ness_
zestfulness2345317_zestf_ul__ness_

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.360496363.9
2DLD Change Limit95024428.79610803.1
3Display Results42420.0301400.0
 (SQL Overall)178691429.18619452.5
 
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.