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

236 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
guyline1125817(None) 
gumline102810111gumline
guylines12236941guylines
byline11311642_byline
cutline92914542cutline
glycine1335712glycine
guanine8810542guanine
guiling93214212guiling
gulling94019562gulling
gumlike14317402gumlike
gumlines11238572gumlines
gutlike12308652gutlike
guying11379722guy_ing
outline72321332outline
purline93516532purline
skyline1436792skyline
subline9316892subline
aguelike1344673aguelike
airline7315033airline
aline57243153__aline
amylene12106883amylene
aniline7418473aniline
aquiline1746873aquiline
beeline93314723beeline
berline93716853berline
beryline1337083beryline
blueline1036873blueline
bowline123613113bowline
bubaline1247163bubaline
budlike14257873budlike
bugling113615343bugling
bulling104324793bulling
buntline10198063buntline
burling104421133burling
bustline10208843bustline
butling103516813butling
butylene1344403butylene
buying124213833buy_ing
bylined1335853_bylined
byliner1235723_byliner
bylines1239243_bylines
carline93923613carline
cauline92215603cauline
choline122915383choline
cline76428533__cline
cuisine9310423cuisine
culling103921303culling
cuplike1537213cuplike
curling104320183curling
cutlines102413273cutlines
decline103716613decline
dualize1759763dualize
dueling93614543dueling
dulling93418273dulling
dunlin739723dunlin_
dunlins849553dunlins
eucaine939243eucaine
feline94820143_feline
figuline1256033figu_line
fueling113615133fueling
fugling124212513fugling
fulling114019703fulling
fulmine1257963fulmine
furling114016563furling
gabling113514543gabling
galling93921963galling
gamine94620153g_amine
gantline9410903gantline
gaoling93314653gaoling
gasoline938523gasoline
gelling93219763gelling
gemlike14206813gemlike
genuine838373genuine
gillie74816943gilli_e
gilling93520383gilling
girlie73711463girli_e
glide74521593g__lide
glime85620193g__lime
glint66830183g__lint
gluelike1335023gluelike
glycin1235963glycin_
glycines1445083glycines
glycins1335563glycins
goalie7413163goali_e
goaling93515333goaling
goblin939503goblin_
goblins1039243goblins
godlike1387563godlike
godling103513403godling
gosling93312403gosling
gradine93317033gradine
grapline1138723grapline
gratine84719193gratine
grayling1338003grayling
grueling1078273grueling
guanin7610803guanin_
guanines989773guanines
guanins8810013guanins
guggling10236353guggling
guide75019883gu__ide
guideline1143983guideline
guiding102911843guiding
guile64521133gu__ile
guinea737613gu__inea
guise64717713gu__ise
guising93511413guising
gulden8328763gu_lden
gulfing12339473gulfing
gulflike1643453gulflike
gullible1144063gullible
gullied93812063gullied
gullies84717313gullies
gullwing13304923gullwing
gullying13367243gullying
gulping11309753gulping
gumming133810193gumming
gummite1236133gummite
gunfire1134743gunfire
gunflint1245943gunflint
gunite7414403gu_nite
gunning93413173gunning
gurging102910113gurging
gurgling11267323gurgling
gushing124014223gushing
gussie72910153gussi_e
gusting93917163gusting
gutting93415923gutting
guttling1037293guttling
guzzling18225063guzzling
gwine95513663g__wine
gybing13355933g_ybing
gyrene10227243g_yrene
gyring113910363g_yring
gyving14415713g_yving
hemline12311073hemline
hipline12311423hipline
hotline10712353hotline
hulling113619013hulling
hurling113616413hurling
hutlike14349063hutlike
hyaline132310723hyaline
incline9314643incline
isoline7314013isoline
ivylike1734283ivylike
jawline17137063jawline
kaoline11310143kaoline
line46965573___line
lulling83616803lulling
lupine84013533lu_pine
lysine94210553_lysine
maline84529083_maline
marline93320953marline
midline102315103midline
milline92519113milline
moline84422033_moline
muling93519883mu_ling
mulling103819993mulling
mullite9313013mullite
murine84220023mu_rine
murrine9411483murrine
muslin8312213muslin_
muslins9312213muslins
mutine84420373mu_tine
myeline1238253myeline
nuclide1037173nuclide
nulling83818063nulling
nunlike11258073nunlike
nurling84215823nurling
nutlike113110113nutlike
offline1345783offline
online6315843_online
opaline9412483opaline
outlie62419533outli_e
outlined92512953outlined
outliner82412113outliner
outlines82418093outlines
outlive102513033outlive
potline91015233potline
praline93019743praline
proline92321593proline
puling93621403pu_ling
pulling103821073pulling
purine85321893pu_rine
purlin83615863purlin_
purlines103514053purlines
purling103620293purling
purlins93415423purlins
puslike1347563puslike
quaylike2434143quaylike
quinine163011043quinine
ralline73518413ralline
ratline74517803ratline
raylike14269253raylike
recline94020493recline
redline84218833redline
reguline939503regu_line
reline65434353_reline
rubylike1753353rubylike
ruglike1236283ruglike
ruling73219553ru_ling
rusine63916593ru_sine
saline65132703_saline
setline7313923setline
skylike1336103skylike
skylines1535703skylines
spline86020533_spline
styling112910653styling
stylise10208953stylise
stylite10219613stylite
stylize19177453stylize
sublime11310363sublime
sublines10315783sublines
sunlike112310573sunlike
supine84216693su_pine
sylvine13216543_sylvine
tagline82412453tagline
thymine1536643thymine
topline92313183topline
towline102911543towline
toylike14157243toylike
tublike1337083tublike
tumpline1237113tumpline
turbine9310303turbine
turdine8310283turdine
undine7817263_undine
unlike102614063_unlike
unlined82515803_unlined
unlink104011013_unlink
unlive92712333_unlive
uplink12388713_uplink
urine55026593_u_rine
ursine64114123_ursine
valine94623093_valine
vulpine1235903vulpine
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.220812231.8
2DLD Change Limit1340272367.04619021.7
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.35924282.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.