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

301 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
trysters1129837(None) 
trusters83112261trusters
tryster10369511tryster_
trystes10419991tryste_s
clysters13227842clysters
gristers94013412gristers
keysters15326332keysters
oysters103411692_oysters
presters103419002presters
rasters74629022_rasters
resters74130402_resters
rosters73727552_rosters
roysters113610532roysters
shysters14106462shysters
tapsters10318802tapsters
tasters74225642t_asters
testers74124542t_esters
thrusters1245332thrusters
tipsters10278522tipsters
toasters83912722toasters
trashers113013642trashers
treaters83615852treaters
trotters83310252trotters
trussers8348282trussers
trustees8339322trustees
truster73114312truster_
trustors8268912trustors
tryste9399582tryste__
trysted11428272tryste_d
trysts9448792tryst__s
twisters11268172twisters
wresters112711732wresters
xysters17307162_xysters
arbiters1038853arbiters
arresters948203arresters
asters65631603__asters
attesters935813attesters
basters94930313_basters
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
brasiers103710513brasiers
bruiters10329143bruiters
brushers134210573brushers
bursters1038983bursters
busters94724133_busters
casters94729903_casters
clusters102912403clusters
clyster12317453clyster_
coasters104317343coasters
costers94128343_costers
crafters13419953crafters
crashers134013233crashers
craters95021893cr_aters
crispers12309443crispers
critters103511333critters
crofters13358913crofters
crosiers103312083crosiers
crossers103912713crossers
crushers134010093crushers
crystals1347173crystals
dabsters1137053dabsters
daystars1243903daystars
diasters92913183diasters
diesters92513603diesters
drafters12338533drafters
dragsters1134333dragsters
dressers9359863dressers
drifters12417913drifters
dryers10449273dry__ers
drysalters1441853drysalters
dusters84918363_dusters
easters75125683_easters
erasers74413943eras_ers
erecters102611613erecters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
flusters113811503flusters
foresters12312543foresters
fosters104220103_fosters
fraters103517213fr_aters
fretters113410303fretters
friskers15337373friskers
fritters113810783fritters
frosteds12305663frosteds
fruiters11328183fruiters
fryers125710973fry__ers
gagsters10317083gagsters
gasters85624303_gasters
geysers1135703geys_ers
glisters93912603glisters
grafters12409193grafters
granters93614153granters
graspers11338403graspers
graters85419743gr_aters
greeters92610123greeters
grifters12389233grifters
grister83915413grister_
gritters94210633gritters
grossers94410973grossers
grouters95910093grouters
grunters9359043grunters
gypsters1434023gypsters
hamsters13710423hamsters
heisters113413133heisters
hipsters13268793hipsters
hoisters113513493hoisters
holsters113211943holsters
jesters144118193_jesters
jousters153210423jousters
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
keyster14256153keyster_
kiesters123310153kiesters
klisters123910483klisters
kraters114212343kr_aters
lamsters1099753lamsters
lasters75627693_lasters
leisters83312823leisters
listers74026533_listers
lobsters10268743lobsters
lusters73921443_lusters
masters94628923_masters
meisters103313843meisters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
monsters103314553monsters
munsters104010553munsters
musters94522513_musters
mystery15436523_mystery
nesters74422793_nesters
oldsters996733oldsters
orbiters1036603orbiters
ousters74122793_ousters
oyster94111703_oyster_
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
piasters102912813piasters
plasters103518133plasters
posters93928013_posters
praters94921653pr_aters
pressers103215023pressers
prester93519623prester_
printers103214913printers
prosers94219643pros_ers
prospers123012263prospers
pryers115012243pry__ers
punsters103310583punsters
questers17168773questers
rafters103715633_rafters
ranters73323643_ranters
rasers64526783_ras_ers
rashers104020913_rashers
raspers94415923_raspers
raster64731443_raster_
raters63936583_r_aters
ratters74422473_ratters
renters74224823_renters
rester63832433_rester_
rioters73615523_rioters
risers64624783_ris_ers
riskers114011993_riskers
ritters74020623_ritters
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rooters74522933_rooters
roster64329083_roster_
rotters74421393_rotters
rousters84315683rousters
routers74822873_routers
royster103110533royster_
rushers103816103_rushers
rustlers8339853_rustlers
shyster13116563shyster_
sisters73721593_sisters
strutters955703strutters
systems1234683_systems
tapster9299273tapster_
tarsiers8298533tarsiers
taster64930573t_aster_
tastes64126423t_aste_s
taters64932203t__aters
tatters74520483t_atters
taunters8259273taunters
teamsters1135973teamsters
teasers75317243teas_ers
teeters74018303t_eeters
tempters12257293tempters
tenters73921113t_enters
testees74215913t_estees
tester64227153t_ester_
testes65125823t_este_s
tetters74320473t_etters
theaters114211903theaters
thirsters1235233thirsters
thrashers1565313thrashers
threshers1545423threshers
throwsters1642713throwsters
thruster1135793thruster_
thrustors1244303thrustors
tilters73315953t_ilters
tinters74221113t_inters
tipster9299053tipster_
titers64526413t__iters
titters74219623t_itters
toaster74414463toaster_
tooters73818773t_ooters
tossers74713503t_ossers
toters65026363t__oters
totters74618733t_otters
touters74018353t_outers
toyers95516333toy__ers
tracers94917843tr_acers
trackers143512853trackers
tractors10312573tractors
traders84316953tr_aders
trailers82912933trailers
trainers83114653trainers
traitors8310793traitors
trampers123210393trampers
transfers1238053transfers
trappers123711043trappers
trasher104416133trasher_
trashes104119263trashe_s
trasses74819323trasse_s
trawlers113310203trawlers
treaders93311843treaders
treater74219833treater_
trekkers1133803trekkers
tressels8367653tressels
tresses73719543tresse_s
trestles83012553trestles
trickers143812813trickers
tricksters16264773tricksters
triers64321523tr__iers
triflers113110223triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tr_imers
trimesters1245423trimesters
trimeters1139213trimeters
trimmers12288913trimmers
trippers123210163trippers
triste63818643triste__
tristeza1742933tristeza
tristezas1842753tristezas
triter65120593tr_iter_
troffers14125433troffers
trollers83211213trollers
troopers10289443troopers
trotter73312253trotter_
troupers10359443troupers
trousers83910633trousers
trovers103713323tr_overs
trowsers11428003trowsers
truckers14279013truckers
trudgers10256863trudgers
trusser74010263trusser_
trusses73813643trusse_s
trusted83412793truste_d
trustee73514443truste_e
trusteed9346533trusteed
trustier8268683trustier_
trusties82712853trusties
trustless955953trustless
trustor7238413trustor_
trusts64714433trust__s
trysails1144163trysails
tryst84716223tryst___
trysting12267053trysting
tufters10298353t_ufters
tuskers113710043t_uskers
tussers74313563t_ussers
tuyers94612563tuy__ers
tweeters11287143tweeters
twister10308953twister_
twitters11296773twitters
twyers12497413twy__ers
tyers86220053t_y__ers
ulsters72711983_ulsters
ureters7311823ur_eters
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
wrester102812413wrester_
wrestlers12306103wrestlers
writers105513493wr_iters
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.436409841.7
2DLD Change Limit1461623016.79621507.1
3Display Results3013010.1262388.9
 (SQL Overall)1786913017.35824285.3
 
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.