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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
freshest14301058(None) 
freshes133515821freshes_
freshet133416641freshe_t
freshets14298671freshets
brashest133511762brashest
fleshes133913272fleshes_
fleshiest1576222fleshiest
flushest14338552flushest
foresheet1549232foresheet
freest95318282fre__est
freshed143312592freshe_d
freshen133010882freshe_n
freshens14298312freshens
fresher132612642freshe_r
freshness1545942freshness
rashest103916872_rashest
reshes94124362_reshes_
artsiest879653artsiest
behest11314613_be_hest
brashes124518463brashes_
brashiest14359853brashiest
briskest14337803briskest
brushes124014663brushes_
brushiest14297543brushiest
bruskest14315903bruskest
crashes124618403crashes_
crassest103411523crassest
creasiest11229943creasiest
creches14313093creches_
creeshes1336953creeshes_
crepiest12310383crepiest
crescent12711053crescent
cresses94219813cresses_
cresset93319943cresse_t
cressets10309103cressets
crispest12177373crispest
crossest1012012123crossest
crushes124215133crushes_
dresses83716173dresses_
dressiest1036823dressiest
falsest10310013fals_est
farthest1499863farthest
fashes124524023f_ashes_
fastest102413723f_astest
featest102715113f_eatest
feeblest1336913feeblest
fellest10313753f_ellest
ferniest1132214153ferniest
fesses94820253f_esses_
fewest12311663f_e_west
feyest12311403f_e_yest
fiercest13216143fiercest
fieriest112112243fieriest
fishes125221343f_ishes_
fishiest14310453f_ishiest
flashes133916103flashes_
flashiest1557983flashiest
fleches153411443fleches_
fleetest1136723fleetest
fleshed143210263fleshe_d
flesher133610923fleshe_r
fleshers14339443fleshers
fleshless1543993fleshless
fleshliest1642653fleshliest
fleshment1745503fleshment
fleshpot1643843fleshpot
flushes134114143flushes_
flysheet1745113flysheet
foresees11311643foresees_
foresheets1654603foresheets
frailest1139493frailest
frankest1536963frankest
frasses104314513frasses_
freakiest16206693freakiest
freeness11710443freeness
frees86131393fre__es_
freezes193310353freezes_
frenches163311633frenches_
frequent2046423frequent
freres94716173fre_res_
frescoes1357833frescoes_
frescoist1444123frescoist
frescos1236813frescos_
fresh115012203fresh___
freshened1645253freshened
freshener1544853freshener
freshing152611023freshing
freshly16286833fresh_ly
freshman1644623freshman
freshmen1656023freshmen
fresnel1035893fresne_l
fresnels1135233fresnels
fretless1138063fretless
frettiest1267063frettiest
frisees104411693frisees_
frises94124273fris_es_
frisket143811773friske_t
friskets15326263friskets
friskiest1636233friskiest
frostiest1239213frostiest
frothiest1537453frothiest
frowsiest1535063frowsiest
fubsiest13258413fubsiest
furthest1496863furthest
fussiest112910493fussiest
gashest114813413_gashest
greasiest10208563greasiest
greatest939863greatest
greenest9312623greenest
greyest11348343gre_yest
grossest93810093grossest
harshest14310193harshest
lushest103312283_lushest
meshes115019443_meshes_
meshiest132911033_meshiest
plushest13328283plushest
poshest12312423_poshest
preheat12413893pre_heat
present94022733pres_ent
preset84430983pres_e_t
presets94216423pres_ets
presses93523153presses_
pretest9517633pre_test
prosiest10416523prosiest
rashes95330153_rashes_
realest73322433_realest
recheat12415933_recheat
reddest9311953_reddest
reest54938093_re__est
refreshes1595953refreshes_
reheat94423943_re_heat
renest64529713_re_nest
request16311023_request
reseat64131493_res_eat
resect84424703_res_ect
resees63827483_resees_
resent63833623_res_ent
reset55051863_res_e_t
resets65427613_res_ets
reshoes102316033_reshoes_
reshoot102513893_reshoot
reshot93519633_resh_ot
resist64524533_res_ist
resmelt9411773_resmelt
respect11412033_respect
respelt9312143_respelt
retest64028453_re_test
revest94623603_re_vest
richest122813683_richest
rosiest73919213_rosiest
rushes94724363_rushes_
rushiest113312923_rushiest
tersest71713993ters_est
threshes1437383threshes_
trashes104119263trashes_
trashiest123110633trashiest
tresses73719543tresses_
tressiest937883tressiest

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621586.83021400.0
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.31324434.7
 
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.