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

506 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
bores7644825(None) 
bares75457131bares
bodes84935101bodes
boles75448601boles
bones76446531bones
boras75938301boras
bore66051331bore_
boreas85421731boreas
bored85034301bored
borer75131271borer
borers85122681borers
borks115727701borks
borts76735451borts
boxes145625071boxes
byres104421381byres
cores76361851cores
fores85847101fores
gores65740371gores
lores55045401lores
mores76249641mores
ores46056681_ores
pores75849031pores
sores55454281sores
tores55352671tores
yores85031321yores
abodes94417512abodes
aborts84916182aborts
aboves114512842aboves
acres76327762acres
adores74420712adores
apres75426402apres
arbores94016032arbores
ares45871022_ares
aures55137092aures
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
barbes104526232barbes
barbs95928192barbs
bardes95026932bardes
bards87139642bards
bare65460522bare_
bared85144482bared
barer74535802barer
barest85327692barest
barfs104826002barfs
barges94528252barges
barks115735812barks
barms96128462barms
barns76335142barns
barres84427542barres
bars66564092bar_s
baryes116218502baryes
bases75644352bases
bates75846342bates
beers75628392beers
bees65453382b_ees
benes75536232benes
beret74946362beret
berets85822522berets
bergs84718042bergs
berks115423122berks
bermes106023002bermes
berms95323662berms
bes56557432b__es
beses75830722beses
bices95029962bices
bides85536772bides
biers76225222biers
bikes117529472bikes
biles75542142biles
bines76946792bines
biomes103815252biomes
birds85421332birds
birks114920302birks
birles84920642birles
birls74023162birls
biros75325132biros
birrs74917102birrs
birse74517402birse
birses84717732birses
bises75435622bises
bites75641172bites
bizes165923662bizes
blares85021632blares
blokes123813882blokes
blues75127042blues
boards94616932boards
boars75229602boars
boarts84716872boarts
boas66150832bo_as
boats75635152boats
bobs86340642bo_bs
bocces123912022bocces
boches134618522boches
bocks134526572bocks
bode75838752bode_
boded95124962boded
bodies94524142bodies
bods76244712bo_ds
boffs134915502boffs
bogey115220232bogey
bogeys124510912bogeys
bogies94724312bogies
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
bohea105013732bohea
boheas114013212boheas
bohos105618252bohos
boils75427192boils
boites84322702boites
bolas74733762bolas
bolds85825282bolds
bole66448692bole_
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bombes124916822bombes
bombs115818822bombs
bonds86126842bonds
bone65949322bone_
boned85133242boned
boner75133082boner
boners84825432boners
boney105227312boney
bongs87828422bongs
bonks116326462bonks
bonnes85621452bonnes
bonus75324322bonus
bonzes175116102bonzes
boobs96221992boobs
booed85127272booed
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
boozes174916522boozes
bops86037982bo_ps
bora66141632bor_a
boraces113716852boraces
borages103917162borages
boral75831702boral
borals86721912borals
boranes93720402boranes
borates94823012borates
borax145918722borax
boraxes163511632boraxes
bordel94514572bordel
bordels103911972bordels
border94419972border
borders104317532borders
boreal84817212boreal
boreen8314312boreen
boreens9310402boreens
boric98024222boric
borides10515152borides
bork106933822bor_k
borked135117292borked
born67338412bor_n
borne77926792borne
boron76727142boron
borons85520542borons
bort65960962bor_t
borty105522832borty
bortz165722202bortz
bortzes1838222bortzes
bos57966812bo__s
boshes114721882boshes
bosks115218852bosks
boss65938342bo_ss
bosses85925402bosses
botas75328782botas
botel75121862botel
botels84815802botels
bots66453952bo_ts
botts75224862botts
boules84925972boules
bourgs9459992bourgs
bournes93615022bournes
bourns84114062bourns
bourse84414332bourse
bourses94014302bourses
bouse75931852bouse
bouses84931782bouses
bouts75131312bouts
bowed114533422bowed
bowel105621202bowel
bowels114315592bowels
bower107328182bower
bowers115523702bowers
bowls106121432bowls
bows96242862bo_ws
bowse105420632bowse
bowses115718862bowses
boxed154318612boxed
boxer145016522boxer
boxers155013482boxers
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
braes75735052braes
bras65746452b_ras
bred75130972b_red
bree67241262b_ree
brees75632552brees
bren65629562b_ren
brens75823362b_rens
brew95023562b_rew
brews105617072b_rews
bries74942152bries
bris65539612b_ris
bromes104719762bromes
broos75126412broos
bros65635662b_ros
brose75227032brose
broses86524402broses
brows105425982brows
buras74736292buras
burbs95423492burbs
burds84626062burds
buret77444012buret
burets84321262burets
burgs84924092burgs
buries84633272buries
burkes124421312burkes
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
burse75527252burse
burses84425512burses
buses75936012buses
butes714535872butes
byes95230532b_yes
byre95023852byre_
byrls105711232byrls
bytes105217492bytes
cares77369182cares
ceres75540012ceres
chores114828022chores
cires74932912cires
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cords86030622cords
core67263112core_
cored85044222cored
corer75538872corer
corers85231072corers
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
corse75036182corse
corses84433462corses
corves115122522corves
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crores86121162crores
cures75645432cures
dares66146702dares
doers65225712doers
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
dore56353302dore_
dories75232362dories
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dures65635922dures
eyres84921772eyres
fares85852872fares
feres86038182feres
fires85740752fires
foes76543442fo_es
forbs105720802forbs
forces114422132forces
fords95328182fords
fore78351472fore_
forest94926742forest
forges105024262forges
forks125324682forks
formes114623712formes
forms105327052forms
fortes95327182fortes
forts86034452forts
foxes156321092foxes
froes86126692froes
goers65520252goers
goes55644092go_es
gore55744962gore_
gored75227082gored
gorges85321892gorges
gorms85619592gorms
gorps85316992gorps
gorse65926812gorse
gorses74723292gorses
goxes135018262goxes
gyres94820322gyres
hares86255542hares
heres86245902heres
hires86134342hires
hoers85724922hoers
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
horas86333092horas
hordes104921632hordes
horns86125332horns
horse86132652horse
horses94729342horses
hoses85443172hoses
howes114730262howes
ires45639282_ires
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
koras95927112koras
kore85834162kore_
kors85933012kor_s
lares54852632lares
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lords64923502lords
lore45850352lore_
lories64933042lories
loris55329152loris
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lures56138532lures
lyres85019962lyres
mares76457632mares
meres75143572meres
mires75640882mires
modes85537412modes
moires8915632moires
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
moras76438762moras
more67154522more_
morel75729092morel
morels84820012morels
morns75527442morns
mors65950062mor_s
morse76032702morse
morts75533562morts
motes75944002motes
moues75732842moues
moves106128422moves
mures75937212mures
nares55544152nares
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noris54928272noris
norms76019302norms
noses55435642noses
notes55034582notes
obes66036832_obes
oboes75717712oboes
oboles83815832oboles
odes57243242_odes
oes35866192_o_es
ogres65818632ogres
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
orbs66626252_orbs
orcs67025432_orcs
ore36661832_ore_
orles55326212_orles
ors35750112_or_s
orts46538332_orts
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pares77164482pares
peres76246642peres
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
poxes145325722poxes
pyres105523882pyres
rares55247442rares
rebores95319162rebores
res35565042__res
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scores84725922scores
seres55448892seres
shores94830402shores
sires55945372sires
snores64324312snores
sokes95031422sokes
soles55547922soles
sones55444142sones
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sore47059532sore_
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236572sorer
sorest65027992sorest
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
spores84726612spores
stores65533642stores
tares57456562tares
tires55437492tires
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
toras55540372toras
torcs75123762torcs
tore47359322tore_
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torse55833332torse
torses64727952torses
tortes64826052tortes
torts56138122torts
torus54329762torus
totes55139682totes
tres46542902_tres
tsores65113662tsores
tyres84725232tyres
vires84529682vires
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wares88250582wares
whores125617102whores
wires86034912wires
woes76440662wo_es
words95425072words
wore77144672wore_
works125621902works
worms105320752worms
worse86525262worse
worses95522952worses
worts88631182worts
yokes125223022yokes
yore76335942yore_
yowes114926372yowes
zones145528042zones
zoris145320012zoris

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 Filter178691538000.0931921408.6
2DLD Change Limit538005061.62633087.3
3Display Results5065060.1403614.3
 (SQL Overall)1786915061.85996122.1
 
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.