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

160 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
freshens1429831(None) 
freshen133010881freshen_
freshes133515821freshe_s
freshets14298671freshets
fleshers14339442fleshers
fleshes133913272fleshe_s
freshed143312592freshe_d
freshened1645252freshened
freshener1544852freshener
fresheners1643862fresheners
fresher132612642freshe_r
freshest143010582freshest
freshet133416642freshe_t
freshing152611022freshing
freshmen1656022freshmen_
freshness1545942freshness
fresnels1135232fresnels
greyhens1542632greyhens
refreshens16113992refreshens
reshes94124362_reshe_s
arshins10312573ar_shins
brashes124518463brashe_s
brechans1547413brechans
brushers134210573brushers
brushes124014663brushe_s
crashers134013233crashers
crashes124618403crashe_s
creches14313093creche_s
creeshes1336953creeshe_s
crescent12711053crescent
crescents1367543crescents
cresses94219813cresse_s
cressets10309103cressets
crispens12286253crispens
crushers134010093crushers
crushes124215133crushe_s
dressers9359863dressers
dresses83716173dresse_s
fashes124524023f_ashe_s
fastens105511753f_astens
fesses94820253f_esse_s
festers104121393f_esters
fireships1746023fireships
fishers134714723f_ishers
fishes125221343f_ishe_s
flashers143912653flashers
flashes133916103flashe_s
fleches153411443fleche_s
flehmens1643233flehmens
fleshed143210263fleshe_d
flesher133610923fleshe_r
fleshing15339303fleshing
fleshings16335383fleshings
fleshless1543993fleshless
fleshment1745503fleshment
fleshments1843853fleshments
flushers14279733flushers
flushes134114143flushe_s
foehns12204973foe_h_ns
foreseen1139103foreseen_
foreseers1237403foreseers
foresees11311643fores_ees
foreshank1944673foreshank
foreshanks2043833foreshanks
foresheet1549233foresheet
foresheets1654603foresheets
foreshows1875973foreshows
foreskins1647043foreskins
foresters12312533foresters
frasses104314513frasse_s
freebees1345353freebees
freehand1574993freehand
freemen1238463freemen_
freeness11710443freeness
freers94717303fre__ers
frees86131393fre__e_s
freezers20307173freezers
freezes193310353freeze_s
frenches163311633frenche_s
frequent2046423frequent
frequents2144443frequents
freres94716173fre_re_s
frescoers1454563frescoers
frescoes1357833frescoes
frescos1236813fres_cos
fresh115012203fresh___
freshening1744773freshening
freshly16286833fresh_ly
freshman1644623freshman
fresnel1035893fresne_l
fretless1138063fretless
fretters113410303fretters
frightens1655393frightens
frisbees13295013frisbees
frisees104411693fris_ees
frises94124273fris_e_s
friskers15337373friskers
friskets15326263friskets
frissons1145043frissons
frosteds12305653frosteds
frothers14279813frothers
greatens9307593greatens
greens75716873gre__ens
greisens954653greisens
greyhen1443193greyhen_
harshens1437603harshens
lessens7409383_lessens
meshes115019443_meshe_s
peahens12307573_peahens
preens85020113pre__ens
present94022733pres_ent
presents103315643pres_ents
presets94216423pres_ets
preships1539313preships
preshows16267023preshows
pressers103215023pressers
presses93523153presse_s
presters103419003presters
preteens1038123preteens
rashers104020913_rashers
rashes95330153_rashe_s
rechews1537293_rechews
reddens9259783_reddens
refreshen1585163refreshen_
refreshers16103673refreshers
refreshes1595953refreshe_s
rehems113410983_re_hems
reopens939373_reopens
reseeds84012333_reseeds
reseeks11348623_reseeks
reseen64318413_reseen_
resees63827483_res_ees
resend75016773_res_end
resends83513713_res_ends
resent63833623_res_ent
resents74221223_res_ents
resets65427613_res_ets
resews94814173_res_ews
reshine102816943_reshine
reshines112615443_reshines
reships1239863_reships
reshoes102316033_reshoes
reshone102414163_reshone
reshows132510453_reshows
resigns83910963_resigns
resins64528773_res_ins
resters74130403_resters
richens12349733_richens
rushees103311953_rushees
rushers103816103_rushers
rushes94724363_rushe_s
threshers1545423threshers
threshes1437383threshe_s
trashers113013643trashers
trashes104119263trashe_s
treens65317873tre__ens
tressels8367653tressels
tresses73719543tresse_s
urethans1145243urethans
wresters112711733wresters

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.423422437.4
2DLD Change Limit1461621607.21620255.3
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.70223200.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.