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

246 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
goers6552025(None) 
doers65225711doers
goer56827101goer_
goes55644091goe_s
gofers104711511gofers
gomers94116881gomers
goners74420171goners
gores65740371gores
hoers85724921hoers
agers65027852agers
aggers85817792aggers
apers76629132apers
avers85127312avers
beers75628392beers
biers76225222biers
boars75229602boars
boners84825432boners
boors74325012boors
borers85122682borers
bores76448252bores
bowers115523702bowers
boxers155013482boxers
coders95426982coders
coeds85920162coeds
coirs75221052coirs
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
cores76361852cores
cors66656442co_rs
covers114627962covers
cowers114625532cowers
deers64930522deers
doer57734702doer_
does56554472doe_s
doors65022132doors
dopers95522482dopers
dorrs65520592dorrs
dors56747602do_rs
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
dyers96617132dyers
egers65120372egers
eggers84612582eggers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
foes76543442foe_s
fores85847102fores
fours85521492fours
foyers125413132foyers
gaes56348032gae_s
gagers84021332gagers
gamers94420832gamers
gaolers83511562gaolers
gapers94520472gapers
gars55750742g_ars
gaters74728642gaters
gaurs66317992gaurs
gazers164516302gazers
gears64628692gears
geds66730822g_eds
geeks104915842geeks
gees55647882g_ees
gels56836102g_els
gems75329112g_ems
gens55740072g_ens
germ75428962g_erm
germs85118872g_erms
gets55442482g_ets
ghees95215552ghees
gibers95114662gibers
gies55641432gie_s
givers104817712givers
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glovers114310882glovers
glowers113412092glowers
gluers75011152gluers
gnars66718852gnars
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gobos86219382gobos
gobs76935572go_bs
godets8410932godets
gods65438052go_ds
gofer94814282gofer_
goffers14409212goffers
gogos77516522gogos
goiters84014442goiters
golds75421312golds
golems939322golems
golfers114410082golfers
golfs95616102golfs
gomer85220652gomer_
gonefs10439872gonefs
goner66025162goner_
gongs74921612gongs
goobers10219622goobers
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gophers1338982gophers
gor47848262go_r_
gore55744962go_re
gored75227082gored
gorgers94813642gorgers
gorm75529392go_rm
gorms85619592gorms
gorp75625902go_rp
gorps85316992gorps
gorse65926812go_rse
gorsy95915782go_rsy
gory86129662go_ry
gos47155132go__s
goths96513002goths
gougers94911762gougers
gourd71011902gourd
gourds8108252gourds
gouts64826172gouts
govern1036822govern
governs1136102governs
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
grees65132472grees
greys96614852greys
grocers103511252grocers
gropers104813852gropers
growers113612722growers
guars65021052guars
guess64213362guess
gyres94820322gyres
hers75844872_hers
hoars85925552hoars
hoer76533982hoer_
hoes75755732hoe_s
homers114821982homers
honers94324972honers
hopers114222972hopers
hosers95223972hosers
hours85422392hours
hovers124320252hovers
jeers124818132jeers
joes116635892joe_s
joeys15518042joeys
jokers175511192jokers
kiers95320102kiers
koels94613902koels
kors85933022ko_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
oes35866192_oe_s
ogees65119142ogees
oglers74313182oglers
ogres65818632ogres
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
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 Limit538002461.64032804.9
3Display Results2462460.0633904.8
 (SQL Overall)1786912462.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.