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 “pores” 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
pores7584903(None) 
bores76448251bores
cores76361851cores
fores85847101fores
gores65740371gores
lores55045401lores
mores76249641mores
ores46056681_ores
pares77164481pares
peres76246641peres
pokes116133011pokes
poles75351001poles
pomes94833931pomes
pones74547041pones
popes95933811popes
pore66451261pore_
pored85234511pored
porks115124141porks
porns75527341porns
ports75934591ports
poses74642761poses
poxes145325721poxes
pyres105523881pyres
sores55454281sores
spores84726611spores
tores55352671tores
yores85031321yores
acres76327762acres
adores74420722adores
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
bodes84935102bodes
boles75448602boles
bones76446532bones
boras75938302boras
bore66051332bore_
boreas85421732boreas
bored85034302bored
borer75131272borer
borers85122682borers
borks115727702borks
borts76735452borts
boxes145625072boxes
byres104421382byres
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
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dures65635922dures
epodes94315562epodes
eposes84418782eposes
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
horas86333102horas
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
moras76438782moras
more67154522more_
morel75729092morel
morels84820012morels
morns75527442morns
mors65950062mor_s
morse76032702morse
morts75533562morts
motes75944002motes
moues75732842moues
moves106128422moves
mures75937222mures
nares55544152nares
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noris54928272noris
norms76019312norms
noses55435642noses
notes55034582notes
obes66036832_obes
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
paces96741112paces
padres95016982padres
pages85235072pages
pales75753802pales
panes76148692panes
paras76143042paras
pards85634332pards
pare66760842pare_
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
parers85530742parers
pareu74928742pareu
pareus85420742pareus
parges94529542parges
paries84742512paries
paris75145942paris
parks116134462parks
parles86334402parles
parrs75928672parrs
pars67560792par_s
parse75236992parse
parses85534702parses
parts77743372parts
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
pedes85327292pedes
peers75130272peers
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penes75839222penes
peones83821042peones
pere66450262pere_
perea75026442perea
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pes57259782p__es
phones114121212phones
phoresy1534652phoresy
piers75926332piers
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pirns76020092pirns
pixes144323172pixes
plies74526512plies
pocks135022962pocks
pods76540152po_ds
poem86225772po_em
poems95715552poems
poesy105014062po_esy
poet65552902po_et
poets76024442poets
pogey116017892pogey
pogeys124110352pogeys
pogies94123542pogies
pois66539042po_is
poise75127892poise
poises84226542poises
poke105335362poke_
poked125425392poked
poker115122882poker
pokers124617922pokers
pokey145318972pokey
pokeys15529512pokeys
pokies125921332pokies
pole65951302pole_
poled84934842poled
poleis86018352poleis
poler74431792poler
polers84225642polers
polies84034582polies
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pome85636692pome_
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponces104720842ponces
ponds85323402ponds
pone65747532pone_
pongs85526342pongs
ponies84833462ponies
pons65850602po_ns
pontes83627852pontes
poods85124752poods
pooed85226242pooed
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poorer82613992poorer
poorest9312772poorest
pooris83916842pooris
poos65949112po_os
pooves113914712pooves
pope85535612pope_
pops86340952po_ps
porch125918622porch
porches143815672porches
porgies103017002porgies
porgy116916122porgy
porism104518062porism
pork106929682por_k
porked134717622porked
porker124917542porker
porkers134314932porkers
porkies133416492porkies
porky145019332porky
porn65636022por_n
porno75120652porno
pornos85015252pornos
porny106020192porny
porose84818742porose
porous84419482porous
port66059632por_t
ported94223242ported
porter84224412porter
porters93722702porters
pose66441732pose_
posed85828412posed
poser75128772poser
posers84223972posers
posies84431432posies
posse74722272posse
posses85128802posses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
poured95116742poured
pourer84516042pourer
pourers93513672pourers
pours74623182pours
pouts75530322pouts
power105325952power
powers113822322powers
pows95537662po_ws
poxed154817862poxed
pree67044732p_ree
prees75937172prees
prep86427672p_rep
preps96220692p_reps
presa74319042p_resa
prese75228382p_rese
press75425952p_ress
prest75736352p_rest
prex135722972p_rex
prey96228482p_rey
preys105717782p_reys
prez156126312p_rez
pries74339532pries
proas75028802proas
probes104119452probes
prods85523552prods
proem94818272proem
proems104711162proems
profs105120892profs
progs86624152progs
proles84627202proles
proms95426412proms
props95726882props
pros65742782p_ros
prose75835122prose
proses84733472proses
pross76529402pross
proves114322252proves
prows106327012prows
ptoses83514672ptoses
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pure65543332pure_
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purges94421762purges
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
purse76028892purse
purses84826372purses
puses75532202puses
pyes95528992p_yes
pyoses114314302pyoses
pyre94925552pyre_
pyrex175211212pyrex
pyros105718292pyros
pyxes175911402pyxes
rares55247442rares
res35565042__res
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scores84725922scores
seres55448892seres
shores94830412shores
sires55945372sires
snores64324322snores
sokes95031422sokes
soles55547922soles
sones55444142sones
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sore47059532sore_
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236592sorer
sorest65028002sorest
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
spares84834552spares
spires84628112spires
splores91910952splores
spodes94817432spodes
spokes124417212spokes
spore75428592spore_
spored94821792spored
sports84619182sports
stores65533662stores
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
worms105320762worms
worse86525262worse
worses95522952worses
worts88631182worts
yokes125223022yokes
yore76335942yore_
yowes114926372yowes
zones145528042zones
zoris145320012zoris

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.326548131.9
2DLD Change Limit538005062.23624060.8
3Display Results5065060.1403614.3
 (SQL Overall)1786915062.70266132.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.