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

328 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
seers5513638(None) 
beers75628391beers
deers64930521deers
jeers124818131jeers
leers54828981leers
peers75130271peers
sears54744911sears
seders74420281seders
seeds64330061seeds
seeks94724641seeks
seels55632821seels
seems75525021seems
seeps74828751seeps
seer45547041seer_
sees45361051see_s
seres55448891seres
sers45746651s_ers
severs94121121severs
sewers94719711sewers
sheers94322401sheers
sneers64016171sneers
speers85019951speers
steers63820981steers
suers55128481suers
veers84521361veers
agers65027852agers
ameers84015572ameers
apers76629132apers
askers105915402askers
aspers86220312aspers
asters65631602asters
avers85127312avers
bears75739042bears
beefs105618562beefs
beeps95320972beeps
beer65635992beer_
beery105220122beery
bees65453382bee_s
beets76131442beets
biers76225222biers
ceders93817672ceders
cees65941592cee_s
ceres75540012ceres
cheers114518912cheers
dears65736882dears
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deer56739022deer_
dees56356632dee_s
deets65330242deets
defers105116942defers
deters74724682deters
doers65225712doers
dyers96617132dyers
ears46356592_ears
eels46536742_eels
eery76129622_eery
egers65120372egers
emeers83314182emeers
errs45622532_errs
ers36046282__ers
eses45336102ese_s
eskers105312222eskers
esters64627732esters
ewers86018822ewers
eyers86521332eyers
fears84829392fears
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602fee_s
feres86038182feres
fevers125414892fevers
fleers96015792fleers
freers94717302freers
gears64628692gears
geeks104915842geeks
gees55647882gee_s
goers65520252goers
hears86737372hears
heders104119762heders
heeds95420422heeds
heels85625532heels
heirs85618562heirs
heres86245902heres
hers75844872_hers
hewers123715272hewers
hexers165612752hexers
hoers85724922hoers
jeeps144715372jeeps
jeer115426462jeer_
jees115938542jee_s
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keets95123482keets
keirs95313672keirs
kiers95320092kiers
lears55938732lears
leeks95318892leeks
leer46239352leer_
leery85919132leery
lees45455882lee_s
leets54927122leets
legers74518312legers
lehrs86111132lehrs
lepers84817322lepers
levers94621322levers
liers55130402liers
meeds84920272meeds
meets74224612meets
meres75143572meres
meters85625832meters
nears55529422nears
needs65719632needs
neems77316292neems
neeps75617882neeps
omers76923192omers
osiers63412792osiers
overs85224792overs
oyers87620882oyers
pears75138612pears
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peer66238352peer_
peery105719442peery
pees65257372pee_s
peres76246642peres
peters86624592peters
piers75926332piers
queers153510772queers
rears54739652rears
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192ree_s
refers93921082refers
revers94529632revers
ruers515019412ruers
sabers85224732sabers
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scars75433532scars
sealers74323552sealers
seals54839692seals
seamers94719432seamers
seams75731662seams
sear47353842sear_
seas45755272s_eas
seaters74028932seaters
seats54844342seats
secern81010222secern
secerns987732secerns
secs65033892s_ecs
sects75622892sects
seder64826752seder_
see35772262see__
seed55549482see_d
seeders83017112seeders
seedy94821532seedy
seek85935482see_k
seekers113712332seekers
seel45042982see_l
seely84522632seely
seem65438562see_m
seemers93814332seemers
seen46943122see_n
seep66540342see_p
seepy104717972seepy
seeress7311572seeress
segos64919482segos
segs54933882s_egs
seifs85019332seifs
seiners74219272seiners
seis45542392s_eis
seisers73816392seisers
seizers164112502seizers
selfs85220242selfs
sellers73721302sellers
sells55134432sells
sels46345982s_els
semens84616962semens
semes75731582semes
semis74623532semis
senders83022352senders
sends65528242sends
senors63620782senors
septs75420602septs
ser36752402s_er_
sera46141392s_era
sere46153472s_ere
sered65737292sered
serer55935502serer
serest64831612serest
serf76340112s_erf
serfs84922012serfs
sergers83815632sergers
serry84824122serry
servers103214832servers
sets45549502s_ets
setters73822062setters
setts55124322setts
sevens93813662sevens
sever85426052sever_
severe94016082severe
sewars94018622sewars
sewer84426212sewer_
sews75836022s_ews
sexes126126222sexes
sexts125118382sexts
shears93820902shears
sheas86331792sheas
sheds96122702sheds
sheens95116992sheens
sheer84726892sheer_
sheets93918492sheets
sherd96321152sherd
sherds105614722sherds
shes75734352she_s
shewers134312042shewers
shews115924712shews
shiers94921752shiers
shoers94518322shoers
shyers124712202shyers
sieurs659042sieurs
sires55945372sires
sirs44338332s_irs
sivers95324152sivers
sizers155215812sizers
skeens103912912skeens
skees95023122skees
skeets104513252skeets
skegs105011232skegs
skeps115614252skeps
skewers14498372skewers
skews125413802skews
skiers104713692skiers
sleds64418852sleds
sleeks104512462sleeks
sleeps83913322sleeps
sleets64318872sleets
slews86220352slews
slurs54123372slurs
smears84714432smears
smeeks12428432smeeks
smerk115412722smerk
smerks12449712smerks
smews104612292smews
sneds65715352sneds
sneer54919952sneer_
sneery93610412sneery
soars54732512soars
sobers85218852sobers
sores55454282sores
sours55230502sours
sowers94923432sowers
spars75431542spars
spears84019472spears
specs96916672specs
speeds94316052speeds
speels85116392speels
speer74623902speer_
speirs85013232speirs
sperm93216012sperm
sperms102512602sperms
spewers124210652spewers
spews105015922spews
spiers84421742spiers
spurs74621522spurs
stars55836572stars
steeds73814882steeds
steeks103613702steeks
steels64117982steels
steeps85215192steeps
steer55423862steer_
stems75219952stems
steps76619882steps
stere55328542stere
steres63929532steres
stern55319122stern
sterns64616752sterns
stets55423912stets
stews85519142stews
stirs55921612stirs
subers85722642subers
suer45334032suer_
sues46247652sue_s
suets55126102suets
supers84622402supers
swears94114072swears
sweeps114110512sweeps
sweer84918572sweer_
sweets94214432sweets
tears55436462tears
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582tee_s
tiers55526522tiers
tyers86220052tyers
users55817572users
ushers94415532ushers
veeps104715722veeps
veer76229572veer_
veery115816252veery
vees75439432vee_s
vexers165210402vexers
viers85621952viers
wears86030302wears
webers11310942webers
weeds95222212weeds
weeks125017862weeks
weens85224052weens
weeps104120562weeps
weer75535092weer_
wees76249122wee_s
weets85427722weets
weirs84316492weirs
years84527672years
zees136331892zee_s

Search took 5 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.0931921408.6
2DLD Change Limit538003283.42015731.0
3Display Results3283280.1901726.3
 (SQL Overall)1786913283.70348255.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.