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

360 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
webster123609(None) 
websters1335801websters
wester94222891we_ster
dabster1036702dabster
debater104114692debater
easter65027982_easter
ester54727712_e_ster
feaster10812982feaster
fester94723512fe_ster
fibster12146532fibster
heister103613622heister
jester134319152je_ster
keester11319912keester
keister113011572keister
keyster14256152keyster
leister73212752leister
lobster9288852lobster
meister93114162meister
mobster11299212mobster
nester64124182ne_ster
penster92811952penster
pester84827592pe_ster
rebater93517912rebater
rester63832432re_ster
tester64227152te_ster
waister103812382waister
waster95228942w_aster
webbier1445422webbier
webcaster1642382webcaster
weber10313522web__er
webmaster1643002webmaster
website1235322website_
websites1335182websites
welsher13377442welsher
welter93417382we_lter
western102911092we_stern
westers105221962we_sters
wetter93919442we_tter
wrester102812412wrester
yester93417982ye_ster
zester153617792ze_ster
abater85518123_abater
abetter958323abetter
arbiter939933arbiter
aster55434893__aster
baster85333593_baster
beater84729393be_ater
belter84720963be_lter
bested94922753be_sted
bestir8311163be_stir
better84723703be_tter
bister84922763_bister
biter75030033__biter
blaster94017303blaster
blister94415313blister
bluster94215313bluster
boaster94616433boaster
bolster93713423bolster
booster94314553booster
burster9310293burster
buster84726493_buster
caster85232573_caster
censer84516583cens_er
center84421413ce_nter
chaster124718503chaster
cluster94013333cluster
clyster12317453clyster
coaster94219043coaster
coster84331293_coster
dabsters1137053dabsters
debaser103510413debaser
debate94419193debate_
debated113916083debated
debaters113511923debaters
debates103718533debates
debited113311623debited
deboner103110483deboner
debtor938333deb_tor
debuted11379333debuted
deemster1175713deemster
defter104215923de_fter
deluster936903deluster
demister11310223demister
dempster1355773dempster
denser74115193dens_er
deter65028043de__ter
detester9239683detester
dewater112912423dewater
dexter143810893de_xter
diaster82813313diaster
diester83013683diester
duster74919723_duster
easier64218463_easier
eastern74412533_eastern
easters75125683_easters
eater54639843_e_ater
elater64724203_elater
emoter85415193_emoter
enter54726383_e_nter
esker94412983_e_sker
esters64627733_e_sters
faster94625773_faster
feasted11310843feasted
feasters11511563feasters
feater95224053fe_ater
feistier1136193feistier
festers104121393fe_sters
fetter94120383fe_tter
fibsters13126413fibsters
fluster103913063fluster
foster94322223_foster
fubsier12367763fubsier
gagster9317633gagster
gaster75027353_gaster
geste65920693ge_ste_
gestes75721393ge_stes
getter74117613ge_tter
geyser1036513geys_er
glister84013343glister
grister83915413grister
gypster1333953gypster
hamster12810423hamster
heater94828303he_ater
hefter124313923he_fter
heisted113210653heisted
heisters113413133heisters
hipster12288783hipster
hoister103714203hoister
holster103512213holster
jested144416503je_sted
jesters144118193je_sters
jouster143311043jouster
juster134617013_juster
keesters12319593keesters
keisters123212043keisters
kelter103214373ke_lter
keysters15326333keysters
kiester11329973kiester
klister113410643klister
lamster9109913lamster
laster64830633_laster
leaser65322673leas_er
lefter93613433le_fter
leisters83312823leisters
lesser63514853le_sser
letter63722583le_tter
lister64527253_lister
lobsters10268743lobsters
luster64023673_luster
master84831343_master
meeter83616503me_eter
meisters103313843meisters
melter83520113me_lter
messier93412923messier
mestee84523883me_stee
meter75130323me__ter
minster93914323minster
mister84728563_mister
mobsters12359063mobsters
moister94015373moister
monster93214603monster
muenster1043313muenster
munster93710523munster
muster84724523_muster
neater64424313ne_ater
negater83711963negater
nested74720063ne_sted
nesters74422793ne_sters
nestler73510443ne_stler
nestor63713423ne_stor
netter63722023ne_tter
neuter63713793ne_uter
newsier10147223newsier
oersted839553oersted
oldster896573oldster
oleaster837263oleaster
orbiter937853orbiter
ouster64223733_ouster
oyster94111703_oyster
paster85734373_paster
pearter9412743pearter
pelter83321623pe_lter
pensters103012123pensters
perter84422283pe_rter
pesters93827093pe_sters
pestier94317403pe_stier
peter74427593pe__ter
petter83924773pe_tter
pewter114013673pe_wter
piaster93012883piaster
plaster93318693plaster
poster84129173_poster
prester93519623prester
punster92911103punster
quester161410023quester
raster64731443_raster
realter73716313realter
rebate84424113rebate_
rebated103619703rebated
rebaters103413943rebaters
rebates95123183rebates
rebuker13407843rebuker
rebutter10106273rebutter
reciter94117263reciter
reenter73217793reenter
reested82916233reested
refuter104312193refuter
register939553register
reinter73116843reinter
relater73723143relater
remaster10311473remaster
remoter94815973remoter
renter64527413re_nter
resister8311653resister
rested74430783re_sted
resters74130403re_sters
reutter71010093reutter
roaster74116663roaster
robuster1035663robuster
roister73516203roister
rooster74415173rooster
roster64329083_roster
rouster73517083rouster
royster103110533royster
seamster1037143seamster
seater64534153se_ater
sedater83713623sedater
seiser65318343seis_er
semester1038903semester
sestet6826203se_stet
setter64023723se_tter
shyster13116563shyster
sister64421583_sister
sweater103712723swe_ater
sweeter103212003swe_eter
swelter103711173swe_lter
tapster9299273tapster
taster64930573_taster
teamster1036293teamster
teaser65421523teas_er
teeter65420313te_eter
tempter11358213tempter
tenser64919433tens_er
tenter64623933te_nter
terser67317823ters_er
tested74421523te_sted
testee64323303te_stee
testers74124543te_sters
testes65125823te_stes
testier74015643te_stier
tetter64322453te_tter
tipster9299053tipster
toaster74414463toaster
truster73114313truster
tryster10369513tryster
tweeter10288533twe_eter
twister10308953twister
ulster63712103_ulster
vaster94521023_vaster
venter94218723ve_nter
verser94516963vers_er
verste94515633verste_
verstes104014283verstes
vesper1138083ve_sper
vested104217353ve_sted
vestee94319153ve_stee
vetter93417643ve_tter
wabbler143511923wabbler
wafter124114613w_after
waisted114210943waisted
waisters113811523waisters
waiter94321253w_aiter
wanter94423053w_anter
warsler10289893warsler
warstler11275933warstler
washer124720393w_asher
waste86125053w_aste_
wasted104423023w_asted
wasters104026593w_asters
wastery134610993w_astery
wastes96224883w_astes
water84733313w__ater
watter93221983w_atter
weaker134015443we_aker
weaner93816773we_aner
wearer94319403we_arer
wearier103613283wearier
weasel93410523weas_el
weather133513223weather
weaver123916613we_aver
webbed1436433web_bed
webcasted1741973webcasted
webcasters1742143webcasters
webers11310943web__ers
webfed1535033web_fed
webfeet1544593webfeet
webmasters1742913webmasters
webs96622123webs___
wedder113612293we_dder
wedgier12428273wedgier
weeder103315513we_eder
weedier113810623weedier
weenier103210803weenier
weensier1134243weensier
weeper114313303we_eper
weepier12319273weepier
weer75535093we___er
weest85026773weest__
weeted103913793we_eted
weever123811443we_ever
weigher14136343weigher
weighter1535603weighter
weiner94214133we_iner
weirder1144923weirder
welcher15319393welcher
welder102914413we_lder
welshed14277203welshed
welshers14246813welshers
welshes13379093welshes
welted103715823we_lted
welters103516063we_lters
wencher153811133wencher
wennier10318603wennier
west75748083we_st__
westered122511863we_stered
westerly1445553we_sterly
westerns11328963we_sterns
wests85727003we_st_s
wether123315393we_ther
wetted103717023we_tted
wetters103817753we_tters
whetter13348803whetter
whisker17367933whisker
whisper15298013whisper
whisted144010013whisted
whistler1496313whistler
whiter124316393w_hiter
whitter139110893whitter
winter94222803w_inter
wiser85522803w_is_er
wisher123617063w_isher
wisted104120273w_isted
wobbler14329823wobbler
worser95117523wors_er
worsted1138013worsted
wowser125110203wows_er
wrested113410933wrested
wresters112711733wresters
wrestler11306993wrestler
wristier1136863wristier
writer94416513w_riter
wussier10408083wussier
xyster16366803_xyster
yeasted1138503yeasted
yeastier1135393yeastier
yestern10338633ye_stern
zested164214043ze_sted
zesters163517293ze_sters
zestier163010223ze_stier
zoster153715853_zoster

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340273606.96619240.2
3Display Results3603600.1402571.4
 (SQL Overall)1786913607.26624592.8
 
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.