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

427 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
fresher13261264(None) 
flesher133610921flesher
freshed143312591freshed
freshen133010881freshen
freshes133515821freshes
freshet133416641freshet
brasher124515242brasher
brusher123813002brusher
crasher124616162crasher
crusher124412322crusher
dresser83611952dresser
fester94723512f_ester
fisher124917142f_isher
flasher133914062flasher
fleshed143210262fleshed
fleshers14339442fleshers
fleshes133913272fleshes
fleshier1435602fleshier
flusher133012272flusher
foreseer1139012foreseer
forester11313672forester
freer86021242fre__er
freezer19348522freezer
frescoer1345982frescoer
fresh115012202fresh__
freshener1544852freshener
freshens14298312freshens
freshest143010582freshest
freshets14298672freshets
freshly16286832freshly
freshmen1656022freshmen
fresnel1035892fresnel
fretter103412752fretter
frisker14389272frisker
frother133110152frother
presser93717622presser
prester93519622prester
rasher95024122_rasher
refresher15104652refresher
reshes94124362_reshes
rester63832432_rester
rusher94019652_rusher
thresher1455822thresher
trasher104416132trasher
wrester102812412wrester
aether94213673_aether
afresh1255503afresh__
archer115016243ar_cher
arrester839253arrester
artsier768943artsier
basher115123813_basher
blesser9329293blesser
blether12459913blether
blusher124113113blusher
brashes124518463brashes
brashier13389933brashier
brasier94516753brasier
breacher153011503breacher
breaker133912923breaker
breather133610593breather
breeder103210043breeder
brevier1237763brevier
brewer114812543bre_wer
brisker134210293brisker
brother123311333brother
brushed133811213brushed
brushers134210573brushers
brushes124014663brushes
brushier13306973brushier
brusker13437853brusker
busher114922203_busher
caresser1038803caresser
clasher124615513clasher
cosher114819903_cosher
crashed134214203crashed
crashers134013233crashers
crashes124618403crashes
crasser94114333crasser
creamer113714083creamer
creaser94415723creaser
creasier103210193creasier
creche13310763creche_
creches14313093creches
creeper11339973creeper
creeshed1435693creeshed
creeshes1336953creeshes
crepier1139733crepier
cresses94219813cresses
cresset93319943cresset
crested103416533crested
crisper113511053crisper
crosier94116573crosier
crosser95015463crosser
crushed134111963crushed
crushers134010093crushers
crushes124215133crushes
dasher104318983_dasher
diester83013683diester
diether1147443diether
dreamer104110843dreamer
dredger10347443dredger
drencher14257213drencher
dressed93511873dressed
dressers9359863dressers
dresses83716173dresses
dressier956863dressier
eraser64216333eras_er
erecter93113393erecter
esker94412983__esker
ester54727713__ester
ether84518773__ether
falser93912413fals_er
farther1348343farther
fashed136720253f_ashed
fashes124524023f_ashes
faster94625773f_aster
father125116713f_ather
fearer94820183f_earer
feaster10812983feaster
feater95224053f_eater
feather133613503feather
feebler1235823feebler
feeder103513843f_eeder
feeler93215173f_eeler
feldsher1543243feldsher
feller94419553f_eller
fencer114613533f_encer
fender103718723f_ender
fernier103110823fernier
fesse86116333f_esse_
fessed104515063f_essed
fesses94820253f_esses
festers104121393f_esters
fetcher153510393fetcher
fetter94120383f_etter
fever115617953f_e_ver
fewer115216123f_e_wer
feyer115014523f_e_yer
fibster12146533fibster
fielder11217413fielder
fiercer12356953fiercer
fierier103511193fierier
filcher15377793filcher
finisher1436303finisher
fireship1646233fireship
fished134316313f_ished
fishers134714723f_ishers
fishery16397733f_ishery
fishes125221343f_ishes
fishier13359853f_ishier
flashed144112183flashed
flashers143912653flashers
flashes133916103flashes
flashier1437103flashier
fleche14299303fleche_
fleches153411443fleches
fleecer12368033fleecer
fleer86020773fle__er
fleeter103210363fleeter
flenser1036783flenser
flesh115013743flesh__
fleshlier1542493fleshlier
fleshly16346093fleshly
fleshy15406283flesh_y
fletcher16306663fletcher
flosser10339693flosser
flushed143310973flushed
flushers14279733flushers
flushes134114143flushes
fluster103913063fluster
foregoer1237253foregoer
foresee10414333fores_ee
foreseen1139103foreseen
foreseers1237403foreseers
foresees11311643foresees
foresheet1549233foresheet
foreshore15118203foreshore
foreshow1785893foreshow
forested12312463forested
foresters12312533foresters
foreswear1543513foreswear
forever1338953fore_ver
foster94322223f_oster
frailer10319943frailer
framer114817443fr_amer
franker143510183franker
frasses104314513frasses
frater94520593fr_ater
freaked15399703freaked
freakier15246483freakier
free75940183fre__e_
freebee1238043freebee
freed95223543fre__ed
freemen1238463freemen
freers94717303fre__ers
frees86131393fre__es
freeze18349513freeze_
freezers20307173freezers
freezes193310353freezes
freighter1655023freighter
frenched17299433frenched
frenches163311633frenches
frere85617723fre_re_
freres94716173fre_res
fresco1136473fres_co
frescoed1436053frescoed
frescoers1454563frescoers
frescoes1357833frescoes
frescos1236813frescos
freshened1645253freshened
fresheners1643863fresheners
freshing152611023freshing
freshman1644623freshman
freshness1545943freshness
freshwater1942533freshwater
fresnels1135233fresnels
fretted113411853fretted
fretters113410303fretters
frettier1156593frettier
frier85225843fr__ier
friller104111743friller
frisbee12298513frisbee
frise85322453fris_e_
frisee94217993fris_ee
frisees104411693frisees
frises94124273fris_es
friseur1033673friseur
frisked15478823frisked
friskers15337373friskers
frisket143811773frisket
friskier1535193friskier
fritter103912773fritter
frizer184011283fr_izer
frizzer18446893frizzer
fronter103611583fronter
frosh115713403frosh__
frosted113211873frosted
frostier1148163frostier
frothed14288783frothed
frothers14279813frothers
frothier1435953frothier
frowner13429683frowner
frowsier1444893frowsier
fruiter10309683fruiter
fryer115913433fr__yer
fubsier12367763fubsier
fuehrer1332973fuehrer
fueler94313933fue_ler
fueller10279963fueller
furbisher1743703furbisher
furnisher1544523furnisher
further1337003further
fusser94813773f_usser
fussier103610673fussier
gasher104320373_gasher
grasper10389793grasper
greaser83913083greaser
greasier9298083greasier
greater84416493greater
greener83111713greener
greeter82812673greeter
greyer104510093gre_yer
greyhen1443193greyhen
grister83915413grister
grosser84313143grosser
guesser8166543guesser
gusher104115773_gusher
harsher13310363harsher
jester134319153_jester
josher164312963_josher
kasher134915033_kasher
keester11319913keester
kiester11329973kiester
kosher134412973_kosher
kreuzer2032353kreuzer
lasher94824533_lasher
lecher113415853_lecher
lesser63514853_lesser
lusher93818763_lusher
masher114123203_masher
meshed124415933_meshed
meshes115019443_meshes
meshier123410853_meshier
mosher114719793_mosher
musher113820573_musher
nester64124183_nester
nether94014163_nether
nosher94616363_nosher
percher143313423percher
pester84827593_pester
pisher114317753_pisher
plasher124215033plasher
plusher124010383plusher
posher115018163_posher
preacher153211373preacher
preaver121011613preaver
preener93114833preener
prefer113813203pre_fer
premier113515633premier
presager1138443presager
prese75228383pres_e_
preset84430983pres_et
preship1439793preship
preshow15237413preshow
presider11410423presider
pressed103317313pressed
pressers103215023pressers
presses93523153presses
pressor93512873pressor
presters103419003presters
presumer1247583presumer
preyer114413733pre_yer
proser84223463pros_er
prosier93817483prosier
prosper114012193prosper
pusher114318283_pusher
quasher19198623quasher
quester161410023quester
raser55633413_ras_er
rashers104020913_rashers
rashes95330153_rashes
rasper83917333_rasper
raster64731443_raster
rather94319743_rather
reacher123718293_reacher
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reaver94524733_reaver
rechew14310213_rechew
redder83918133_redder
reefer93314363_reefer
reeker103715593_reeker
reeler63822573_reeler
refer84822143_re_fer
refreshed1685613refreshed
refreshen1585163refreshen
refreshers16103673refreshers
refreshes1595953refreshes
rehear93713223_re_hear
rehem103815353_re_hem
reiver95318293_reiver
relier65826183_relier
render74024143_render
renter64527413_renter
rescuer939033_rescuer
resee54336333_res_ee
reseed74823293_reseed
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
reset55051863_res_et
resew84519503_res_ew
resh76523453_resh__
reshaper1336913_reshaper
reship11310673_reship
reshod103012233_reshod
reshoe92816483_reshoe
reshoed112212153_reshoed
reshoes102316033_reshoes
reshot93519633_reshot
reshow123111433_reshow
reshower14107063_reshower
resider84615803_resider
rested74430783_rested
resters74130403_resters
resumer9410113_resumer
richer114015043_richer
riser55431053_ris_er
risker105414493_risker
rosier64221263_rosier
roster64329083_roster
rushed104419863_rushed
rushee93818773_rushee
rushers103816103_rushers
rushes94724363_rushes
rushier103411973_rushier
shusher13288113shusher
slasher104515333slasher
smasher123911023smasher
swasher134011513swasher
swisher13369523swisher
teether10349693teether
terser67317823ters_er
tester64227153_tester
tether93716103_tether
thrasher1455743thrasher
threshed1535643threshed
threshers1545423threshers
threshes1437383threshes
trashed113514703trashed
trashers113013643trashers
trashes104119263trashes
trashier113210103trashier
treader84113833treader
treater74219833treater
trekker1034733trekker
trencher13279313trencher
tressed83714253tressed
tressel73010893tressel
tresses73719543tresses
tressier847963tressier
trusser74010253trusser
truster73114313truster
tryster10369513tryster
ureter6313203ure_ter
usher84517763__usher
verser94516963vers_er
vesper1138083_vesper
washer124720393_washer
welsher13377443welsher
wester94222893_wester
wether123315393_wether
whether16346623whether
wisher123617063_wisher
wreaker143610043wreaker
wreather14268603wreather
wrecker16367603wrecker
wrencher16287783wrencher
wrested113410933wrested
wresters112711733wresters
wrestler11306993wrestler
writher134010853writher
yester93417983_yester
zester153617793_zester

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274276.59320328.7
3Display Results4274270.1732468.2
 (SQL Overall)1786914276.92225814.9
 
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.