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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
pipelines1317835(None) 
pipeline12149501pipeline_
pipelined14164851pipelined
piperines131610691piperines
hiplines13310592hip_lines
lifelines12147052lifelines
picolines1339622picolines
pipelike16166692pipelike_
piperine122011832piperine_
sidelines10109682sidelines
tapelines1138462tapelines
timelines1148442timelines
zibelines2045732zibelines
airlines8312793ai_rlines
baselines1138603baselines
beelines103312803_beelines
biplanes1238573bip_lanes
bluelines1145833bluelines
capelins12311133capelin_s
cicelies1269753ciceli_es
cipolins1238033cipolin_s
datelines1088853datelines
drivelines1444593drivelines
felines104718073__felines
figulines1345043figulines
fishlines15246843fishlines
guidelines1243363guidelines
hipline12311423hip_line_
hirelings1365763hirelings
inclines10313143_inclines
isolines8312303_isolines
lifeline11167663lifeline_
liveliness1345633liveliness
lobelines1138563lobelines
midlines112613333mi_dlines
millines102718063mi_llines
myelines1337123_myelines
nephelines1544843nephelines
opalines10311423_opalines
panelings12107453panelings
paperiness1446133paperiness
peelings11339523p_eelings
pelerines11311843pelerines
pelites93821993__pelites
pemolines1348623pemolines
pepsines1239883pep_sines
picholines1746303picholines
picoline12310853picoline_
picolins1239853picolin_s
piecings1345343pi_ecings
pieplants1355433pieplants
pieties9419223pi_eti_es
pilings103313613pi__lings
pinecones1346253pinecones
pinelands1244933pinelands
pinelike14188613pinelike_
pinenes93416673pine__nes
pineries102419083pineri_es
pipeages1336423pipe_ages
pipefishes2043793pipefishes
pipeless12107663pipel_ess
pipelining1543973pipelining
piperazines2453493piperazines
piperidines1653253piperidines
pipestones1445423pipestones
pipettes1237563pipe_ttes
pipiness1238003pip__iness
pipings12338253pip__ings
pipkins15328183pip_kin_s
pippins10319753pip_pin_s
pisolites1149383pisolites
plotlines1146823plotlines
popelike16177853popelike_
poperies12316793poperi_es
poplins11313153pop_lin_s
potlines10714213p_otlines
pralines102217723p_ralines
prelives13310383p_relives
prolines102619693p_rolines
purlines103514053p_urlines
relines75331323__relines
ridgelines12164293ridgelines
sideline91011093sideline_
sidelined11125883sidelined
sideliner10126013sideliner
sideliners11125133sideliners
splines94718893_sp_lines
tapeline10310363tapeline_
timeline1039243timeline_
timeliness1245303timeliness
toplines102412563top_lines
vaselines1246713vaselines
viperine13189713viperine_
vitellines1394733vitellines
wifeliness1644483wifeliness
zibeline1946363zibeline_
zibellines2143493zibellines

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 Filter1786911486410.420425454.8
2DLD Change Limit148641976.98621277.0
3Display Results97970.0462108.7
 (SQL Overall)178691977.45223978.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.