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

254 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
oldsters99673(None) 
oldster896571oldster_
blasters104116142blasters
blisters104015082blisters
blusters104413892blusters
bolsters103712452bol_sters
clusters102912402clusters
clysters13227842clysters
flusters113811502flusters
glisters93912602glisters
holsters113211942hol_sters
klisters123910482klisters
lasters75627692_lasters
listers74026532_listers
lobsters10268742lobsters
lusters73921442_lusters
molesters1198872molesters
oleasters936732oleasters
ousters74122792o_usters
oysters103411692o_ysters
plasters103518132plasters
pollsters1137172pollsters
roadsters1035102roadsters
ulsters72711982ul_sters
alastors8311203alastors
alders74218423ald__ers
alters64924223al__ters
asters65631603__asters
balusters1136643balusters
basters94930303_basters
bisters93922613_bisters
blaster94017303blaster_
blatters104414093blatters
bleaters103412323bleaters
blessers10277633blessers
blister94415313blister_
blistery13418713blistery
bloaters103311023bloaters
blotters104110983blotters
blurters10348373blurters
blushers133911293blushers
bluster94215313bluster_
blustery13368003blustery
boasters103915663boasters
bolster93713423bol_ster_
bolters94017803bol__ters
boosters104013443boosters
bursters1038983bursters
busters94724133_busters
cadasters1236833cadasters
casters94729903_casters
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
cloisters1137433cloisters
closers94415323clos_ers
clouters10399803clouters
cluster94013333cluster_
clustery13317113clustery
clutters103210353clutters
clyster12317453clyster_
coasters104317333coasters
colters93522443col__ters
costers94128333_costers
dabsters1137053dabsters
daters74827373__daters
delusters1035983delusters
deters74724683__deters
diasters92913183diasters
diesters92513603diesters
doomsters1236173doomsters
dopesters1237283dopesters
doters74423913__doters
dusters84918363_dusters
easters75125683_easters
elaters74420193el_aters
elders74817303eld__ers
enlisters937113enlisters
esters64627733__esters
feasters11511563feasters
feldshers1643093feldshers
festers104121393_festers
fibsters13126413fibsters
filisters1237003filisters
flashers143912653flashers
flatters113814203flatters
fleshers14339443fleshers
flirters11337933flirters
flitters114312173flitters
floaters112711513floaters
flossers11307863flossers
flouters11419273flouters
flushers14279733flushers
fluster103913063fluster_
fluters103713683fl_uters
flutters114010823flutters
folders113514393fold__ers
foresters12312533foresters
fosters104220103_fosters
gagsters10317083gagsters
gasters85624293_gasters
glistens9366593glistens
glister84013343glister_
glitters93710543glitters
gloaters9288863gloaters
glossers9319053glossers
gristers94013403gristers
gypsters1434023gypsters
hamsters13710423hamsters
heisters113413133heisters
hipsters13268793hipsters
hoisters113513483hoisters
holders113715903hold__ers
holdovers1643763holdovers
holster103512213hol_ster_
hoopsters1445693hoopsters
inditers93311053inditers
jesters144118193_jesters
jokesters2044443jokesters
jolters143711993jol__ters
jousters153210423jousters
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310153kiesters
klister113410643klister_
lamsters1099753lamsters
lasers64925703_las_ers
lashers104121833_lashers
laster64830633_laster_
leisters83312823leisters
letters73819853_letters
lifters104313783_lifters
linters73822633_linters
lispers94514323_lispers
listees73416673_listees
listels74212433_listels
listens74014133_listens
lister64527253_lister_
liters65429883_l_iters
litters73422573_litters
loadstars1043313loadstars
lobster9288853lobster_
locaters102710073locaters
lodestars1044413lodestars
lodgers95113833lod_gers
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
losers65123583_los_ers
lotters73921063_lotters
luster64023673_luster_
lustres73013233_lustres
maltsters1135193maltsters
masters94628923_masters
meisters103313843meisters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
molders103315553mold__ers
molester1099373molester_
molters93816973mol__ters
monsters103314553monsters
munsters104010553munsters
musters94522513_musters
nesters74422793_nesters
oaters65029793o__aters
oersteds934373oersteds
older65121173old__er_
oldies7314423old_ie_s
oldness836403old_ness
oldstyle1242093oldstyle
oldstyles1342233oldstyles
oleaster837263oleaster_
oleates7417833oleate_s
olestra746173olest_ra
olestras846583olestras
omitters10277653omitters
orbiters1036593orbiters
orderers9116563orderers
orders74315993ord__ers
osiers63412793o__siers
ostlers72911203o__stlers
otters64021513o__tters
ouster64223733o_uster_
outers64230173o__uters
outsteers936033outsteers
oxters134813273o__xters
oyster94111703o_yster_
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
piasters102912813piasters
pilasters1138223pilasters
plaisters1137813plaisters
plaiters103512633plaiters
planters102915323planters
plashers133813453plashers
plaster93318693plaster_
plastery13279703plastery
platers93924093pl_aters
platters103415283platters
pleaters103613793pleaters
plotters104011553plotters
polders103617373pold__ers
polestars1157283polestars
polishers1477603polishers
pollster1037103pollster_
polluters1135033polluters
polyesters1545233polyesters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168763questers
rasters74629023_rasters
resters74130403_resters
roadster935463roadster_
roasters83615933roasters
roisters83615553roisters
roosters83514663roosters
rosters73727543_rosters
rousters84315683rousters
roysters113610533roysters
shysters14106463shysters
sisters73721593_sisters
slashers113313613slashers
slaters73123733sl_aters
slitters84014133slitters
slotters84012403slotters
solderers1066533solderers
solders83517773sold__ers
soldiers9277773sold_iers
songsters1046113songsters
sudsers83310423suds_ers
tapsters10318803tapsters
tasters74225643_tasters
testers74124543_testers
tipsters10278513tipsters
toasters83912723toasters
trusters83112263trusters
trysters11298373trysters
twisters11268173twisters
ulster63712103ul_ster_
updaters11255183updaters
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
wresters112711733wresters
xysters17307163_xysters
zesters163517293_zesters
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.406440125.6
2DLD Change Limit1461622546.33023090.4
3Display Results2542540.1102309.1
 (SQL Overall)1786912546.84626101.5
 
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.