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

342 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
yore7633594(None) 
bore66051331bore
core67263111core
dore56353301dore
fore78351471fore
gore55744961gore
kore85834161kore
lore45850351lore
more67154521more
ore36661831_ore
pore66451261pore
sore47059531sore
tore47359321tore
wore77144671wore
yare75636941yare
yoke115626391yoke
yores85031321yores
yowe106728741yowe
acre67330772acre
adore65723662adore
afore85818602afore
are37874572_are
bare65460522bare
bode75838752bode
bole66448692bole
bone65949322bone
bora66141632bora
bored85034302bored
borer75131272borer
bores76448252bores
bork106933822bork
born67338412born
borne77926792borne
bort65960962bort
byre95023852byre
care66968372care
cere66741472cere
chore105126762chore
cire65836372cire
code77347732code
coke107038382coke
cole66956112cole
come87547702come
cone67256962cone
cope86847382cope
cor59960942cor_
cord76740922cord
cored85044222cored
corer75538872corer
cores76361852cores
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
corse75036182corse
cory96941512cory
cote66648732cote
cove95837072cove
crore74922862crore
cure66149122cure
dare55848862dare
dere56845902dere
dire56644142dire
doe47361952do_e
doer57734702doer
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dor47253922dor_
dork96531462dork
dorm76834622dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
dure56341812dure
ere36352772_ere
eyre75525252eyre
fare76354462fare
fere76342232fere
fire76245592fire
foe66350812fo_e
for66952072for_
fora75937392fora
forb97131332forb
force105324272force
ford86835492ford
fores85847102fores
forge95126942forge
fork115930942fork
form95836872form
forme105225992forme
fort76456442fort
forte86131462forte
froe75329992froe
frore86218802frore
goer56827102goer
gone55639042gone
gor47848262gor_
gored75227082gored
gores65740372gores
gorge76423892gorge
gorm75529392gorm
gorp75625902gorp
gorse65926812gorse
gory86129662gory
gyre84722762gyre
hare76255732hare
here76447102here
hire75538962hire
hoe67562722ho_e
hoer76533982hoer
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
hora76136552hora
horde94623052horde
horn76735612horn
horse86132652horse
hose76547242hose
hove107132222hove
howe106734102howe
ire36943172_ire
joe106642352jo_e
joke155926162joke
jole117233822jole
kor76538892kor_
kora86431552kora
kors85933012kors
lire47845292lire
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lope65941922lope
lord55032082lord
lores55045402lores
lorn46435252lorn
lory75931712lory
lose45144582lose
love75234762love
lowe75435312lowe
lure45142462lure
lyre75623792lyre
mare64759322mare
mere67244442mere
mire66748222mire
mode75840302mode
moire71017312moire
moke106234222moke
mole66251832mole
mome85239352mome
mope86838042mope
mor56855002mor_
mora66641272mora
morae75831192morae
morel75729092morel
mores76249642mores
morn66237562morn
mors65950062mors
morse76032702morse
mort66758832mort
mote67048082mote
moue65835572moue
move96630722move
mure65941332mure
myope124010972myope
node513036882node
nome66038422nome
none45743172none
nope65934192nope
nor38048822nor_
nori47133142nori
norm66429812norm
nose46739362nose
note46239962note
obe56638642_obe
ode47446582_ode
oe28473062_o_e
ogre56320742ogre
oke75839482_oke
ole37155212_ole
one37050912_one
oorie53026362oorie
ooze136420602ooze
ope56845242_ope
or27354732_or_
ora37250832_ora
orb55736862_orb
orc57034922_orc
ores46056682_ores
orle45630462_orle
ors35750112_ors
ort39465232_ort
ose38147342_ose
owe67041032_owe
oyer75927652oyer
pare66760842pare
pere66450262pere
poke105335362poke
pole65951302pole
pome85636692pome
pone65747532pone
pope85535612pope
pored85234512pored
pores75849032pores
pork106929682pork
porn65636022porn
port66059632port
pose66441732pose
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
robe65335642robe
rode55844302rode
roe36861072ro_e
role45851822role
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
score75526732score
sere46153472sere
shore85432642shore
sire46150412sire
snore55424952snore
soke85436262soke
sole46053672sole
some66040382some
sone46649982sone
sora45746912sora
sorb68333042sorb
sord56237202sord
sored66141782sored
sorel56231442sorel
sorer56236572sorer
sores55454282sores
sori46039832sori
sorn46641062sorn
sort46264812sort
spore75428592spore
store56333812store
sure45447412sure
swore84920812swore
tare45957622tare
tire46143352tire
toe310166852to_e
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
tor39261682tor_
tora47545992tora
torc66333352torc
tores55352672tores
tori47542152tori
torn46044252torn
toro48045682toro
torr45630902torr
tors46157382tors
torse55833332torse
tort46967462tort
torte55431702torte
tory75840542tory
tote46643672tote
tyre75428252tyre
voe67739052vo_e
vole75236982vole
vote74728622vote
ware76254722ware
were76238332were
whore116018042whore
wire75839812wire
woe66651242wo_e
woke115527962woke
word89832002word
work115528842work
worm96129482worm
worn75631752worn
worse86525262worse
wort76654752wort
wove105624312wove
yar67253832yar_
yard85633252yard
yarer84321572yarer
yarn75230042yarn
ye57650062y__e
yerk116222082yerk
yipe96722172yipe
yird87018982yird
yirr76513572yirr
yo59748552yo__
yob87945272yo_b
yobs96028082yobs
yock135924612yock
yod77545502yo_d
yodel94714082yodel
yodh119916102yodh
yodle94515042yodle
yods86531182yods
yoga87418052yoga
yogee9518062yogee
yogh116616142yogh
yogi86120422yogi
yok107335242yo_k
yoked134821622yoked
yokel124812612yokel
yokes125223022yokes
yoks116223742yoks
yolk116218992yolk
yom88043442yo_m
yon67348952yo_n
yond86122312yond
yoni77524392yoni
you66641822yo_u
your78623432your
yourn87512772yourn
yours85217872yours
yous76230652yous
youse85322232youse
yow96945292yo_w
yowed1253025182yowed
yowes114926372yowes
yowie114616452yowie
yowl105820952yowl
yows106433122yows
yule75725142yule
yurt76435042yurt
zone135231082zone
zori137722922zori

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298723421.01329488.6
3Display Results3423420.0804275.0
 (SQL Overall)1786913421.173152336.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.