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

398 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
joshed174610901joshed
josher164312961josher
joshes165114851joshes
boshes114721882boshes
bosket124919222bosket
coset75748842cos_et
coshed124217542coshed
cosher114819902cosher
coshes115022782coshes
cosset84125862cosset
josh145117612josh__
joshers174111592joshers
josses135117682josses
kosher134412972kosher
moshed124517492moshed
mosher114719792mosher
moshes115222872moshes
noshed104413502noshed
nosher94616362nosher
noshes96618232noshes
posher115018162posher
poshest12312422poshest
posset84923252posset
rochet115423002rochet
roset55945242ros_et
toshes94520102toshes
ashed97829773_ashed
ashen87818673_ashen
ashes86230613_ashes
asset55932263_asset
avoset9315673avos_et
bashed126225703bashed
basher115123813basher
bashes115631393bashes
basket125722913basket
basset85225383basset
beset76739133bes_et
boche124216953boche_
boches134618523boches
bohea105013733bo_hea
bonnet85524633bonnet
borsht11813503borsh_t
bosh96328973bosh__
bosker123813653bosker
boskets13409473boskets
bosquet18249223bosquet
bossed94816533bossed
bosses85925403bosses
bother115218063bother
bowshot1578253bowshot
bushed124822383bushed
bushel114513943bushel
busher114922203busher
bushes115226113bushes
cachet134526413cachet
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
casket124820993casket
closet85226603clos_et
collet84030363collet
comet95946073co_met
coquet174318013coquet
cornet84436733cornet
corset85636223corset
corslet9318063corslet
corvet114626933corvet
cosec96320183cos_ec
coses76949493cos_es
cosets85824403cos_ets
cosey106226713cos_ey
cosh96127623cosh__
coshers123618173coshers
cosie74728263cosie_
cosied94819883cosied
cosier84423753cosier
cosies84932153cosies
cosiest93819853cosiest
cossets95014283cossets
cost68057943cos__t
costed95623113costed
coster84331293coster
covet105638943co_vet
cowshed1637773cowshed
crochet143616663crochet
cushat113513693cushat
dashed115920563dashed
dasher104318983dasher
dashes106124983dashes
dished114318713dished
dishes104622653dishes
docket134721173docket
dose56442433dos_e_
dosed76626913dos_ed
doser66228563dos_er
doses65938503dos_es
dossed84516633dossed
dossel74813643dossel
dosser74417973dosser
dosses76126273dosses
dost57248353dos__t
fashed136720253fashed
fashes124524023fashes
fished134316313fished
fisher124917143fisher
fishes125221343fishes
fishnet13410343fishnet
forget106326393forget
fosse86119463fosse_
fosses96022083fosses
foster94322223foster
freshet133416643freshet
gashed116321973gashed
gasher104320373gasher
gashes105725153gashes
gashest114813413gashest
gasket114417253gasket
gobbet114214443gobbet
goblet93219483goblet
godet7530043go_det
goglet84618583goglet
gopher1239183gopher
gorget87123863gorget
gorhen1038893gorhen
gosh86123423gosh__
gospel936533gospel
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gusset7316433gusset
hashed136021943hashed
hashes125024803hashes
haslet93222713haslet
het67674313___het
hogget114715763hogget
hornet94926433hornet
hose76547243hos_e_
hosed95830983hos_ed
hosel86024813hos_el
hosen85623883hos_en
hoser811529763hos_er
hoses85443173hos_es
hosey116127023hos_ey
hosier94219613hosier
host77852833hos__t
hosted105020343hosted
hostel93914153hostel
hotshot1358343hotshot
howlet123518343howlet
hushed134416673hushed
hushes124718593hushes
inset54430863ins_et
islet54527553_islet
isohel935483isohel
isohyet1345333isohyet
jacket194720673jacket
jasper154610383jasper
jennet134714953jennet
jesse126012833jesse_
jessed144112303jessed
jesses135215953jesses
jest116738503jes__t
jested144416503jested
jester134319153jester
jesuit1339583jesuit
jet106754823j___et
jobbed184212133jobbed
jobber173813353jobber
jockey22408033jockey
joe106642353jo__e_
joes116635893jo__es
joey145719333jo__ey
jogged166015923jogged
jogger154713163jogger
john145512903jo_h_n
johns15398713jo_hns
joined144613073joined
joiner134114133joiner
joint125227723jo_int
joist125125653jo_ist
joisted15379173joisted
joke155926163jo_ke_
joked175217913jo_ked
joker165715893jo_ker
jokes165423333jo_kes
jokey195014693jo_key
jokier17618753jokier
jokiest18379193jokiest
jole117233823jo_le_
joles125230833jo_les
jolt116639123jo__lt
jolted143510633jolted
jolter133513093jolter
jones125028183jo_nes
joseph18152163joseph
joshing18519413joshing
joss115925593jos__s
jostle13319863jostle
jostled15267083jostled
jostler14288223jostler
jostles143411143jostles
jot108259023jo___t
jotted143615173jotted
jotter134315633jotter
jouked18568153jouked
joule124918203joule_
joules134116823joules
joust125122293jo_ust
jousted15339143jousted
jouster143311043jouster
jowed164724423jo_wed
jowled174210793jowled
joyed164811833jo_yed
junket173815023junket
just115433343jus__t
justed144215773justed
juster134617013juster
justest1449893justest
kasher134915033kasher
khet116328623__khet
kismet123414623kismet
koshers144811803koshers
lashed105625213lashed
lasher94824533lasher
lashes94831003lashes
locket123922473locket
lose45144583los_e_
losel54419423los_el
loser54728673los_er
loses56742013los_es
losses65925233losses
lost47951493los__t
lushed104218723lushed
lusher93818763lusher
lushes94022743lushes
lushest103312283lushest
mashed125325043mashed
masher114123203masher
mashes115030003mashes
meshed124415933meshed
meshes115019443meshes
mishit112618193mishit
mismet103722373mismet
misset85028153misset
mohel104914833mo_hel
moppet126915093moppet
mosey105922873mos_ey
mosh95227603mosh__
moshav1446053moshav
moshers124017843moshers
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
most66554203mos__t
moste75925083moste_
mostest9314793mostest
motet75641193mo_tet
mother113718643mother
mushed124420843mushed
musher113820573musher
mushes114124563mushes
musket122818203musket
nonet54540843no_net
nose46739363nos_e_
nosed65524553nos_ed
noses55435643nos_es
nosey85619883nos_ey
nosh76223543nosh__
noshers103614323noshers
nosier63716323nosier
nosiest73415673nosiest
nother93815963nother
objet141213143_objet
ocher104516103_ocher
octet7324063_octet
ohed87825183_o_hed
oncet74626543_oncet
onset54730173_onset
oohed94214213_oohed
ose38147343_os_e_
oses46641513_os_es
osier53518013_osier
other84219103_other
owlet83324463_owlet
pashed125923143pashed
pashes115828393pashes
pished124817063pished
pisher114317753pisher
pishes114722103pishes
pocket144622623pocket
poet65552903po__et
poohed123912523poohed
poppet92717323poppet
pose66441733pos_e_
posed85828413pos_ed
poser75128773pos_er
poses74642763pos_es
posh95427323posh__
poshly1437723poshly
posies84431433posies
posit75833333pos_it
posse74722273posse_
posses85128803posses
possets94212773possets
post67953363pos__t
posted93722493posted
poster84129173poster
postheat13411243postheat
pother113818853pother
potshot1249733potshot
prophet14316033prophet
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
rachet115028973rachet
rasher95024113rasher
rashes95330153rashes
rashest103916873rashest
reset55051863res_et
reshes94124363reshes
reshot93519633reshot
rochets124213473rochets
rocket125425283rocket
roquet154415893roquet
rose46148903ros_e_
rosed65930343ros_ed
roses56445773ros_es
rosets65819953ros_ets
roshi8310753rosh_i
roshis9311793roshis
rosier64221263rosier
rosiest73919213rosiest
roster64329083roster
roupet84218343roupet
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
russet6319433russet
sachet114725773sachet
sashed105622943sashed
sashes94728483sashes
sestet6826203sestet
set36681253__s_et
shat76456593__shat
she66837693__she_
shea76031573__shea
shed86536153__shed
sheet84836953__sheet
shent85933493__shent
shes75734353__shes
shew108030763__shew
shit76745933__shit
shot76150243__shot
shut76137583__shut
skoshes14246243skoshes
sloshed11329823sloshed
sloshes103811803sloshes
socket123923523socket
sonnet65923503sonnet
sorbet83924073sorbet
soviet9720153soviet
stet45947323__stet
suet46754823__suet
tasset65925313tasset
tocher114014913tocher
toilet66228093toilet
tonlet62924703tonlet
tophe106718973tophe_
tophes115218423tophes
toquet154414683toquet
tosh74826813tosh__
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tost48351923tos__t
tother94117143tother
towhee122613883towhee
tushed104615893tushed
tushes94319473tushes
unset54532433uns_et
unshed10313773unshed
unshut939013unshut
upset73222593ups_et
upshot1138453upshot
usher84517763_usher
washed135521503washed
washer124720393washer
washes124425493washes
whet105133783__whet
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wooshed14167403wooshed
wooshes13169883wooshes
worset96726583worset
wost76544363wos__t
zoster153715853zoster

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163985.93618988.5
3Display Results3983980.1263158.7
 (SQL Overall)1786913986.20228811.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.