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

185 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
oleasters93673(None) 
oleaster837261oleaster_
blasters104116142bl_asters
bleaters103412322blea_ters
easters75125682__easters
feasters11511562_feasters
lasters75627692_l_asters
leasers74717842_leas_ers
leisters83312822_leisters
molesters1198872mole_sters
oldsters996732ol_dsters
oleanders1035572oleanders
oleates7417832olea_te_s
plasters103518132pl_asters
pleasers104010292pleas_ers
pleaters103613792plea_ters
alabasters1243253alabasters
alastors8311203al_astors
asters65631603___asters
ballasters1245093ballasters
basters94930303__basters
beaters94925043_bea_ters
blaster94017303bl_aster_
blatters104414093bl_atters
bleachers16297923bleachers
bleater94515303blea_ter_
blessers10277633ble_ssers
blisters104015083bl_isters
bloaters103311023bloa_ters
blusters104413893bl_usters
boasters103915663_boasters
bolsters103712453bol__sters
bombasters1643703bombasters
cadasters1236833cadasters
casters94729903__casters
cheaters133613513chea_ters
clashers134213993cl_ashers
claspers124410913cl_aspers
classers104111833cl_assers
clatters103313913cl_atters
cleaners103610543clea_ners
cleansers11335063cleansers
clearers10349303clea_rers
cleavers13398873clea_vers
cloisters1137433cloisters
clusters102912403cl_usters
clysters13227843cl_ysters
coasters104317333_coasters
coleaders1237823colea_ders
creasers103612823creas_ers
cytasters1483663cytasters
deemsters1285023deemsters
delusters1035983delusters
diasters92913183_diasters
diesters92513603die_sters
disasters1039153disasters
dopesters1237283dope_sters
easter65027983__easter_
eastern74412533__eastern
eaters65535953__ea_ters
elaters74420193el_a_ters
esters64627733__e_sters
feaster10812983_feaster_
festers104121393_fe_sters
flashers143912653fl_ashers
flatters113814203fl_atters
flensers1135463flens_ers
fleshers14339443fle_shers
floaters112711513floa_ters
flusters113811503fl_usters
forecasters1675003forecasters
foresters12312533fore_sters
gasters85624293__gasters
gleamers11306563glea_mers
gleaners9348073glea_ners
glisters93912603gl_isters
gloaters9288863gloa_ters
greasers93410253greas_ers
heaters104225223_hea_ters
heisters113413133_heisters
holsters113211943hol__sters
jesters144118193_je_sters
jokesters2044443joke_sters
keesters12319593_keesters
keisters123212043_keisters
keysters15326333_keysters
kiesters123310153kie_sters
klisters123910483kl_isters
lamsters1099753_lamsters
lasers64925703_l_as_ers
lashers104121833_l_ashers
laster64830633_l_aster_
leachers133712813_leachers
leaders83819603_lea_ders
leaguers935063_leaguers
leakers113415423_lea_kers
leaners73718173_lea_ners
leapers93716663_lea_pers
learners8398153_learners
leaser65322673_leas_er_
leases65428113_leas_e_s
leashes103514403_leashe_s
leasts64616413_least__s
leathers114215083_leathers
leavers103717783_lea_vers
leister73212753_leister_
letters73819853_le_tters
levanters1254993_levanters
listers74026533_l_isters
lobsters10268743_lobsters
locaters102710073loca_ters
lusters73921443_l_usters
masters94628923__masters
meisters103313843_meisters
molester1099373mole_ster_
muensters1143253muensters
nesters74422793_ne_sters
oaters65029793o__a_ters
oersteds934373o_ersteds
oldster896573ol_dster_
oleander936403oleander_
oleate6318883olea_te__
olestra746173ole_st_ra
olestras846583ole_stras
ousters74122793o__usters
outmasters1245733outmasters
overmasters1644823overmasters
overseers12298783overseers
oversteers1344863oversteers
oversteps1436303oversteps
overstirs1238213overstirs
oysters103411693o__ysters
pasters94531733__pasters
pensters103012123_pensters
pesters93827093_pe_sters
piasters102912813_piasters
pilasters1138223pilasters
pinasters1136823pinasters
plaisters1137813plaisters
plaiters103512633pl_aiters
planters102915323pl_anters
plashers133813453pl_ashers
plaster93318693pl_aster_
plastery13279703pl_astery
platers93924093pl_a_ters
platters103415283pl_atters
pleaders113210183plea_ders
pleaser93912343pleas_er_
pleases94515483pleas_e_s
pleasures1145573pleasures
pleater93916333plea_ter_
pleathers1446453pleathers
poetasters1245283poetasters
polestars1157283pole_stars
pollsters1137173pol_lsters
polyesters1545233polyesters
prealters1147773prealters
presters103419003pre_sters
questers17168763que_sters
rasters74629023__rasters
realters83614043_realters
relaters83218153rela_ters
releasers937323releas_ers
remasters11310583remasters
resters74130403_re_sters
roasters83615933_roasters
seamsters1136333_seamsters
seaters74028943_sea_ters
slashers113313613sl_ashers
slaters73123733sl_a_ters
sweaters113811063swea_ters
tasters74225643__tasters
teamsters1135973_teamsters
teasers75317243_teas_ers
telecasters1343783telecasters
testers74124543_te_sters
theaters114211903thea_ters
toasters83912723_toasters
treaters83615843trea_ters
ulsters72711983ul__sters
wasters104026593__wasters
websters1335803_websters
westers105221963_we_sters
wresters112711733wre_sters
zesters163517293_ze_sters

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411856.20323962.8
3Display Results1851850.0802312.5
 (SQL Overall)1786911856.43927751.4
 
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.