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

203 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
xylyl184256(None) 
xylol1546131xylol
xylyls1931831xylyls
allyl85310542allyl
tolyl84710092tolyl
xylan1537462xylan
xylem1736122xylem
xylols1634172xylols
ably99725133ably_
acyl95314293_acyl
agly86821803agly_
alkyl12518043alkyl
all36148233_al_l
ally76935643ally_
allyls9437273allyls
amyl95515093_amyl
aryl75922343_aryl
ball66043323bal_l
bally105530103bally
bell66237183bel_l
belly104625493belly
beryl101211673beryl
bill67239933bil_l
billy105525363billy
boll65634753bol_l
bull65634873bul_l
bully105124813bully
butyl1089103butyl
bylaw13408603bylaw
byrl95716013by_rl
call66838673cal_l
calyx17518193calyx
cell65031723cel_l
colly104926773colly
coly96940533coly_
coyly135614893coyly_
cull65929643cul_l
cully105520463cully
cylix17448623cylix
cymol1287623cymol
dally95324743dally
dell56938203del_l
delly96023873delly
dill55239973dil_l
dilly94923783dilly
doll56632493dol_l
dolly96125203dolly
doyly124514013doyly_
dryly12538453dryly_
dull56430443dul_l
dully94921633dully
duly85323033duly_
dynel9569853dynel
eely77725213eely_
ell36735683_el_l
ethyl1136513ethyl
eyry106315883eyry_
fall75535313fal_l
fell76833073fel_l
felly114922803felly
feyly14429513feyly_
fill75540193fil_l
filly114424903filly
fly97124953_fly_
folly115022603folly
full75229153ful_l
fully114820863fully
gall56335993gal_l
gally95026173gally
gayly124513093gayly_
ghyll1246323ghyl_l
gill56336183gil_l
gilly94321633gilly
glycyl1542793glycyl
golly95121103golly
gull54828453gul_l
gully94020683gully
gyral94412783gyral
halal85623593halal
hall75741163hal_l
hell75637893hel_l
hexyl1844463hexyl
hill76439493hil_l
hilly114422163hilly
holly114824433holly
holy106333433holy_
hull75428783hul_l
hyla106716513hyl_a
hylas114815903hylas
idly85617323idly_
idyl85912303_idyl
idyll9436713idyl_l
ill37437093_il_l
illy76925333illy_
inly75622213inly_
jell117125873jel_l
jelly154218253jelly
jill116430263jil_l
jolly154517513jolly
kelly124617023kelly
kill85533173kil_l
kylix19416323kylix
lall45531313lal_l
lily76730183lily_
loll46128383lol_l
lolly85120663lolly
lull44225763lul_l
lye66533413__lye
mall64639363mal_l
mell64935613mel_l
mill66541473mil_l
molal75120343molal
moll66735703mol_l
molly105222493molly
moly96031913moly_
mull65128803mul_l
mylar105311533mylar
nelly84618813nelly
nill45634303nil_l
nonyl849773nonyl
null45125313nul_l
nylon82910513nylon
octyl10136063octyl
odyl84111463_odyl
oily77932253oily_
only75319723only_
pall65039343pal_l
pally105727123pally
paly95835533paly_
pill65339463pil_l
pily96132733pily_
ply86323553_ply_
poll66332133pol_l
poly96235153poly_
polyol1138713polyol
polyp125611533polyp
polys105718763polys
pull64731663pul_l
pylon103614003pylon
rally84725903rally
rely75428953rely_
rill45140903ril_l
roll46331653rol_l
ruly76323143ruly_
salal55425703salal
sall44544683sal_l
sally85129713sally
salol55222143salol
sell45840613sel_l
shyly144811573shyly_
sibyl1037113sibyl
sill45545153sil_l
silly84527613silly
sly66228563_sly_
slyly11489533_slyly
sully84622893sully
syli74318983syl_i
sylis84316023sylis
sylph1347793sylph
sylva11268443sylva
tall47240213tal_l
tally84526863tally
tell44934703tel_l
telly84920823telly
till45941203til_l
toll45535263tol_l
toluyl933443toluyl
tolyls9436963tolyls
tyiyn11635333tyiyn
typal105311153typal
typy126013043typy_
ugly86012383ugly_
vill75235073vil_l
vinyl115311623vinyl
wall76236103wal_l
wally114625093wally
waly105830903waly_
well75832043wel_l
welly114620013welly
will75737513wil_l
willy115321913willy
wily106428813wily_
wryly14356703wryly_
wyle105519383wyl_e
wyled124611843wyled
wyles114615323wyles
xylans1635883xylans
xylems1833203xylems
xylene1645793xylene
xylitol1742023xylitol
xyloid1738183xyloid
xylose1636763xylose
xyst144714073xy_st
xysti15538153xysti
xysts15558123xysts
yawl104918973_yawl
yay96948713_yay_
yays105728913_yays
yell76028323_yell
yill75628973_yill
ylem9217893_ylem
yowl105820953_yowl
zill135727613zil_l

Search took 4 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 Filter178691836670.1231452772.4
2DLD Change Limit836672033.48324021.5
3Display Results2032030.0633222.2
 (SQL Overall)1786912033.66948702.9
 
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.