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 “doers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

289 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
doers6522571(None) 
deers64930521deers
doer57734701doer_
does56554471doe_s
doors65022131doors
dopers95522481dopers
dorrs65520591dorrs
dors56747601do_rs
dosers75723631dosers
doters74423911doters
dowers104523291dowers
dozers164815421dozers
dyers96617131dyers
goers65520251goers
hoers85724921hoers
adders84315702adders
adorers84411732adorers
adores74420722adores
agers65027852agers
apers76629132apers
avers85127312avers
beers75628392beers
biers76225222biers
boars75229602boars
boners84825432boners
boors74325012boors
borers85122682borers
bores76448252bores
bowers115523702bowers
boxers155013482boxers
coders95426982coders
coeds85920162coeds
coirs75221052coirs
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
cores76361852cores
cors66656442co_rs
covers114627962covers
cowers114625532cowers
darers75921872darers
dares66146702dares
daters74827372daters
dears65736882dears
debs76530242d_ebs
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deer56739022deer_
dees56356632d_ees
deets65330242deets
defers105116942defers
dels56745472d_els
dens55945072d_ens
dere56845902d_ere
derm76031892d_erm
derms85022892d_erms
deters74724682deters
devs86424032d_evs
dews86230602d_ews
deys85027472d_eys
dicers94720742dicers
dies55653522die_s
diets66026642diets
dikers114418792dikers
dimers94321092dimers
diners75525952diners
divers105024962divers
doats65224882doats
dobbers123513252dobbers
dobra85013102dobra
dobras94811912dobras
dobro84412212dobro
dobros93910232dobros
dockers143715002dockers
docks126022312docks
docs75631152do_cs
dodders105511792dodders
dodgers105213822dodgers
dodos75819392dodos
doe47361952doe__
doest65829522doest
doeth9411982doeth
doffers14359852doffers
doffs125614332doffs
dogears937512dogears
doges75630162doges
dogeys115510662dogeys
doggers104413432doggers
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolors75115312dolors
dols56943052do_ls
dolts65626312dolts
domes85735562domes
doms76239572do_ms
donas65926472donas
donees74519492donees
dongs76525812dongs
donors75115792donors
dons56048702do_ns
dooms85321342dooms
door56928512door_
doozers17419292doozers
dopas85019062dopas
doper86128392doper_
dopes84935042dopes
dor47253922do_r_
dore56353302do_re
dork96531462do_rk
dorks105724442dorks
dorm76834632do_rm
dormers104313922dormers
dorms85723842dorms
dorp76028052do_rp
dorpers104113172dorpers
dorps85419222dorps
dorr56627722do_rr
dorsa64617282do_rsa
dorsers83516302dorsers
dory85836232do_ry
dos48062312do__s
doser66228562doser_
doses65938502doses
doss56235042do_ss
dossers84516232dossers
doter65428622doter_
dotes65836692dotes
dots55647662do_ts
dotters83715972dotters
doums85417642doums
dour56330432dour_
doura66518662doura
douras75016722douras
dousers84817272dousers
dovens104413902dovens
doves94728152doves
dowels104813342dowels
dower95027702dower_
dowery134311662dowery
downers113912772downers
downs94918572downs
dowry126312482dowry
dows85941052do_ws
dowsers115013532dowsers
doyens104810222doyens
dozens164612462dozens
dozer158419272dozer_
dozes155226302dozes
drears74614252drears
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
driers74516732driers
droners84114382droners
drovers115212642drovers
dryers10449272dryers
duels65619232duels
dues56045502due_s
duets65323882duets
dupers94615602dupers
dures65635922dures
durrs65519992durrs
dyer85522112dyer_
dyes85331892dye_s
edgers84413922edgers
egers65120372egers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
foes76543442foe_s
fores85847102fores
fours85521492fours
foyers125413132foyers
goer56827102goer_
goes55644092goe_s
gofers104711512gofers
gomers94116882gomers
goners74420172goners
gores65740372gores
hers75844872_hers
hoars85925552hoars
hoer76533982hoer_
hoes75755732hoe_s
homers114821982homers
honers94324972honers
hopers114222972hopers
hosers95223972hosers
hours85422392hours
hovers124320252hovers
idlers74012812idlers
jeers124818132jeers
joes116635892joe_s
joeys15518042joeys
jokers175511192jokers
kiers95320092kiers
koels94613902koels
kors85933012ko_rs
leers54828982leers
liers55130402liers
loess55714702loess
loners64225812loners
lopers84424142lopers
lores55045402lores
losers65123582losers
lours55125292lours
lovers94223432lovers
lowers94624922lowers
moors74923142moors
mopers104220372mopers
mores76249642mores
mors65950062mo_rs
movers115117192movers
mowers113219402mowers
noels56418702noels
noes45845392noe_s
noirs55615462noirs
noters64021002noters
oars46846032_oars
odes57243242ode_s
odors64514282odors
odours7418252odours
oes35866192_oe_s
omers76923192omers
ores46056682_ores
ors35750112_o_rs
ours47237562_ours
overs85224792overs
oyers87620882oyers
peers75130272peers
piers75926332piers
poems95715552poems
poets76024442poets
pokers124617922pokers
polers84225642polers
pores75849032pores
posers84223972posers
pours74623182pours
powers113822322powers
roars55622242roars
roes45954142roe_s
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowers94924572rowers
ruers515019412ruers
seers55136382seers
sers45746652_sers
shoers94518332shoers
soars54732512soars
sobers85218862sobers
sores55454282sores
sours55230502sours
sowers94923442sowers
suers55128482suers
tiers55526522tiers
toeas55726422toeas
toes46956442toe_s
tokers104818892tokers
toners64128002toners
topers85025322topers
tores55352672tores
torrs53923562torrs
tors46157382to_rs
toters65026362toters
tours55325892tours
towers94423672towers
toyers95516332toyers
tyers86220052tyers
udders83911292udders
undoers82910582undoers
users55817572users
veers84521362veers
viers85621952viers
voes75432822voe_s
vomers115614942vomers
voters95017442voters
vowers124317182vowers
woes76440662woe_s
wooers93712442wooers
yores85031322yores
yours85217882yours
zoeas145815612zoeas
zoners155115992zoners

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit538002891.73630990.8
3Display Results2892890.0763802.6
 (SQL Overall)1786912892.15582919.3
 
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.