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

164 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
sideline9101109(None) 
sidelined11125881sidelined
sideliner10126011sideliner
sidelines10109681sidelines
sideling101012181sideling
guideline1143982guideline
lifeline11167662lifeline
midline102315102mid_line
pipeline12149502pipeline
ridgeline11174722ridgeline
sideliners11125132sideliners
sidelong10133982sidelong
siderite9411362siderite
sidewise1245352sidewise
sidling9915422sid_ling
tidelike1336742tidelike
timeline1039242timeline
zibeline1946362zibeline
adenine8311213_adenine
airline7315033ai_rline
baseline10310753baseline
beeline93314723_beeline
blueline1036873blueline
codeine103815033code_ine
dateline9810353dateline
decline103716613__decline
define104718143__define
delaine8314793__delaine
delime9314043__delime
diddling12228743diddling
driveline1345353driveline
endexine1646083endexine
feline94820143__feline
fiddling14217873fiddling
fidelity1544933fidelity
figuline1256033figuline
fishline14237583fishline
guidelines1243363guidelines
hipline12311423hi_pline
hireling121210993hireling
icelike1337173_icelike
idealise938053_idealise
idealize1847873_idealize
idling8912883_id_ling
idolise839293_idolise
idolize1737783_idolize
incline9314643_incline
induline939493induline
isocline1047293isocline
isoline7314013_isoline
jadelike2035993jadelike
kidlike1137063kid_like
kitelike1135733kitelike
libeling1139873libeling
lifelike15166223lifelike
lifelines12147053lifelines
linelike12159003linelike
lobeline1039963lobeline
madeleine1244133madeleine
middling13249343middling
midlife13248303mid_life
midlines112613333mid_lines
milline92519113mi_lline
misdefine1545513misdefine
modeling12311073modeling
myeline1238253_myeline
nidering10510483nidering
picoline12310853picoline
piddling13208953piddling
pinelike14188613pinelike
pipelike16166693pipelike
pipelined14164853pipelined
pipelines13178353pipelines
piperine122011833piperine
redefine1238973redefine
redline84218833red_line
reline65434353__reline
riddling11249443riddling
ridgelines12164293ridgelines
ridgeling12155263ridgeling
ridgling11258203ridgling
riverine11310803riverine
saddling11239593saddling
saline65132703s__aline
seedlike1335993seedlike
seedling102610953seedling
seeling83522003s_eeling
seine55732873s__e_ine
sepaline10311343sepaline
serine65432673s__erine
setline7313923s_etline
shedlike1635833shedlike
shieling123512403shieling
shoreline1246623shoreline
sibling10814423si_bling
sibylline1442893sibylline
sickling152910333sickling
sideband1245023sideband
sidehill1243503sidehill
sidekick1442633sidekick
sidelight14175483sidelight
sidelining1244573sidelining
sideman1037973sideman_
sidemen1037943sidemen_
sidepiece1472933sidepiece
siderites10410433siderites
siderolite1153913siderolite
sideslip1143333sidesli_p
sideslips1243673sideslips
sidespin1143943sidespin_
sidespins1244383sidespins
sideswipe15112943sideswipe
sidewinder1552153sidewinder
siding83822133sid__ing
sidle65124033sid_l__e
sieging92613203si_eging
sienite7312713si_enite
sieving112311233si_eving
sighlike1635533sighlike
sightline1345683sightline
silane62718053si__lane
silkaline1344243silkaline
silklike1135523silklike
silkoline1343653silkoline
simazine1945363simazine
simlin8311733si_mlin_
simlins9311843si_mlins
sinewing1267593sinewing
singling101913003singling
sizzling17225783sizzling
skyline1436793s_kyline
sniveling1336033sniveling
sodalite9109593sodalite
speeling112713123speeling
spiderlike1742563spiderlike
spieling113212523spieling
spikelike14103873spikelike
spinelike1585353spinelike
spline86020533s__pline
steelie7310213steeli_e
steeling93615143steeling
stelene7310253s_telene
subline9316893s_ubline
swiveling1634573swiveling
syncline1356073syncline
tapeline10310363tapeline
tideland1044633tideland
tilelike1237053tilelike
timelines1148443timelines
underline101714673underline
vaseline1138613vaseline
videlicet1545913videlicet
viperine13189713viperine
viselike1536923viselike
vitelline1285853vitelline
vituline1147093vituline
wedeling1338773wedeling
widdling14228743widdling
widening13237833widening
wifelike18135253wifelike
wirelike15167493wirelike
yodeling1357673yodeling
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.440406115.9
2DLD Change Limit1461621647.43619656.0
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.93922508.0
 
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.