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

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

57 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
freshened164525(None) 
freshener1544851freshener
freshed143312592fresh__ed
freshen133010882freshen__
fresheners1643862fresheners
freshens14298312freshen_s
refreshened1852462refreshened
reshined123011122_reshined
crispened1443613crispened
fastened12257853f_astened
festered122512103f_estered
flehmened1841773flehmened
fleshed143210263flesh__ed
foresheet1549233foreshe_et
foreshowed2044063foreshowed
freehand1574993freehan_d
freehanded1843403freehanded
frequented2343423frequented
frescoed1436053fres_coed
freshening1744773freshening
fresher132612643fresh__er
freshes133515823fresh__es
freshest143010583freshe_st
freshet133416643fresh__et
freshets14298673freshe_ts
freshing152611023freshin_g
freshmen1656023fresh_men
freshness1545943freshness
fresnel1035893fres__nel
frightened1843243frightened
greatened1144583greatened
greened93111263gre__ened
harshened1644453harshened
lessened935093_lessened
preened103214993pre__ened
presented12311633pres_ented
preshaped1745523preshaped
preshowed1875183preshowed
rechewed1735633_rechewed
reddened1136423_reddened
reopened1138513_reopened
reseed74823293_res_e_ed
reseeded1038093_reseeded
resend75016773_res_en_d
resented92716963_res_ented
resewed113011823_res_ewed
reshaped1437203_reshaped
reshaved1536873_reshaved
reshine102816943_reshine_
reshines112615443_reshines
reshoed112212153_resh_oed
reshone102414163_reshone_
reshowed15117063_reshowed
resigned1038863_resigned
resined84522653_res_ined
richened1435953_richened
trephined1544903trephined

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 Filter1786911486410.423422437.4
2DLD Change Limit148641576.81321817.3
3Display Results57570.0134384.6
 (SQL Overall)178691577.24924650.4
 
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.