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

86 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
freshness154594(None) 
brashness1436322brashness
fleshiness16104292fleshiness
fleshless1543992fleshless
flushness1544892flushness
freeness11710442fre_eness
fresheners1643862fresheners
freshens14298312fresh_ens
freshes133515822fresh_e_s
freshest143010582fresh_est
freshets14298672fresh_ets
freshnesses1746102freshnesses
fresnels1135232fres_nels
rashness1138092_rashness
apishness1445743apishness
archness1337513ar_chness
artsiness937653artsiness
briskness1544763briskness
brushless1444003brushless
crassness1136213crassness
crestless1146783crestless
crispness1345303crispness
crossness1137093crossness
dressiness1145543dressiness
erectness1146123erectness
falseness1236093falseness
fastness11238763f_astness
fellness1135913f_ellness
fewness1335003f_e_wness
feyness1334923f_e_yness
fieriness1238623fieriness
firstness1245013firstness
fishiness1537343f_ishiness
fishless1436413f_ishless
fishnets1445633f_ishnets
flashiness16105283flashiness
fleetness1244753fleetness
fleshers14339443flesh_ers
fleshes133913273flesh_e_s
fleshiest1576233fleshiest
foresheets1654603foresheets
frailness1236543frailness
frankness1655223frankness
freakiness1745183freakiness
freakishness2252473freakishness
frescoers1454563frescoers
frescoes1357833frescoe_s
freshed143312593fresh_e_d
freshen133010883fresh_e_n
freshened1645253freshened
freshener1544853freshener
fresher132612643fresh_e_r
freshet133416643fresh_e_t
freshmen1656023freshme_n
fresnel1035893fres_ne_l
fretless1138063fre_tless
friskiness1744453friskiness
frostiness1336563frostiness
frostless1235743frostless
frothiness1645723frothiness
fussiness12226583fussiness
garishness1445743garishness
greasiness1156543greasiness
greatness1036903greatness
greenness1046793greenness
greyness1235243gre_yness
grossness1045963grossness
harshness1545963harshness
lushness1136233_lushness
obeseness1145893obeseness
offishness1943793offishness
plushness1444623plushness
poshness1356653_poshness
prestress1138133prestress
prosiness11311683prosiness
realness8410443_realness
redness82012443_re_dness
reshes94124363_resh_e_s
reshines112615443_reshine_s
reshoes102316033_reshoe_s
restless82713163_restless
restress82511773_restress
richness1337433_richness
rosiness82613173_rosiness
terseness948403terseness
trashiness1346443trashiness

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 Filter1786911486410.423422437.4
2DLD Change Limit148641867.75019179.5
3Display Results86860.0801075.0
 (SQL Overall)178691868.25321651.6
 
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.