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

403 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
wore7714467(None) 
bore66051331bore
core67263111core
dore56353301dore
fore78351471fore
gore55744961gore
kore85834161kore
lore45850351lore
more67154521more
ore36661831_ore
pore66451261pore
sore47059531sore
swore84920811swore
tore47359321tore
ware76254721ware
were76238331were
whore116018041whore
wire75839811wire
woe66651241wo_e
woke115527961woke
word89832001word
work115528841work
worm96129481worm
worn75631751worn
worse86525261worse
wort76654751wort
wove105624311wove
yore76335941yore
acre67330772acre
adore65723662adore
afore85818602afore
are37874572_are
aware86420022aware
awoke124912002awoke
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
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
owse76321622owse
pare66760842pare
pere66450262pere
poke105335362poke
pole65951302pole
pome85636692pome
pone65747532pone
pope85535612pope
pored85234512pored
pores75849032pores
pork106929682pork
porn65636022porn
port66059632port
pose66441732pose
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
rewore938030152rewore
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
sware85828212sware
sword95214112sword
sworn86115302sworn
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
wade85237062wade
wae67556952w_ae
wage84834082wage
wake114935702wake
wale74546432wale
wame95035482wame
wane76344712wane
war67262422war_
ward86542252ward
wared96339872wared
wares88250582wares
wark115737772wark
warm95935672warm
warn75239322warn
warp95635002warp
wars78659802wars
wart77866082wart
wary106740012wary
wave105234732wave
we57043452w__e
wee66760812w_ee
weer75535092weer
wert79749822wert
whee105429592whee
where117019422where
whole114418092whole
whored135512122whored
whores125617102whores
whorl114612452whorl
whort114623692whort
whose114914532whose
wide85235402wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wiry
wise75737342wise
wite75443272wite
wive105931752wive
wo510447762wo__
woad85523942woad
wodge107212922wodge
woes76440662woes
wog76242732wo_g
wogs86531402wogs
wok106334172wo_k
woken124614972woken
woks116224902woks
wold85429072wold
wolf105729562wolf
womb117022232womb
women104619252women
won66252062wo_n
wonk116125302wonk
wons74942042wons
wont75842502wont
woo66949802wo_o
wood85329382wood
wooed94419872wooed
wooer84316692wooer
woof106532422woof
wool76427372wool
woos76238802woos
wop87145132wo_p
wops96634152wops
worded114316622worded
words95425072words
wordy126916162wordy
worked145314702worked
worker134715112worker
works125621902works
world96915362world
wormed124314302wormed
wormer114514912wormer
worms105320752worms
wormy137514252wormy
worry116114332worry
worsen95513872worsen
worser95117522worser
worses95522952worses
worset96726582worset
worst86330132worst
worth117120522worth
worts88631182worts
wos66953532wo_s
wost76544362wost
wot610467482wo_t
wots76342892wots
woven115215172woven
wow96643472wo_w
wowed124023772wowed
wows104633492wows
wren78221682w_ren
wrote84717482wrote
wry96524702w_ry
wye96331972w_ye
wyle105519382wyle
wyte106018642wyte
yare75636942yare
yoke115626392yoke
yores85031322yores
yowe106728742yowe
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.0931921408.6
2DLD Change Limit298724031.42320992.3
3Display Results4034030.2501612.0
 (SQL Overall)1786914031.766101184.0
 
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.