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

393 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
tapsters1031880(None) 
tapster9299271tapster_
tasters74225641ta_sters
tipsters10278511tipsters
asters65631602_a_sters
basters94930302ba_sters
casters94729902ca_sters
dabsters1137052dabsters
easters75125682ea_sters
gagsters10317082gagsters
gasters85624292ga_sters
gypsters1434022gypsters
hamsters13710422hamsters
hipsters13268792hipsters
lamsters1099752lamsters
lapsers93911052laps_ers
lasters75627692la_sters
masters94628922ma_sters
pasters94531732pa_sters
rasters74629022ra_sters
taperers10269772taperers
tapers84025812tap__ers
tappers113416542tap_pers
tarsiers8298532tarsiers
taster64930572ta_ster_
tastes64126422ta_ste_s
taters64932202ta__ters
tatters74520482ta_tters
taunters8259272taunters
teamsters1135972teamsters
testers74124542t_esters
tipster9299052tipster_
toasters83912722toasters
trusters83112262trusters
trysters11298372trysters
twisters11268172twisters
waisters113811522waisters
wasters104026592wa_sters
abaters95115203_abaters
adapters1136103adap_ters
afters94717073_a_fters
alters64924223_a_lters
answers1037043_answers
apers76629133_ap__ers
apses76823913_aps_e_s
apter76120203_ap_ter_
askers105915403_a_skers
aspers86220313_a_spers
aster55434893_a_ster_
astern64815813_a_stern
attesters935803attesters
austere7312993_austere
baiters94619303ba_iters
balusters1136643balusters
banisters11189473banisters
banters94623113ba_nters
barters94223033ba_rters
bashers124820833ba_shers
baster85333593ba_ster_
bastes85330383ba_ste_s
batters94626013ba_tters
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013443boosters
bursters1038983bursters
busters94724133_busters
cadasters1236833cadasters
canisters112310193canisters
canters94827733ca_nters
caperers122611723caperers
capers105428143cap__ers
capotes11314643capote_s
cappers134419403cap_pers
capsomers1544753capsomers
capstans1257243capstans
captors113914983cap_tors
carters95327253ca_rters
caster85232573ca_ster_
castes85631863ca_ste_s
castors94919443ca_stors
caters85336503ca__ters
causers94014793caus_ers
chapiters1635203chapiters
chapters154012133chap_ters
clusters102912403clusters
clysters13227843clysters
coasters104317333coasters
copters113621283cop_ters
costers94128333_costers
cytasters1483663cyta_sters
dabster1036703dabster_
darters84017603da_rters
dashers115016863da_shers
daters74827373da__ters
daunters9329853daunters
daystars1243903daystars
dempsters1435273dempsters
diasters92913183diasters
diesters92513603diesters
dopesters1237283dopesters
dragsters1134333dragsters
dumpsters1453743dumpsters
dusters84918363_dusters
easter65027983ea_ster_
eastern74412533ea_stern
eaters65535953ea__ters
esters64627733__esters
fagoters1234863fagoters
fainters11349693fainters
falters103916473fa_lters
fastens105511753fa_stens
faster94625773fa_ster_
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
flusters113811503flusters
fosters104220103_fosters
gagster9317633gagster_
gaiters83516543ga_iters
gamesters1236733gamesters
gangsters11205733gangsters
ganisters10248313ganisters
gapers94520473gap__ers
garters84218233ga_rters
gaspers105014133ga_spers
gassers84714633ga_ssers
gaster75027353ga_ster_
gaters74728643ga__ters
glisters93912603glisters
gristers94013403gristers
gypster1333953gypster_
hafters134614333ha_fters
halters104619803ha_lters
hamster12810423hamster_
haptens124511343hap_tens
hastens106214813ha_stens
hastes95727073ha_ste_s
haters94930403ha__ters
hatters104221523ha_tters
haunters11329543haunters
hawsers13409483haws_ers
heisters113413133heisters
hipster12288783hipster_
hoisters113513483hoisters
holsters113211943holsters
hoopsters1445693hoopsters
imposters13347343imposters
imputers1235823imputers
japers154616173jap__ers
jaspers164310463ja_spers
jesters144118193_jesters
jousters153210423jousters
justers143815733_justers
kaisers11369273kais_ers
kashers143914023ka_shers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310153kiesters
klisters123910483klisters
lamisters1157123lamisters
lamster9109913lamster_
lappers113717463lap_pers
lapser84113143laps_er_
lapses85217693laps_e_s
lasers64925703la_s_ers
lashers104121833la_shers
lassoers8338513lassoers
laster64830633la_ster_
leisters83312823leisters
listers74026533_listers
lobsters10268743lobsters
lusters73921443_lusters
magisters1235803magisters
maltsters1135193maltsters
mappers133313783map_pers
masers84623453ma_s_ers
mashers124621053ma_shers
maskers133913843ma_skers
masseters1136283masseters
master84831343ma_ster_
mastery124214323ma_stery
maters85032393ma__ters
matters94421753ma_tters
meisters103313843meisters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
monsters103314553monsters
munsters104010553munsters
musters94522513_musters
nappers114214863nap_pers
natters73718063na_tters
nesters74422793_nesters
oaters65029793oa__ters
oldsters996733oldsters
ousters74122793_ousters
oysters103411693_oysters
painters103013023painters
palters94021683pa_lters
paperers122410453paperers
papers105125323pap__ers
parsers94118153pars_ers
passers94717753pa_ssers
pastels95215183pa_stels
paster85734373pa_ster_
pastern94415063pa_stern
pasterns104112623pa_sterns
pastes85233913pa_ste_s
pastors94119003pa_stors
paters84935833__paters
patters94825193pa_tters
pausers94113223paus_ers
pensters103012123pensters
pesters93827093_pesters
peters86624593__peters
piasters102912813piasters
plaisters1137813plaisters
plasters103518133plasters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168763questers
quipsters2043593quipsters
rafters103715633ra_fters
raisers73617393rais_ers
ranters73323643ra_nters
rapers84327183rap__ers
rapiers95012873rap_iers
rappers113618443rap_pers
raptors94213353rap_tors
rasers64526783ra_s_ers
rashers104020913ra_shers
raspers94415923ra_spers
raster64731443ra_ster_
raters63936583ra__ters
ratters74422473ra_tters
resters74130403_resters
roadsters1035103roadsters
roasters83615933roasters
roisters83615553roisters
roosters83514663roosters
rosters73727543_rosters
rousters84315683rousters
roysters113610533roysters
salters73622253sa_lters
saluters8319863saluters
sapotes9313943sapote_s
sappers113518903sap_pers
saunters82911753saunters
scamsters1334993scamsters
seamsters1136333seamsters
shysters14106463shysters
sisters73721593_sisters
spatters103914703spatters
staplers103111203stap_lers
starters83714773sta_rters
staters73922343sta__ters
tabers84621573ta__bers
taborers10268333taborers
tackers134319623ta_ckers
tacklers143010773tacklers
taggers93514193ta_ggers
tailers73720183ta_ilers
takers103923743ta__kers
talers64628143ta__lers
talkers113513213ta_lkers
talliers83711373talliers
tamers84224033ta__mers
tamperers13227313tamperers
tampers113516743ta_mpers
tanagers9259003tanagers
tanglers92911973tanglers
tankers113416913ta_nkers
tanners74018393ta_nners
tansies74521243tansie_s
tapadera1153303tapadera
tapaderas1243053tapaderas
tapadero1143193tapadero
tapaderos1242373tapaderos
tapeless10218643tapeless
taper74829773tap__er_
taperer92511793taperer_
tapes75838603tap__e_s
tapestry1343833tapest_ry
tapirs84113173tap__irs
tapises92914013tapise_s
tapper104419613tap_per_
tappets113610013tap_pets
tarpapers1344273tarpapers
tarriers83411713tarriers
tarsier74119253tarsier_
tartars73313403ta_rtars
tarter64023563ta_rter_
tassels74510853ta_ssels
tasses64826763ta_sse_s
tassets75012773ta_ssets
tassies74918933tassie_s
taste55127233ta_ste__
tasted74123973ta_ste_d
tastier711817093ta_stier_
tatars64619793ta__tars
tater54138613ta__ter_
tates55444983ta__te_s
tatter64024573ta_tter_
tattlers8369693tattlers
taunter73111453taunter_
tautens7317843ta_utens
tauter64318023ta_uter_
tawers94118603ta__wers
tawses94913193taws_e_s
taxers134015283ta__xers
taxites1449673taxite_s
taxpayers2141893taxpayers
teamster1036293teamster_
teasers75317243teas_ers
teatasters1043883teatasters
teeters74018303t_eeters
tempters12257293tempters
tenters73921103t_enters
testees74215913t_estees
tester64227153t_ester_
testes65125823t_este_s
tetters74320473t_etters
theaters114211903theaters
thirsters1235233thirsters
thrusters1245333thrusters
tilters73315953t_ilters
tinters74221113t_inters
tippers113414353tip_pers
tipplers12336353tipplers
tipsier9268893tipsier_
titers64526413t__iters
titters74219623t_itters
toaster74414463toaster_
tooters73818773t_ooters
topers85025323top__ers
toppers113914603top_pers
topsiders1243023topsiders
tossers74713503t_ossers
toters65026363t__oters
totters74618733t_otters
touters74018353t_outers
transfers1238053transfers
trappers123711043trap_pers
trashers113013643trashers
treaters83615843treaters
trotters83310243trotters
trussers8348283trussers
trustees8339323trustees
truster73114313truster_
trustors8268913trustors
tryster10369513tryster_
trystes10419993tryste_s
tufters10298353t_ufters
tuskers113710043t_uskers
tussers74313563t_ussers
tweeters11287143tweeters
twister10308953twister_
twitters11296773twitters
ulsters72711983_ulsters
upsteps1133743_upsteps
upstirs935293_upstirs
vaporers1336243vaporers
vaster94521023va_ster_
vaulters11206173vaulters
vaunters11327753vaunters
wafters134112813wa_fters
waister103812383waister_
waiters104218623wa_iters
wanters104420093wa_nters
warslers11328073warslers
warstlers12284713warstlers
washers134517523wa_shers
waster95228943wa_ster_
wastery134610993wa_stery
wastes96224883wa_ste_s
waters95030633wa__ters
websters1335803websters
westers105221963_westers
wresters112711733wresters
xysters17307163_xysters
yachters1633883yachters
yappers144012253yap_pers
yatters103914623ya_tters
zapateos1943113zapateos
zappers203911633zap_pers
zesters163517293_zesters
zosters163015413_zosters

Search took 9 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 Limit1461623937.84318636.0
3Display Results3933930.1602456.3
 (SQL Overall)1786913938.42321214.7
 
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.