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

170 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
xylene164579(None) 
xylenes1745091xylenes
amylene12106882amylene
byline11311642byline
cymene1377392cymene
gyrene10227242gyrene
pyrene113210732pyrene
xylan1537462xylan_
xylans1635882xylans
xylem1736122xyle_m
xylems1833202xylems
xylose1636762xylose
achene11313813achene
agene65621583_agene
aglee65728493agle_e
akene95818663_akene
alane56135613_alane
alee46652323_ale_e
aline57243153_aline
alkene104114003alkene
allee54932123alle_e
allege74314653allege
allele64514563allele
alone55732963_alone
amylenes13105703amylenes
arene55329413_arene
baleen8613053baleen
bene66439493__bene
blend85317453_blend
blende95413443_blende
blent76230953_blent
bolete8519613bolete
butene8312623butene
butylene1344403butylene
bygone1256173bygone
bylined1335853bylined
byliner1235723byliner
bylines1239243bylines
clepe94617383_clepe
cline76428533_cline
clone75728163_clone
colone85425003colone
cyclone1437243cyclone
cymenes1477413cymenes
delete73620703delete
dene56643413__dene
diene65720133_diene
dyne85320933dy__ne
eocene8311613eocene
ethene93312923ethene
ethylene1444233ethylene
eyen76223663ey_en_
eyne76322463ey__ne
feline94820143feline
flee76238793_fle_e
flense938903_flense
galeae74717453galeae
galena74911093galena
galere73716693galere
gelee63626983gele_e
gene56237223__gene
glebe85016443_glebe
glede75517833_glede
glee55239063_gle_e
glen56027203_glen_
glens66519853_glens
guyline11258173guyline
gyrenes11267523gyrenes
hyaena1235363hyaena
hyaline132310723hyaline
hyena11810253hy_ena
hygiene1443473hygiene
hymen13311043hymen_
hymens1437993hymens
indene73215373indene
ketene106613003ketene
lane45153333__lane
lee36068143__le_e
leke85527403__leke
lend56233673__lend
lenes54738523__lenes
leno47331393__leno
lens46146493__lens
lense54523433__lense
lent46360533__lent
leone55018823__leone
line46965583__line
lone45849133__lone
lune47140493__lune
lycee104716743lyce_e
lysine94210553lysine
maline84529093maline
melee73729103mele_e
melena81110473melena
moline84422033moline
mycele1335853mycele
myeline1238253myeline
nene45932063__nene
nylon82910513nylon_
nylons9267973nylons
oleine6313793_oleine
online6315843online
oxygen1743313oxygen_
oxygens1843163oxygens
oxytone1744203oxytone
paleae84820293paleae
pinene82915653pinene
plane74929143_plane
plebe95014873_plebe
plena75816393_plena
polyene1259363polyene
pylon103614003pylon_
pylons113011243pylons
pyrenes123511223pyrenes
pyrone112714473pyrone
relend76116453relend
relent64431853relent
releve95116403releve
reline65434353reline
retene69224273retene
saline65132703saline
scalene9310773scalene
scene77220573_scene
sene46848053__sene
serene63522353serene
silane62718053silane
silence9310223silence
sileni63312143sileni
silent64125843silent
skene96118123_skene
sklent103614353sklent
skyline1436793skyline
sphene113412403sphene
spleen8310263spleen
splent84720193splent
spline86020533spline
stelene7310253stelene
styrene10116693styrene
sycee105018623syce_e
sylvae12236863sylvae
sylvine13216543sylvine
syne75725763sy__ne
syren85216743syren_
syrens94911993syrens
talent6323323talent
terylene1144153terylene
tolane64316583tolane
toluene736463toluene
triene64316383triene
tyee75131423ty_e_e
tyne76325053ty__ne
valence1268773valence
valine94623093valine
venene92912523venene
wyle105519383wyl__e
wyled124611843wyle_d
wyles114615323wyle_s
wyling13368553wyling
xylidine1943753xylidine
xyloid1738193xyloid
xylol1546133xyl_ol
xylols1634173xylols
xyloses1746843xyloses
xylyl1842563xyl_yl
xylyls1931833xylyls
yen66847383_y_en_
yens75832263_y_ens
yente86220043_y_ente
ylem9217893_yle_m
ylems1039263_ylems

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161704.75023729.7
3Display Results1701700.0463695.7
 (SQL Overall)1786911705.16934569.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.