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

210 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
skyline143679(None) 
skylike1336101skylike
skylines1535701skylines
byline11311642_byline
guyline11258172guyline
saline65132702s_aline
setline7313922setline
skydive1852772skydive
skying14399982sky_ing
skylit1338272skyli_t
spline86020532s_pline
styling112910652styling
stylise10208952stylise
stylite10219612stylite
stylize19177452stylize
subline9316892subline
sylvine13216542s_ylvine
airline7315033airline
aline57243153__aline
alkaline12168283alkaline
amylene12106873amylene
aniline7418473aniline
beeline93314723beeline
berline93716853berline
beryline1337083beryline
bowline123613113bowline
bylined1335853_bylined
byliner1235723_byliner
bylines1239243_bylines
carline93923613carline
cauline92215603cauline
choline122915383choline
cline76428533__cline
cutline92914543cutline
decline103716613decline
feline94820143_feline
glycine1335713glycine
gumline102810113gumline
guylines12236943guylines
hemline12311073hemline
hipline12311423hipline
hotline10712343hotline
hyaline132310723hyaline
incline9314643incline
isocline1047293isocline
isoline7314013isoline
ivylike1734283ivylike
jawline17137063jawline
kaoline11310143kaoline
kine85643423_k__ine
koine9516483_k_oine
kylikes1333583_kylikes
kylix19416323_kyli_x
kyrie123712903_kyri_e
line46965573___line
lysine94210553_lysine
maline84529083_maline
marline93320953marline
midline102315103midline
milline92519113milline
moline84422033_moline
myeline1238253myeline
offline1345783offline
online6315843_online
opaline9412483opaline
outline72321333outline
potline91015233potline
praline93019743praline
proline92321593proline
purline93516533purline
ralline73518413ralline
ratline74517803ratline
raylike14269253raylike
recline94020493recline
redline84218833redline
reline65434353_reline
sabine84020383s_abine
saclike131210123saclike
sailing83927373sailing
salina64221123s_alina
salines74029413s_alines
saltine75018563saltine
sapling103217863sapling
sardine83317393sardine
savine94220283s_avine
sawlike14138443sawlike
saying104325543say_ing
scalene9310773scalene
scaling103519373scaling
sealing83528563sealing
seeling83522003seeling
seine55732873s__eine
selling83225833selling
sepaline10311343sepaline
serine65432673s_erine
sestine73017923sestine
setlines8312743setlines
shine85533093s__hine
shrine94920053s_hrine
shying134211843shy_ing
sibling10814423sibling
sibylline1442893sibylline
sideline91011093sideline
sidling9915423sidling
silane62718053s_ilane
silkaline1344243silkaline
silkoline1343653silkoline
simlin8311723simlin_
simlins9311823simlins
sine46560623s___ine
skating123613843skating
skeane104611373sk_eane
skeeing12308853skeeing
skein94814403sk_ein_
skeined1236773sk_eined
skeins103911903sk_eins
skelping1535973skelping
skene96118123sk__ene
skewing15318723skewing
skiing113610193sk_iing
skilling132911323skilling
skin85927523sk__in_
skink85916853sk__ink
skinlike1134873skinlike
skins94723463sk__ins
skint95629223sk__int
skiplane1444833skiplane
skirling13249063skirling
skite95120043sk__ite
skiting123812493skiting
skive124614113sk__ive
skiving15298373skiving
sklent103614353sk_lent
skoaling13227203skoaling
skulking12245903skulking
skulling13258103skulling
skyborne1742383skyborne
skydived2051563skydived
skydiver1951763skydiver
skydives1952133skydives
skydove1842083skydove
skylark1343273skylark
skylight1943993skylight
skyman1535313skyman_
skymen1535313skymen_
skywrite1842923skywrite
slice74925823s__lice
slide64725413s__lide
slime74925753s__lime
sling66028803s__ling
slink95422913s__link
slipe75626133s__lipe
smaltine1037833smaltine
smiling103915443smiling
soiling83422323soiling
soling74226823s_oling
sonlike112110713sonlike
sordine82515223sordine
sozine15712343s_ozine
spiling102919703spiling
spine76534423s__pine
splice104915103s_plice
splined105013113s_plined
splines94718893s_plines
splint85223283s_plint
spying123913253spy_ing
staling83925423staling
stanine73417073stanine
stelene7310253stelene
stibine938653stibine
stying105414573sty_ing
stylate10179773stylate
style85519363styl__e
styli83911173styli__
stylings12276233stylings
stylised12215893stylised
styliser11185523styliser
stylises11188943stylises
stylish13197443stylish
stylist102110283stylist
stylites11168693stylites
stylized21175863stylized
stylizer20185443stylizer
stylizes20207113stylizes
stymie1137623stymi_e
styrene10116693styrene
sublime11310353sublime
sublines10315783sublines
sunlike112310573sunlike
supine84216693s_upine
swine85625303s__wine
syli74318983s_yli__
sylis84316023s_yli_s
sylvae12236863s_ylvae
sylvin12247303s_ylvin_
sylvines14215903s_ylvines
sylvins13246243s_ylvins
sylvite13266353s_ylvite
syncline1356073syncline
syne75725763s_y__ne
syringe11349473s_yringe
syrinx1637143s_yrinx
tagline82412453tagline
thymine1536643thymine
topline92313183topline
towline102911543towline
toylike14157243toylike
valine94623093_valine
wyling13368553_wyling
xylene1645793_xylene

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 Filter1786911340270.296603685.8
2DLD Change Limit1340272107.19018640.8
3Display Results2102100.0762763.2
 (SQL Overall)1786912107.56223630.1
 
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.