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

249 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
keysters1532633(None) 
keesters12319591keesters
keisters123212041keisters
keyster14256151keyster_
clysters13227842clysters
easters75125682_easters
esters64627732_e_sters
feasters11511562feasters
festers104121392fe_sters
geysers1135702geys_ers
heisters113413132heisters
jesters144118192je_sters
keester11319912keester_
keister113011572keister_
kelters113813752ke_lters
keynoters1642312keynoters
keysets1434342keys_ets
kiesters123310152kiesters
klisters123910482klisters
leisters83312822leisters
meisters103313842meisters
nesters74422792ne_sters
oysters103411692_oysters
pensters103012122pensters
pesters93827092pe_sters
resters74130402re_sters
roysters113610532roysters
shysters14106462shysters
testers74124542te_sters
trysters11298372trysters
websters1335802websters
westers105221962we_sters
xysters17307162_xysters
zesters163517292ze_sters
asters65631603__asters
basters94930303_basters
beaters94925043be_aters
belters93819413be_lters
bestirs9311133be_stirs
betters94422093be_tters
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013443boosters
bursters1038983bursters
busters94724133_busters
casters94729903_casters
censers94313903cens_ers
centers94420603ce_nters
clusters102912403clusters
clyster12317453clyster_
coasters104317333coasters
costers94128333_costers
dabsters1137053dabsters
daystars1243903daystars
debaters113511923debaters
deemsters1285023deemsters
delusters1035983delusters
demisters1249203demisters
dempsters1435273dempsters
deters74724683de__ters
detesters10298303detesters
dewaters122910723dewaters
diasters92913183diasters
diesters92513603diesters
dusters84918363_dusters
easter65027983_easter_
eastern74412533_eastern
eaters65535953_e_aters
elaters74420193_elaters
emoters94712873_emoters
enters64425643_e_nters
eskers105312223_e_skers
ester54727713_e_ster_
eyers86521333_ey__ers
feaster10812983feaster_
fester94723513fe_ster_
fetters103517903fe_tters
fibsters13126413fibsters
flusters113811503flusters
fosters104220103_fosters
gagsters10317083gagsters
gasters85624293_gasters
gestes75721393ge_ste_s
getters84216103ge_tters
geyser1036513geys_er_
glisters93912603glisters
gristers94013403gristers
gypsters1434023gypsters
hamsters13710423hamsters
heaters104225223he_aters
hefters134312003he_fters
heister103613623heister_
hipsters13268793hipsters
hoisters113513483hoisters
holsters113211943holsters
jester134319153je_ster_
jokesters2044443joke_sters
jousters153210423jousters
justers143815733_justers
kaisers11369273kais_ers
kashers143914023k_ashers
kayakers1463613kayakers
keeners113610783ke_eners
keepers133410983ke_epers
kegelers1355163kegelers
keggers13357033ke_ggers
keglers12277773ke_glers
kelter103214373ke_lter_
kentes105118643ke_nte_s
kerseys1433993kers_eys
kestrel1137113ke_strel
kestrels1235813ke_strels
keyless1436163key_less
keynoter1542383keynoter_
keynotes1543633keynote_s
keyset13411523keys_e_t
keystone1545333keystone
keystones1645083keystones
kiester11329973kiester_
kilters113813603k_ilters
kissers114211293k_issers
kiters105218593k__iters
klister113410643klister_
knitters12336623knitters
knotters12276153knotters
koshers144811803k_oshers
kraters114212343k_raters
kytes125012913k_y_te_s
lamsters1099753lamsters
lasters75627693_lasters
leasers74717843leas_ers
leister73212753leister_
letters73819853le_tters
listers74026533_listers
lobsters10268743lobsters
lusters73921443_lusters
masters94628923_masters
meeters94714543me_eters
meister93114163meister_
melters93918313me_lters
mestees94617753me_stees
meters85625833me__ters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
monsters103314553monsters
muensters1143253muensters
munsters104010553munsters
musters94522513_musters
mystery15436523_mystery
negaters9349783negaters
nester64124183ne_ster_
nestlers8359223ne_stlers
nestors73614973ne_stors
netters73618583ne_tters
neuters74212273ne_uters
oersteds934373oersteds
oldsters996733oldsters
oleasters936733oleasters
ousters74122793_ousters
oyster94111703_oyster_
pasters94531733_pasters
pelters93720313pe_lters
penster92811953penster_
pester84827593pe_ster_
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
peyotes1238483peyote_s
piasters102912813piasters
plasters103518133plasters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168763questers
rasters74629023_rasters
realters83614043realters
rebaters103413943rebaters
reciters102613113reciters
reenters82915303reenters
refuters11449613refuters
registers1038893registers
reinters82614773reinters
relaters83218153relaters
remasters11310583remasters
renters74224813re_nters
resisters9310453resisters
rester63832433re_ster_
reutters8138573reutters
roasters83615933roasters
roisters83615553roisters
roosters83514663roosters
rosters73727543_rosters
rousters84315683rousters
royster103110533royster_
seamsters1136333seamsters
seaters74028943se_aters
seisers73816393seis_ers
semesters1139123semesters
sestets7911473se_stets
setters73822063se_tters
shyster13116563shyster_
sisters73721593_sisters
skeeters12298963ske_eters
skelters12349373ske_lters
systems1234683_systems
tapsters10318803tapsters
tasters74225643_tasters
teamsters1135973teamsters
teasers75317243teas_ers
teeters74018303te_eters
tempters12257293tempters
tenters73921103te_nters
testees74215913te_stees
tester64227153te_ster_
testes65125823te_ste_s
tetters74320473te_tters
tipsters10278513tipsters
toasters83912723toasters
trusters83112263trusters
tryster10369513tryster_
trystes10419993tryste_s
twisters11268173twisters
ulsters72711983_ulsters
venters103717733ve_nters
versers103813523vers_ers
verstes104014283verste_s
vespers1239033ve_spers
vestees103513173ve_stees
vetters104016323ve_tters
waisters113811523waisters
wasters104026593_wasters
webster1236093webster_
welshers14246813welshers
welters103516063we_lters
wester94222893we_ster_
western102911093we_stern
westerns11328963we_sterns
wetters103817753we_tters
wresters112711733wresters
xyster16366803_xyster_
yester93417983ye_ster_
yestern10338633ye_stern
zester153617793ze_ster_
zosters163015413_zosters

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622496.05024159.0
3Display Results2492490.0932677.4
 (SQL Overall)1786912496.29928368.2
 
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.