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

332 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
pored8523451(None) 
bored85034301bored
cored85044221cored
gored75227081gored
pared86946761pared
poked125425391poked
poled84934841poled
pooed85226241pooed
pore66451261pore_
pores75849031pores
porked134717621porked
ported94223241ported
posed85828411posed
poured95116741poured
poxed154817861poxed
sored66141781sored
spored94821791spored
acred87126352acred
adored84714232adored
aired66032922aired
bared85144482bared
boded95124962boded
boned85133242boned
booed85127272booed
bore66051332bore_
borer75131272borer
bores76448252bores
borked135117292borked
bowed114533422bowed
boxed154318612boxed
bred75130972_bred
cared86050092cared
cered85227442cered
chored125321882chored
coded95433182coded
coed77140542co_ed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cord76740922cor_d
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
cred76530882_cred
cured85932132cured
dared75935012dared
doled75430912doled
domed95423262domed
doped95326712doped
dore56353302dore_
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
dured75025402dured
eared65139502eared
erred65915672erred
fared95842342fared
fired94829742fired
forced126316522forced
ford86835492for_d
forded115020392forded
fore78351472fore_
foredo10510822foredo
fores85847102fores
forged115519322forged
forked145217142forked
formed125021172formed
foxed165115212foxed
gore55744962gore_
gores65740372gores
gorged95016982gorged
gormed105013832gormed
gyred105114092gyred
hared95742182hared
hired95226262hired
hoed87837982ho_ed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hoped115628182hoped
horde94623052horde
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982hosed
ired55131872_ired
joked175217912joked
jowed164724422jowed
joyed164811832joyed
kore85834162kore_
lobed86022132lobed
looed64626132looed
loped85128332loped
lord55032082lor_d
lorded84916732lorded
lore45850352lore_
lores55045402lores
loured74617402loured
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lured65427492lured
mired85729222mired
mooed85123982mooed
moored93814172moored
moped105424732moped
more67154522more_
morel75729092morel
mores76249642mores
moved114218152moved
mowed113629012mowed
mured85726702mured
normed95014542normed
nosed65524552nosed
noted65123842noted
oared65030652oared
odored8399222odored
ohed87825182_ohed
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
opted84914272opted
orad56031692_orad
orbed85516192_orbed
ore36661832_ore_
oread64619602_oread
ores46056682_ores
owed86833872_owed
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
ped66751522p__ed
peed76239182p_eed
peered93819482peered
pere66450262pere_
perea75026442perea
peres76246642peres
perked134617682perked
permed115217342permed
phoned124014552phoned
pied75035362p_ied
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
pled75231432p_led
plied85118592plied
plowed124213202plowed
ployed124310562ployed
pocked154818982pocked
pod66351482po__d
podded115012712podded
poem86225772po_em
poet65552902po_et
pogey116017892pogey
poind84217912poind
poised94918472poised
poke105335362poke_
poker115122882poker
pokes116133012pokes
pokey145318972pokey
pole65951302pole_
poler74431792poler
poles75351002poles
polled94022002polled
pome85636692pome_
pomes94833932pomes
ponced114314812ponced
pond75530492po_nd
ponded105218772ponded
pone65747532pone_
pones74547042pones
ponged105619352ponged
ponied94920702ponied
pood75934322po_od
poohed123912522poohed
pooled94619812pooled
pooped113915942pooped
poorer82613992poorer
pope85535612pope_
popes95933812popes
popped104117812popped
porch125918622porch
porgy116916122porgy
pork106929682por_k
porker124917542porker
porks115124142porks
porky145019332porky
porn65636022por_n
porno75120652porno
porns75527342porns
porny106020192porny
port66059632por_t
portend103411192portend
porter84224412porter
ports75934592ports
pose66441732pose_
poser75128772poser
poses74642762poses
posted93722492posted
potted94624012potted
poufed12449712poufed
pound84417862pound
pourer84516042pourer
pouted94021392pouted
power105325952power
powered132911642powered
poxes145325722poxes
pree67044732p_ree
preed85128112preed
prep86427672p_rep
prex135722972p_rex
prey96228482p_rey
prez156126312p_rez
pried84426862pried
probed114114822probed
prod76129502p_rod
proem94818272proem
prosed94921092prosed
proud84615482proud
proved125016032proved
puked124716222puked
puled84926522puled
pure65543332pure_
puree74632842puree
pureed95017802pureed
purer75127902purer
purged104918262purged
purled94520742purled
purred94218072purred
pursed95220882pursed
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
rared65738322rared
red46755802__red
roared75015392roared
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
scored94621132scored
sered65737292sered
shored105723642shored
shred98125612shred
sired66134282sired
snored74819542snored
soared74324292soared
soled65835172soled
sorbed94916512sorbed
sord56237202sor_d
sore47059532sore_
sorel56231442sorel
sorer56236572sorer
sores55454282sores
sorned74820042sorned
sorted74523712sorted
soured74921862soured
sowed94933862sowed
spared95427482spared
spired94921862spired
spoked134413892spoked
spoored104411292spoored
spore75428592spore_
spores84726612spores
sported104015432sported
stored75524212stored
tared69340052tared
tired65228902tired
toed56137042to_ed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
tore47359322tore_
tores55352672tores
toted64929482toted
toured74216152toured
towed95134582towed
toyed96019802toyed
tyred95816432tyred
vapored1336922vapored
voled95323722voled
voted93919142voted
vowed124424572vowed
wared96339872wared
whored135512122whored
wired95327642wired
wooed94419872wooed
word89832002wor_d
worded114316622worded
wore77144672wore_
worked145314702worked
world96915362world
wormed124314302wormed
wowed124023772wowed
yoked134821622yoked
yore76335942yore_
yores85031322yores
yowed1253025182yowed
zoned154020262zoned

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 Limit538003321.70331591.3
3Display Results3323320.0963458.3
 (SQL Overall)1786913321.89294445.6
 
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.