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

133 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
pipeline1214950(None) 
pipelike16166691pipelike
pipelined14164851pipelined
pipelines13178351pipelines
piperine122011831piperine
hipline12311422hip_line
lifeline11167662lifeline
picoline12310852picoline
pinelike14188612pinelike
piperines131610692piperines
popelike16177852popelike
sideline91011092sideline
tapeline10310362tapeline
timeline1039242timeline
viperine13189712viperine
zibeline1946362zibeline
airline7315033ai_rline
apelike13310533_apelike
baseline10310753baseline
beeline93314723_beeline
biplane1139033bip_lane
blueline1036873blueline
capelin11510973capelin_
capelins12311133capelins
cipolin1148783cipolin_
cipolins1238033cipolins
cupeling1338863cupeling
dateline9810353dateline
driveline1345353driveline
feline94820143__feline
figuline1256033figuline
fishline14237583fishline
guideline1143983guideline
hiplike1637603hip_like
hiplines13310593hip_lines
hireling121210993hireling
icelike1337173_icelike
incline9314643_incline
isoline7314013_isoline
kitelike1135733kitelike
libeling1139873libeling
lifelike15166223lifelike
lifelines12147053lifelines
linelike12159003linelike
liplike1337283lip_like
lobeline1039963lobeline
midline102315103mi_dline
milline92519113mi_lline
myeline1238253_myeline
nepheline1445543nepheline
opaline9412483_opaline
paneling111013623paneling
papering132213313papering
papyrine1546053papyrine
peeling102919873p_eeling
pelerine10313013pelerine
pelite84323003__pelite
pemoline12310273pemoline
pepsine11310603pep_sine
petaline10314883petaline
picholine1646643picholine
pickling17239203pickling
picolin11310883picolin_
picolines1339623picolines
picolins1239853picolins
piddling13208953piddling
piecing12410453pi_ecing
pieing93917653pi_e_ing
pieplant1268733pieplant
piffling1745133piffling
piglike14157313pi_glike
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
pinecone1246063pinecone
pineland1145893pineland
pinene82915643pine__ne
pipeage1236203pipe_age
pipefish1844533pipefish
pipeless12107663pipeless
pipelining1543973pipelining
piperazine2354113piperazine
piperidine1553793piperidine
pipestone1345503pipestone
pipette1137943pipe_tte
pipetting1435513pipetting
piping114017453pip__ing
pipkin14248603pip_kin_
pipkins15328183pip_kins
pippin92810303pip_pin_
pipping113414743pip_ping
pippins10319753pip_pins
piscine11610973pi_scine
pisolite10310373pisolite
plotline1037643plotline
poplin10413483pop_lin_
poplins11313153pop_lins
poppling12227323poppling
potline91015233p_otline
praline93019743p_raline
prelife1279943p_relife
proline92321593p_roline
purline93516533p_urline
reline65434353__reline
ridgeline11174723ridgeline
ripening1138573ripening
rippling13197573rippling
riverine11310803riverine
ropelike14157853ropelike
sepaline10311343sepaline
sidelined11125883sidelined
sideliner10126013sideliner
sidelines10109683sidelines
sideling101012183sideling
spieling113212523spi_eling
spikelike14103873spikelike
spinelike1585353spinelike
spline86020533_sp_line
tapelike1437493tapelike
tapelines1138463tapelines
tidelike1336743tidelike
tilelike1237053tilelike
timelines1148443timelines
tippling13196703tippling
topline92313183top_line
vaseline1138613vaseline
viselike1536923viselike
vitelline1285853vitelline
vituline1147093vituline
wifelike18135253wifelike
wirelike15167493wirelike
zibelines2045733zibelines
zibelline2044303zibelline

Search took 8 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.1531167915.0
2DLD Change Limit1461621337.76618820.8
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.96522434.5
 
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.