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

436 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
cashews1542860(None) 
cashaws15398571cashaws
cashes114729881cashe_s
cashew144311451cashew_
ashes86230612_ashe_s
bashaws15347712bashaws
bashers124820832bashers
bashes115631392bashe_s
caches137926912cache_s
cachets145014262cachets
cahows14399122ca_hows
cases75048382cas_e_s
cashaw14439792cashaw_
cashed125124352cashe_d
cashiers13318882cashiers
cashless1336772cashless
cashoos12310792cashoos
caskets133910172caskets
casters94729902casters
castes85631862caste_s
chews135418512c__hews
clashers134213992clashers
clashes124017282clashe_s
coshers123618182coshers
coshes115022782coshe_s
crashers134013232crashers
crashes124618402crashe_s
cushaws15356292cushaws
dashers115016862dashers
dashes106124982dashe_s
fashes124524022fashe_s
gashes105725152gashe_s
hashes125024802hashe_s
kashers143914022kashers
lashers104121832lashers
lashes94831002lashe_s
mashers124621052mashers
mashes115030002mashe_s
pashes115828392pashe_s
rashers104020912rashers
rashes95330152rashe_s
sashes94728482sashe_s
shews115924712__shews
washers134517522washers
washes124425492washe_s
abashes12510373abashe_s
aches106132293_ache_s
ashed97829773_ashe_d
ashen87818673_ashe_n
ashlers10319583_ashlers
ashless10318453_ashless
askers105915403_askers
askew12529413_askew_
aspens85013353_aspens
aspers86220313_aspers
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
asters65631603_asters
baches135426943bache_s
banshees13127863banshees
bases75644353bas_e_s
bashaw14349303bashaw_
bashed126225703bashe_d
basher115123813bashe_r
baskets135111833baskets
basses85428303basse_s
bassets96414823bassets
basters94930313basters
bastes85330383baste_s
bathers124720363bathers
bathes116524833bathe_s
beshrews1643163beshrews
boshes114721883boshe_s
brashes124518463brashe_s
bushels124110713bushels
bushers124018803bushers
bushes115226113bushe_s
cabers105023923ca_bers
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
cache125122483cache__
cached145419203cache_d
cachet134526413cache_t
cachexy2443283cachexy
cachous14312583cachous
cades85440733ca_de_s
cadets96316513ca_dets
cadgers114712003cadgers
cadges104716713cadge_s
cadres94017933cadre_s
cafes106426923ca_fe_s
cagers95624193ca_gers
cages85936013ca_ge_s
cahiers123510673cahiers
cahow135110943ca_how_
cakes116037673ca_ke_s
calashes13310543calashe_s
calces104420053calce_s
calkers134414693calkers
callees94117783callees
callers94221963callers
callets93821703callets
calves115119283calve_s
calxes154113033calxe_s
cambers134017443cambers
camels105217083ca_mels
cameos105818003ca_meos
cames97047313ca_me_s
camlets114314623camlets
campers134220293campers
cancels114113313cancels
cancers114018583cancers
caners84629203ca_ners
canes75350373ca_ne_s
cankers134418753cankers
cannels93413363cannels
canners93822663canners
canoers94318373canoers
canoes84725883canoe_s
canters94827733canters
capers105428143ca_pers
capes95441923ca_pe_s
caphs124515373caph__s
capless114312763capless
caplets114914523caplets
cappers134419403cappers
carcels114516063carcels
carders104820353carders
careens94514703careens
careers95218783careers
carers85133963ca_rers
cares77369183ca_re_s
caress85720263ca_ress
carets85330773ca_rets
carhops14329703carhops
caries85147623carie_s
carles85435083carle_s
carless95118493carless
carnets93918403carnets
carneys124310543carneys
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carrels95117303carrels
carses85233653carse_s
cartels94618123cartels
carters95327253carters
cartes86239473carte_s
carvels124914593carvels
carvers124817543carvers
carves115128453carve_s
casabas1139983casabas
casas75327843cas__as
casavas1237823casavas
casbahs1436463casbahs
case65848083cas_e__
casease939323cas_ease
cased86032413cas_e_d
casefy1436273cas_efy
caseic103212373cas_eic
casein83216453cas_ein
caseins93115053caseins
caseose939163cas_eose
caseous9312513caseous
casern84713313cas_ern
caserns94711223caserns
cash96636283cash___
cashbox2143453cashbox
cashier123713323cashier
cashing135022553cashing
cashmere1564323cashmere
cashmeres1654393cashmeres
cashoo11312253cash_oo
casings104013513casings
casinos93512833casinos
casitas93312043casitas
casked134815513caske_d
casket124820993caske_t
casks115720063cas__ks
casques18278983casques
cassena9287843cassena
cassenas10317483cassenas
cassene93111543cassene
cassenes103611293cassenes
cassias93514343cassias
cassis84818853cas_sis
caste75932363caste__
casteism1247073casteism
caster85232573caste_r
castles94917733castles
castors94919443castors
casts77237793cas__ts
casuals91410533casuals
casus76419253cas__us
catchers153114063catchers
catches144320773catche_s
caters85336503ca_ters
cates75951893ca_te_s
cathead1338753cathead
catheads1438123catheads
cathect1439863cathect
cathects1545793cathects
cathexes2036273cathexes
cathexis2045753cathexis
catspaws1543163catspaws
caules85927253caule_s
causers94014793causers
causes88026473cause_s
causeys12387223causeys
cavers115026843ca_vers
caves105639703ca_ve_s
cavies114525003cavie_s
caws96036113ca___ws
ceases84427073ceas_e_s
cesses84221363cesse_s
chasers123714923chas_ers
chases115128233chas_e_s
chasses124017503chasse_s
chastens13429183chastens
chaws135022463c__haws
chefs136214663c__hefs
chess105016923c__hess
chew126622133c__hew_
chewy165011903c__hewy
chows135618203c__hows
ciphers14379993ciphers
cithers124315773cithers
clashed133614013clashe_d
clasher124615513clashe_r
claspers124410913claspers
classers104111833classers
classes94717943classe_s
clews105516333c__lews
coachers154312303coachers
coaches144018693coache_s
coalsheds1542863coalsheds
coasters104317343coasters
cosecs105015213cos_ecs
coses76949493cos_e_s
cosets85824403cos_ets
coseys115215813cos_eys
coshed124217553coshe_d
cosher114819903coshe_r
cosies84932163cosie_s
cossets95014283cossets
costers94128343costers
cowsheds1734743cowsheds
crases85532313cras_e_s
crashed134214213crashe_d
crasher124616163crashe_r
crews105917503c__rews
crushers134010093crushers
crushes124215133crushe_s
cuishes122810823cuishe_s
cumshaws1842223cumshaws
curfews15294913curfews
curlews12387393curlews
cusecs10509153cus_ecs
cushats12288273cushats
cushaw14386983cushaw_
cussers94213403cussers
cusses84522773cusse_s
cyphers17316753cyphers
dashed115920563dashe_d
dasheen1136393dasheen
dasheens1244693dasheens
dasher104318983dashe_r
dashis104414393dash_is
deashes113313903deashe_s
dishes104622653dishe_s
easels65914553eas_els
eases56041613eas_e_s
easies64126633easie_s
easters75125683easters
encashes13227673encashe_s
eschews1534553eschews
fasces114914543fasce_s
fashed136720253fashe_d
fastens105511753fastens
fathers133916503fathers
fishers134714723fishers
fishes125221343fishe_s
flashers143912653flashers
flashes133916103flashe_s
gases65633993gas_e_s
gashed116321973gashe_d
gasher104320373gashe_r
gashest114813413gashest
gaskets12348153gaskets
gasless8319013gasless
gaspers105014133gaspers
gassers84714633gassers
gasses75724783gasse_s
gasters85624303gasters
gathers114315073gathers
gnashes11419573gnashe_s
gushers113512513gushers
gushes104719033gushe_s
harshens1437603harshens
hashed136021943hashe_d
hasheesh1342593hasheesh
haslets102510863haslets
hassels104311023hassels
hastens106214813hastens
hastes95727073haste_s
hews105631573___hews
hushes124718593hushe_s
jaspers164310463jaspers
joshers174111593joshers
joshes165114853joshe_s
kashas133311903kash_as
kasher134915033kashe_r
koshers144811803koshers
laches116528353lache_s
lasers64925703las_ers
lases54944763las_e_s
lashed105625213lashe_d
lasher94824533lashe_r
lashins103915153lashins
lasses64827593lasse_s
lasters75627693lasters
lathers104321883lathers
lathes95127503lathe_s
leashes103514403leashe_s
lushes94022743lushe_s
maches134827233mache_s
maihems1444303maihems
marshes123615373marshe_s
masers84623453mas_ers
mashed125325043mashe_d
masher114123203mashe_r
mashies12318253mashies
maskegs14375413maskegs
maskers133913843maskers
masses85028713masse_s
masters94628923masters
mayhems1763413mayhems
meshes115019443meshe_s
moshers124017843moshers
moshes115222873moshe_s
mushers124016443mushers
mushes114124563mushe_s
naches114622413nache_s
nephews1533323nephews
noshers103614333noshers
noshes96618233noshe_s
oases55330983oas_e_s
paseos88015813pas_eos
pases75346503pas_e_s
pashas115117063pash_as
pashed125923143pashe_d
passels93913023passels
passers94717753passers
passes86030473passe_s
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
pishers123815753pishers
pishes114722103pishe_s
plashers133813453plashers
plashes124417393plashe_s
pshaws14435703_pshaws
pushers123814503pushers
pushes114621663pushe_s
quashers20186803quashers
quashes192110973quashe_s
rachets124516833rachets
raphes115117453raphe_s
rasers64526783ras_ers
rases55447213ras_e_s
rasher95024123rashe_r
rashest103916873rashest
rashness1138093rashness
raspers94415923raspers
rasters74629023rasters
rechews1537293rechews
resews94814173res_ews
reshes94124363reshe_s
reshows132510453reshows
rushees103311953rushees
rushers103816103rushers
rushes94724363rushe_s
sachems14348903sachems
sachets123914103sachets
sadhes104715373sadhe_s
sashays1336333sashays
sashed105622943sashe_d
sashless1136603sashless
sasses64124393sasse_s
scathes124515713scathe_s
sews75836023__s_ews
shaws116226263__shaws
sheas86331793__sheas
sheds96122703__sheds
shes75734353__she_s
shew108030763__shew_
shewn115715703__shewn
shows115324583__shows
shrews129313923__shrews
skews125413803__skews
slashers113313613slashers
slashes103619113slashe_s
slews86220353__slews
smashers13339593smashers
smashes123914613smashe_s
smews104612293__smews
snashes105214753snashe_s
spews105015923__spews
stashes103916173stashe_s
stews85519143__stews
swashers14389533swashers
swashes134714403swashe_s
taches114224173tache_s
tassels74510853tassels
tasses64826763tasse_s
tassets75012773tassets
tasters74225643tasters
tastes64126423taste_s
thews117416193__thews
toshes94520103toshe_s
trashers113013643trashers
trashes104119263trashe_s
tushes94319473tushe_s
unsews9379363uns_ews
ushers94415533_ushers
vases84626263vas_e_s
washed135521503washe_d
washer124720393washe_r
washups1534683washups
wasters104026593wasters
wastes96224883waste_s
whews145114493__whews
wishers133215213wishers
wishes124920953wishe_s

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 Filter1786911340270.420425454.8
2DLD Change Limit1340274366.81319672.2
3Display Results4364360.3301321.2
 (SQL Overall)1786914367.56323627.0
 
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.