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

320 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
clysters1322784(None) 
clusters102912401clusters
clyster12317451clyster_
blasters104116142blasters
blisters104015082blisters
blusters104413892blusters
calypters1643592calypters
casters94729902c_asters
clashers134213992clashers
claspers124410912claspers
classers104111832classers
clatters103313912clatters
cloisters1137442cloisters
closers94415322clos_ers
clouters10399802clouters
cluster94013332cluster_
clustery13317112clustery
clutters103210352clutters
coasters104317342coasters
costers94128342c_osters
flusters113811502flusters
glisters93912602glisters
keysters15326332keysters
klisters123910482klisters
lasters75627692_lasters
listers74026532_listers
lusters73921442_lusters
oldsters996732oldsters
oysters103411692_oysters
plasters103518132plasters
roysters113610532roysters
shysters14106462shysters
trysters11298372trysters
ulsters72711982ul_sters
xysters17307162_xysters
alastors8311223alastors
alters64924223al__ters
asters65631603__asters
balusters1136643balusters
basters94930313_basters
bisters93922613_bisters
blaster94017303blaster_
blatters104414093blatters
bleaters103412323bleaters
blessers10277633blessers
blister94415313blister_
blistery13418713blistery
bloaters103311023bloaters
blotters104110983blotters
blurters10348373blurters
blushers133911293blushers
bluster94215313bluster_
blustery13368003blustery
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
bursters1038983bursters
busters94724133_busters
cadasters1236833cadasters
calypter1544063calypter_
canisters112310203canisters
canters94827733c_anters
carters95327263c_arters
caster85232573c_aster_
castes85631863c_aste_s
castors94919443c_astors
caters85336503c__aters
causers94014793caus_ers
celestes10310013celeste_s
censers94313903cens_ers
centers94420603c_enters
chanters134016743chanters
chapters154012133chapters
charters134115593charters
chasers123714923chas_ers
chastens13429183chastens
chaster124718503chaster_
chatters134213953chatters
cheaters133613513cheaters
chitters133711173chitters
chunters133910903chunters
cistern93310703c_istern
cisterns10369583c_isterns
citers85022983c__iters
clabbers14359903clabbers
clackers163911703clackers
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clampers143211893clampers
clangers114312343clangers
clappers143310833clappers
claquers19226203claquers
clasher124615513clasher_
clashes124017283clashe_s
clasper113811863clasper_
classer93614613classer_
classes94717943classe_s
clastics122811413clastics
clasts84817293clast__s
clatter94014973clatter_
clattery13378193clattery
clavers124314903cl_avers
claviers1367103claviers
clawers123910973cl_awers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
clickers163910203clickers
climbers14318413climbers
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cl_ivers
clobbers14397513clobbers
clockers16369813clockers
cloggers12437283cloggers
cloister1037093cloister_
cloners94514823cl_oners
closer84918203clos_er_
closes85425593clos_e_s
closets94611603clos_ets
closures10228953closures
clouter93511693clouter_
clovers125114663cl_overs
clowders14357473clowders
clubbers14378583clubbers
clumbers143910413clumbers
clunkers14327563clunkers
clustered12186613clustered
clutter94211663clutter_
cluttery13346323cluttery
clypeus1433243cly_peus
coaster94219043coaster_
coaters93525793c_oaters
cointers103616423cointers
colters93522443c_olters
cooters94525733c_ooters
copters113621283c_opters
coshers123618183c_oshers
costars94218013c_ostars
coster84331293c_oster_
cotters94323453c_otters
coulters103614313coulters
counters103320193counters
courters103015373courters
couters93827303c_outers
coveters132411083coveters
coyotes12410703coyote_s
crafters13419953crafters
crashers134013233crashers
craters95021893c_raters
crispers12309443crispers
critters103511333critters
crofters13358913crofters
crosiers103312083crosiers
crossers103912713crossers
crushers134010093crushers
crystals1347173crystals
cursers94317163curs_ers
cussers94213403c_ussers
cutters94218963c_utters
cyclers1435873c_yclers
cyders12398833c_y_ders
cyphers17316753c_yphers
cystein1246053c_ystein
cysteins1355733c_ysteins
cysts105912773c_yst__s
cytasters1483673cytasters
dabsters1137053dabsters
daystars1243903daystars
delusters1035983delusters
diasters92913183diasters
diesters92513603diesters
dusters84918363_dusters
easters75125683_easters
elaters74420193el_aters
enlisters937113enlisters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
filisters1237003filisters
flashers143912653flashers
flatters113814203flatters
fleshers14339443fleshers
flirters11337933flirters
flitters114312173flitters
floaters112711513floaters
flossers11307863flossers
flouters11419273flouters
flushers14279733flushers
fluster103913063fluster_
fluters103713683fl_uters
flutters114010823flutters
flyers125712803fly__ers
flyovers1733673flyovers
flytes123911563fly_te_s
flytiers14254483flytiers
fosters104220103_fosters
gagsters10317083gagsters
gasters85624303_gasters
geysers1135703geys_ers
glistens9366593glistens
glister84013343glister_
glitters93710543glitters
gloaters9288863gloaters
glossers9319053glossers
gristers94013413gristers
gypsters1434023gypsters
hamsters13710423hamsters
heisters113413133heisters
hipsters13268793hipsters
hoisters113513493hoisters
holsters113211943holsters
jesters144118193_jesters
jousters153210423jousters
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
keyster14256153keyster_
kiesters123310153kiesters
klister113410643klister_
lamsters1099753lamsters
lasers64925703_las_ers
lashers104121833_lashers
laster64830633_laster_
leisters83312823leisters
letters73819853_letters
lifters104313783_lifters
linters73822633_linters
lispers94514323_lispers
listees73416673_listees
listels74212433_listels
listens74014133_listens
lister64527253_lister_
liters65429883_l_iters
litters73422573_litters
lobsters10268743lobsters
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
losers65123583_los_ers
lotters73921063_lotters
luster64023673_luster_
lustres73013233_lustres
lysates10317473_lysate_s
lyses84518253_lys_e_s
maltsters1135193maltsters
masters94628923_masters
meisters103313843meisters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
molesters1198873molesters
monsters103314553monsters
munsters104010553munsters
musters94522513_musters
mystery15436523_mystery
nesters74422793_nesters
oldster896573oldster_
oleasters936733oleasters
ousters74122793_ousters
oyster94111703_oyster_
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
piasters102912813piasters
pilasters1138223pilasters
plaisters1137813plaisters
plaiters103512633plaiters
planters102915333planters
plashers133813453plashers
plaster93318693plaster_
plastery13279703plastery
platers93924093pl_aters
platters103415283platters
pleaters103613793pleaters
plotters104011553plotters
plyers114912983ply__ers
pollsters1137173pollsters
polyesters1545233polyesters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168773questers
rasters74629023_rasters
resters74130403_resters
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rosters73727553_rosters
rousters84315683rousters
royster103110533royster_
scamsters1334993scamsters
shyster13116563shyster_
sisters73721593_sisters
slashers113313613slashers
slaters73123733sl_aters
slitters84014133slitters
slotters84012403slotters
systems1234683_systems
tapsters10318803tapsters
tasters74225643_tasters
testers74124543_testers
tipsters10278523tipsters
toasters83912723toasters
trusters83112263trusters
tryster10369513tryster_
trystes10419993tryste_s
twisters11268173twisters
ulster63712103ul_ster_
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
wresters112711733wresters
xyster16366803_xyster_
zesters163517293_zesters
zosters163015413_zosters

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 Limit1461623206.84621350.0
3Display Results3203200.1402285.7
 (SQL Overall)1786913207.40624127.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.