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

122 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
xylyls193183(None) 
xylols1634171xylols
xylyl1842561xylyl_
allyls9437272allyls
tolyls9436962tolyls
xylans1635882xylans
xylems1833202xylems
xylol1546132xylol_
acyls104211523_acyls
alkyls13465723alkyls
alls46740923_al_ls
allyl85310543allyl_
amyls104512693_amyls
aryls87015813_aryls
balls76236413bal_ls
bells76432163bel_ls
beryls11107883beryls
bills75632863bil_ls
bolls75531313bol_ls
bulls75629573bul_ls
butyls1176753butyls
bylaws14415833bylaws
byrls105711233by_rls
calls75634733cal_ls
cells75428063cel_ls
culls75425813cul_ls
cymols1377193cymols
dells66630943del_ls
dills65530973dil_ls
dolls66126923dol_ls
dulls64523743dul_ls
dynels10536813dynels
ells46431353_el_ls
ethyls1235903ethyls
falls85727653fal_ls
fells85327383fel_ls
fills84632373fil_ls
fulls84623523ful_ls
galls64729323gal_ls
ghylls1335143ghyl_ls
gills64728193gil_ls
glycyls1642063glycyls
gulls65222983gul_ls
halals95018313halals
halls85633783hal_ls
hells85032043hel_ls
hexyls1933433hexyls
hills85431353hil_ls
hulls84923563hul_ls
hylas114815903hyl_as
idylls10425253idyl_ls
idyls9498803_idyls
ills47030423_il_ls
jells125522163jel_ls
jills125122823jil_ls
kills94526173kil_ls
lalls55324133lal_ls
lolls512121733lol_ls
lulls54119653lul_ls
lyes75530833__lyes
malls76233433mal_ls
mells75031333mel_ls
mills75435053mil_ls
molls75129783mol_ls
mulls75124153mul_ls
mylars114310443mylars
nills54926673nil_ls
nonyls957853nonyls
nulls55019983nul_ls
nylons9267973nylons
octyls11135323octyls
odyls9428653_odyls
palls74332563pal_ls
pills74130973pil_ls
polls74627723pol_ls
polyols1238493polyols
polyps13479763polyps
polys105718763poly_s
pulls74425053pul_ls
pylons113011243pylons
rills55032713ril_ls
rolls55326233rol_ls
salals65120083salals
salols64017873salols
sells55134433sel_ls
sibyls1135303sibyls
sills55135993sil_ls
slyly11489533_slyly
sylis84316023syl_is
sylphs1435543sylphs
sylvas12288173sylvas
talls55133433tal_ls
tells55828943tel_ls
tellys9348843tellys
tills54631713til_ls
tolls54728433tol_ls
toluyls1032833toluyls
tolyl84710093tolyl_
vills86429323vil_ls
vinyls12467003vinyls
walls85529383wal_ls
wells85426193wel_ls
wills84528963wil_ls
wyles114615323wyl_es
xylan1537463xyl_an
xylem1736123xyl_em
xylene1645793xylene
xylenes1745093xylenes
xylitols1841753xylitols
xyloid1738193xyloid
xylose1636763xylose
xyloses1746843xyloses
xystos16356913xystos
xysts15558123xy_sts
xystus16354423xystus
yawls114613603_yawls
yays105728913_yay_s
yells85821943_yells
yills83921553_yills
ylems1039263_ylems
yowls115715433_yowls
zills144020783zil_ls

Search took 5 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.360496363.9
2DLD Change Limit1127161224.48325143.0
3Display Results1221220.0333697.0
 (SQL Overall)1786911224.87636647.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.