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

281 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
websters133580(None) 
webster1236091webster_
westers105221961we_sters
dabsters1137052dabsters
debaters113511922debaters
easters75125682_easters
esters64627732_e_sters
feasters11511562feasters
festers104121392fe_sters
fibsters13126412fibsters
heisters113413132heisters
jesters144118192je_sters
keesters12319592keesters
keisters123212042keisters
keysters15326332keysters
leisters83312822leisters
lobsters10268742lobsters
meisters103313842meisters
mobsters12359062mobsters
nesters74422792ne_sters
pensters103012122pensters
pesters93827092pe_sters
rebaters103413942rebaters
resters74130402re_sters
testers74124542te_sters
waisters113811522waisters
wasters104026592w_asters
webcasters1742142webcasters
webers11310942web__ers
webmasters1742912webmasters
websites1335182website_s
welshers14246812welshers
welters103516062we_lters
wester94222892we_ster_
western102911102we_stern
westerns11328962we_sterns
wetters103817752we_tters
wresters112711732wresters
zesters163517292ze_sters
abaters95115203_abaters
abetters1057173abetters
arbiters1038853arbiters
asters65631603__asters
basters94930313_basters
beaters94925043be_aters
belters93819413be_lters
bestirs9311133be_stirs
betters94422093be_tters
bisters93922613_bisters
biters83925243__biters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
bursters1038983bursters
busters94724133_busters
casters94729903_casters
censers94313903cens_ers
centers94420603ce_nters
clusters102912403clusters
clysters13227843clysters
coasters104317343coasters
costers94128343_costers
dabster1036703dabster_
debasers11377903debasers
debater104114693debater_
debates103718533debate_s
deboners11268113deboners
debtors1038533deb_tors
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_
feaster10812983feaster_
fester94723513fe_ster_
fetters103517903fe_tters
fibster12146533fibster_
flusters113811503flusters
fosters104220103_fosters
gagsters10317083gagsters
gasters85624303_gasters
gestes75721393ge_ste_s
getters84216103ge_tters
geysers1135703geys_ers
glisters93912603glisters
gristers94013413gristers
gypsters1434023gypsters
hamsters13710423hamsters
heaters104225223he_aters
hefters134312003he_fters
heister103613623heister_
hipsters13268793hipsters
hoisters113513493hoisters
holsters113211943holsters
jester134319153je_ster_
jousters153210423jousters
justers143815733_justers
keester11319913keester_
keister113011573keister_
kelters113813753ke_lters
keyster14256153keyster_
kiesters123310153kiesters
klisters123910483klisters
lamsters1099753lamsters
lasters75627693_lasters
leasers74717843leas_ers
leister73212753leister_
letters73819853le_tters
listers74026533_listers
lobster9288853lobster_
lusters73921443_lusters
masters94628923_masters
meeters94714543me_eters
meister93114163meister_
melters93918313me_lters
mestees94617753me_stees
meters85625833me__ters
minsters103813923minsters
misters93927513_misters
mobster11299213mobster_
monsters103314553monsters
muensters1143253muensters
munsters104010553munsters
musters94522513_musters
negaters9349783negaters
nester64124183ne_ster_
nestlers8359233ne_stlers
nestors73614973ne_stors
netters73618583ne_tters
neuters74212273ne_uters
oersteds934373oersteds
oldsters996733oldsters
oleasters936733oleasters
orbiters1036603orbiters
ousters74122793_ousters
oysters103411693_oysters
pasters94531733_pasters
pelters93720313pe_lters
penster92811953penster_
pester84827593pe_ster_
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
piasters102912813piasters
plasters103518133plasters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168773questers
rasters74629023_rasters
realters83614043realters
rebater93517913rebater_
rebates95123183rebate_s
rebukers14435683rebukers
rebutters1195093rebutters
reciters102613113reciters
reenters82915313reenters
refuters11449613refuters
registers1038893registers
reinters82614773reinters
relaters83218153relaters
remasters11310583remasters
renters74224823re_nters
resisters9310453resisters
rester63832433re_ster_
reutters8138573reutters
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rosters73727553_rosters
rousters84315683rousters
roysters113610533roysters
seamsters1136333seamsters
seaters74028943se_aters
seisers73816393seis_ers
semesters1139123semesters
sestets7911473se_stets
setters73822063se_tters
shysters14106463shysters
sisters73721593_sisters
sweaters113811063swe_aters
swelters113110193swe_lters
tapsters10318803tapsters
tasters74225643_tasters
teamsters1135973teamsters
teasers75317243teas_ers
teeters74018303te_eters
tempters12257293tempters
tenters73921113te_nters
testees74215913te_stees
tester64227153te_ster_
testes65125823te_ste_s
tetters74320473te_tters
tipsters10278523tipsters
toasters83912723toasters
trusters83112263trusters
trysters11298373trysters
tweeters11287143twe_eters
twisters11268173twisters
ulsters72711983_ulsters
venters103717733ve_nters
versers103813523vers_ers
verstes104014283verste_s
vespers1239033ve_spers
vestees103513173ve_stees
vetters104016323ve_tters
wabblers15398993wabblers
wafters134112813w_afters
waister103812383waister_
waiters104218623w_aiters
wanters104420093w_anters
warslers11328073warslers
warstlers12284713warstlers
washers134517523w_ashers
waster95228943w_aster_
wastery134610993w_astery
wastes96224883w_aste_s
waters95030633w__aters
weaners104613833we_aners
wearers104615903we_arers
weasels10468503weas_els
weathers143412833weathers
weavers133714463we_avers
webbier1445423webbier_
webcaster1642383webcaster_
weber10313523web__er_
webless1237003web_less
webmaster1643003webmaster_
website1235323website__
wedders123610723we_dders
weeders113412933we_eders
weepers123511973we_epers
weevers13379993we_evers
weighers15135673weighers
weighters1644673weighters
weiners103913063we_iners
welchers16338053welchers
welders113313413we_lders
welsher13377443welsher_
welshes13379093welshe_s
welter93417383we_lter_
wenchers16319213wenchers
westered122511873we_stered
westerly1445553we_sterly
wests85727003we_st__s
wethers135214693we_thers
wetter93919443we_tter_
whetters14246653whetters
whiskers18306773whiskers
whispers16266993whispers
whistlers1595163whistlers
whitters14359403whitters
winters103720483w_inters
wishers133215213w_ishers
wobblers15327883wobblers
worsteds1234493worsteds
wowsers13488763wows_ers
wrester102812413wrester_
wrestlers12306103wrestlers
writers105513493w_riters
xysters17307163_xysters
yester93417983ye_ster_
yestern10338643ye_stern
zester153617793ze_ster_
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 Limit1461622816.73621698.6
3Display Results2812810.1102554.5
 (SQL Overall)1786912817.28224538.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.