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

166 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
xylenes174509(None) 
xylene1645791xylene_
amylenes13105702amylenes
bylines1239242bylines
cymenes1477412cymenes
gyrenes11267522gyrenes
lenes54738522__lenes
pyrenes123511222pyrenes
xylans1635882xylan_s
xylems1833202xyle_ms
xyloses1746842xyloses
achenes12313493achenes
agenes74720253_agenes
akenes104817343_akenes
alines65735223_alines
alkenes114212753alkenes
allees64521483alle_es
alleges84212573alleges
alleles73812033alleles
amylene12106883amylene_
arenes64928393_arenes
baleens938473baleens
benes75536233__benes
blendes104713683_blendes
blends96012883_blends
boletes9316063boletes
butenes9313033butenes
butylenes1444413butylenes
bygones1335913bygones
byline11311643byline_
bylined1335853bylined
byliner1235723byliner
byliners1334753byliners
calends1039523calends
clepes104214623_clepes
clines84926043_clines
clones84526563_clones
colones96124433colones
culexes1636993culexes
cyclones1537483cyclones
cyeses11510123cy_eses
cylices14359283cylices
cymene1377393cymene_
deletes83117933deletes
denes65639723__denes
dienes75719903_dienes
dynes95917583dy__nes
ethenes103313873ethenes
ethylenes1544223ethylenes
felines104718073felines
flanes94522423_flanes
flees85828753_fle_es
flense938903_flense
flenses1039473_flenses
flexes164512953_flexes
galenas83310343galenas
galeres83514343galeres
gelees74116263gele_es
genes65133093__genes
glebes95512243_glebes
gledes84915133_gledes
glees65027593_gle_es
glens66519853_glen_s
guylines12236943guylines
gyrene10227243gyrene_
haleness11312623haleness
hyaenas1334983hyaenas
hyalines14169333hyalines
hyenas1288953hy_enas
hygienes1543413hygienes
hymens1437993hymen_s
idleness936843idleness
ilexes134510253_ilexes
indenes82916253indenes
kalends1235683kalends
ketenes114813503ketenes
kylikes1333583kylikes
lanes54946793__lanes
lees45455883__le_es
leges64427293__leges
lends65326253__lends
lenis56326863__lenis
lenos56024863__lenos
lens46146493__len_s
lense54523433__lense
lenses64620893__lenses
leones64417723__leones
leses54930813__leses
lexes127225263__lexes
lines57054573__lines
lunes55337773__lunes
lycees11428863lyce_es
lysines10369093lysines
maleness10312313maleness
malines93625603malines
melees83618083mele_es
melenas999203melenas
myceles1435213myceles
myelines1337123myelines
nenes55329673__nenes
nylons9267973nylon_s
oleines7313393_oleines
oxygens1843163oxygen_s
oxytones1844053oxytones
oyezes1835053oy_ezes
paleness10312983paleness
penes75839223__penes
phyleses1645183phyleses
pinenes93416673pinenes
planes85028083_planes
plebes104313623_plebes
plexes155313543_plexes
polyenes13510063polyenes
pylons113011243pylon_s
pyrene113210733pyrene_
pyrexes19305843pyrexes
pyrones123113303pyrones
relends84013253relends
relents74018503relents
releves103914973releves
relines75331323relines
retenes76324623retenes
salines74029413salines
scenes84520353_scenes
serenes73222903serenes
silanes72517163silanes
silences10310073silences
silents73514493silents
silenus7369693silenus
silexes1438653silexes
skenes104616633_skenes
sklents11348163sklents
skylines1535703skylines
soleness8814263soleness
sphenes123013163sphenes
spleens937103spleens
splents93912133splents
splines94718893splines
styrenes11116623styrenes
sycees11409653syce_es
sylvines14215903sylvines
syrens94911993syren_s
talents7312013talents
teleses7313123teleses
telexes1438353telexes
terylenes1244933terylenes
tolanes74216313tolanes
toluenes836763toluenes
trienes74118413trienes
tyees86019453ty_e_es
tynes85920303ty__nes
valences1388513valences
valines104520213valines
venenes102712133venenes
vileness1139983vileness
wyles114615323wyl__es
xylan1537463xylan__
xylem1736123xyl__em
xylidines2042993xylidines
xylols1634173xyl_ols
xylose1636763xylose_
xylyls1931833xyl_yls
yens75832263_y_en_s
yentes95517603_y_entes
yeses85119323_y_eses
ylems1039263_yle_ms

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.406440125.6
2DLD Change Limit1340271666.70319995.1
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.17224915.1
 
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.