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

236 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
piped10512316(None) 
biped104718831biped
pied75035361pi_ed
piked125623311piked
piled85232991piled
pimped134913481pimped
pined85935321pined
pipe86434431pipe_
piper96523191piper
pipes96030141pipes
pipet95533321pipet
pipped104516541pipped
riped85226431riped
siped84927681siped
wiped114722081wiped
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aliped95414282aliped
amped104820512amped
aped78538152_aped
bided95424962bided
biked125320032biked
bipeds11458052bipeds
bipod104410822bipod
caped104931802caped
cited84421952cited
coped105036842coped
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dipped123517492dipped
dived106321372dived
doped95326712doped
duped95118322duped
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
fixed165416952fixed
gaped96123532gaped
gibed96215962gibed
gied64631982gi_ed
gimped123911472gimped
gipped124815902gipped
griped104114712griped
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hipped144317692hipped
hired95226262hired
hived125217912hived
hoped115628182hoped
hyped145313332hyped
iced78721892_iced
imped105117982imped
ired55131872_ired
japed156217632japed
jibed155114162jibed
jived165115042jived
kipped153114572kipped
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limped114817122limped
lined64934642lined
lipe66839732lipe_
lipid85916172lipid
lipped114419542lipped
lisped94113422lisped
lived95523722lived
loped85128332loped
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mixed155717252mixed
moped105424732moped
nided75920872nided
nipped113615852nipped
nixed135714222nixed
oiled64429472oiled
oped76230152_oped
opined95113852opined
paced106931682paced
paged95926782paged
paiked135113432paiked
pained95622852pained
paired95017522paired
paled85538722paled
palped114513642palped
paned85437182paned
paper95128662paper
pared86946762pared
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
ped66751522__ped
peed76239182p_eed
peeped113915382peeped
peined94918842peined
peised94817682peised
pepped103113392pepped
pice84641092pice_
picked154421312picked
pie55457402pi_e_
pieced113912102pieced
pier66035292pi_er
pies66949602pi_es
pigged114214152pigged
pigpen1136582pigpen
pike106335212pike_
piker115622842piker
pikes115031032pikes
pile65649692pile_
pilea75123952pilea
pilei74021782pilei
piles74742612piles
pilled94222752pilled
pimpled14289182pimpled
pine67755712pine_
pines76048862pines
piney105727502piney
pinged104321382pinged
pinked134819882pinked
pinned94818382pinned
pip78051042pip__
pipal95118352pipal
pipers104318662pipers
pipets105714772pipets
pipier104913982pipier
pipit95224872pipit
pips85837132pip_s
pipy115421512pip_y
piqued1836212piqued
pished124817062pished
pissed94816932pissed
pithed124615612pithed
pitied94017252pitied
pitted94319592pitted
pixel143911902pixel
pixes144323172pixes
pled75231432p_led
plied85118592plied
poised94918472poised
poked125425392poked
poled84934842poled
pooed85226242pooed
pooped113915942pooped
pope85535612pope_
popes95933812popes
popped104117812popped
pored85234512pored
posed85828412posed
poxed154817862poxed
preed85128112preed
priced115018882priced
prided103618032prided
pried84426862pried
primed115118912primed
primped14479152primped
prised94322202prised
prized184415392prized
puked124716222puked
puled84926522puled
pulped114612532pulped
pumped133915562pumped
pupped105013272pupped
raped85334622raped
riced85825542riced
riled65833252riled
rimed84826372rimed
ripe66038922ripe_
ripen75619262ripen
riper74328402riper
ripes75435772ripes
ripped114419012ripped
rived94825612rived
roped84630802roped
sided74825952sided
sipe67341042sipe_
sipes76036952sipes
sipped113720632sipped
sired66134282sired
sited65130742sited
sized155519242sized
sliped95417062sliped
sniped94913482sniped
sped76031492_sped
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
stiped94517072stiped
swiped123811092swiped
taped85327422taped
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tipped114418262tipped
tired65228902tired
toped85631312toped
typed115815452typed
umped104717272umped
upped103715162upped
urped84615282urped
viced115118182viced
vied86328632vi_ed
vined95626152vined
viper105017302viper
vised95518762vised
wifed125117742wifed
wiled95231552wiled
wimped144211512wimped
wined94434182wined
wipe94830282wipe_
wiper105421292wiper
wipes104827082wipes
wired95327642wired
wised95123342wised
wisped123411892wisped
wited94727142wited
wived125121502wived
yipe96722172yipe_
yipes106017842yipes
yipped143613282yipped
zipped203612982zipped

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.0961861364.6
2DLD Change Limit538002361.85628987.1
3Display Results2362360.0962458.3
 (SQL Overall)1786912362.04887251.5
 
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.