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 “piperine” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
piperine12201183(None) 
pipeline12149501pipeline
piperines131610691piperines
viperine13189711viperine
papering132213312papering
papyrine1546052papyrine
pelerine10313012pelerine
pipelike16166692pipelike
pipelined14164852pipelined
pipelines13178352pipelines
piperazine2354112piperazine
piperidine1553792piperidine
riverine11310802riverine
algerine9810283algerine
anserine8313093anserine
capering132414963capering
caprine11314233cap_rine
cicerone1247523cicerone
cinerin9313823cinerin_
cinerins10414103cinerins
ciphering17217703ciphering
citrine92514023ci_trine
diapering1339033diapering
dimerize2048113dimerize
epergne1046143_epergne
eserine7415903_eserine
ferine96422583__ferine
fiberize2246143fiberize
figurine1245603figurine
hipline12311423hip_line
hyperfine2045913hyperfine
kippering18205443kippering
leporine1049303leporine
libertine1147433libertine
lierne638023li_er_ne
lifeline11167663lifeline
lippering14217883lippering
livering122012383livering
mitering113015403mitering
nidering10510483nidering
niterie7313743niteri_e
pampering1638383pampering
papaverine1752833papaverine
paperiness1446133paperiness
passerine1147083passerine
paupering1437273paupering
pauperize2244763pauperize
peerie83617893p_eeri_e
peering103520353p_eering
pelerines11311843pelerines
peperoni1246273peperoni
peppering1337083peppering
pepsine11310603pep_sine
peregrine1247043peregrine
perinea9313033__perinea
petering112516813petering
picoline12310853picoline
picrite111911313pi_crite
piecing12410453pi_ecing
pieing93917653pi_e_ing
pierce104010393pi_er_ce
piercing1346663pi_ercing
pieridine1246143pi_eridine
pilfering1536393pilfering
pimpernel1542653pimper_nel
pinecone1246063pinecone
pinelike14188613pinelike
pinene82915643pine__ne
pineries102419083pineries
pipeage1236203pipe_age
pipefish1844533pipefish
piper96523193piper___
piperazines2453493piperazines
piperidines1653253piperidines
piperonal1344733piperonal
pipers104318663piper__s
pipestone1345503pipestone
pipette1137943pipe_tte
pipetting1435513pipetting
piping114017453pip__ing
pipkin14248603pip_kin_
pipkins15328183pip_kins
pippin92810303pip_pin_
pipping113414743pip_ping
pippins10319753pip_pins
piscine11610973pi_scine
popelike16177853popelike
poperies12316793poperies
powering142210803powering
preprice1488873preprice
preprint12314183preprint
prerinse1038633p_rerinse
pterin81014153p_terin_
pterins9812993p_terins
puerile9310093p_uerile
purine85321893__purine
ripening1138573ripening
serine65432673__serine
sideline91011093sideline
siderite9411363siderite
simpering1449293simpering
spermine12311433_spermine
spiering112713353spi_ering
superfine14411443superfine
supering11317683supering
tapeline10310363tapeline
tapering112112503tapering
tiering8315253ti_ering
timeline1039243timeline
uterine7315193_uterine
vicereine1444043vicereine
viperish1655893viperish
vitrine102511363vi_trine
viverrine1544673viverrine
vomerine1347683vomerine
yperite1249893_yperite
zibeline1946363zibeline
zippering23215203zippering

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621187.72018932.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.18621828.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.