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

313 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
xylol154613(None) 
xylols1634171xylols
xylyl1842561xylyl
cymol1287622cymol
nylon82910512nylon
pylon103614002pylon
salol55222142salol
xylan1537462xylan
xylem1736122xylem
xylitol1742022xylitol
xyloid1738182xyloid
xylose1636762xylose
xylyls1931832xylyls
aglow94711963aglow
aldol61212333aldol
all36148233_al_l
allod64418373allod
allot54933873allot
allow85420663allow
alloy85519973alloy
allyl85310543allyl
aloe45540193_aloe
alow75328593_alow
argol65317263argol
atoll57913923atoll
awol75620673_awol
axolotl1443353axolotl
azlon144312873azlon
ball66043323bal_l
bell66237183bel_l
belon73924113belon
below104617193below
bill67239933bil_l
blob86027093_blob
bloc85023273_bloc
blog75723823_blog
blot65842323_blot
blow95827193_blow
boll65634753bol_l
bolo65535953bolo_
bolos75531373bolos
bull65634873bul_l
bylaw13408603bylaw
byrl95716013by_rl
call66838673cal_l
calo64936443calo_
calos74431903calos
carol75128613carol
cell65031723cel_l
cello74919583cello
celom9515683celom
cibol9512023cibol
clod76124613_clod
clog76123243_clog
clon66232483_clon
clop86929893_clop
clot66542423_clot
cloy96623833_cloy
col59360353__col
colog86619933colog
colon78630193colon
color76123743color
cool66940493_cool
cull65929643cul_l
cyclo1237703cyclo_
cyclos1338073cyclos
cylix17448623cylix
cymols1377193cymols
cyton101511463cyton
dell56938203del_l
dill55239973dil_l
diol57329133_diol
dol47150653__dol
doll56632493dol_l
dolor67617963dolor
droll65415403droll
drool65416103drool
drylot1037403drylot
dull56430443dul_l
dynel9569853dynel
ell36735683_el_l
enol45823823_enol
enrol51014283enrol
extol1247893extol
extoll1334863extoll
fall75535313fal_l
fell76833073fel_l
felon84619293felon
fill75540193fil_l
fillo84319783fillo
filo76034283filo_
filos86125383filos
floc95922123_floc
floe76129773_floe
flog85523893_flog
flop96925453_flop
flow105924923_flow
fool75330593_fool
full75229153ful_l
fylfot1545043fylfot
gall56335993gal_l
galop84716213galop
gaol56925413_gaol
ghyll1246323ghyl_l
gill56336183gil_l
glob76623393_glob
glom75424383_glom
glop76724633_glop
glow85222523_glow
glycol1254933glycol
gull54828453gul_l
gyral94412783gyral
gyro85217883gyro_
gyron95314623gyron
gyros95616483gyros
halal85623593halal
hall75741163hal_l
hallo85127553hallo
halo76437323halo_
halon86124863halon
halos85230253halos
hell75637893hel_l
hello86522983hello
helo75332853helo_
helos84928063helos
helot85332683helot
hill76439493hil_l
hillo84721653hillo
hollo84822163hollo
hull75428783hul_l
hullo84417453hullo
hyla106716513hyl_a
hylas114815903hylas
hypo127516353hypo_
hypos1312014743hypos
hyson1138693hyson
idol56818633_idol
idyll9436713idyl_l
igloo6410493igloo
ill37437093_il_l
indol63714873indol
jalop144212603jalop
jell117125873jel_l
jello126716273jello
jill116430263jil_l
ketol95414003ketol
kill85533173kil_l
kilo86028663kilo_
kilos95021473kilos
knoll9389603knoll
kolo87026223kolo_
kolos94921213kolos
kylix19416323kylix
lall45531313lal_l
lilo46731563lilo_
lilos55821873lilos
lo28053443__lo_
lob57154463__lob
log46252683__log
loll46128383__loll
loo38359823__loo
lop58255313__lop
lot38179263__lot
low66051873__low
lox108240963__lox
lull44225763lul_l
mall64639363mal_l
maltol8310843maltol
mell64935613mel_l
melon73922083melon
metol75917813metol
mill66541473mil_l
milo65536093milo_
milos75428013milos
mol56654593__mol
molal75120343molal
moll66735703mol_l
mool67533863_mool
mull65128803mul_l
mylar105311533mylar
nerol51017813nerol
nicol71113293nicol
nill45634303nil_l
nolo46229313nolo_
nolos54423353nolos
null45125313nul_l
nylons9267973nylons
obol65220613_obol
orlon5415003orlon
orlop7410903orlop
osmol7138573osmol
pall65039343pal_l
parol74826273parol
pelon74423213pelon
phlox1737333phlox
phyllo1435873phyllo
phylon14318033phylon
phytol14366563phytol
pill65339463pil_l
pilot77435063pilot
plod76723273_plod
plop86625743_plop
plot66141233_plot
plow95923233_plow
ploy96123603_ploy
pol56449383__pol
poll66332133pol_l
polo66236633polo_
polos76129913polos
polyol1138713polyol
pool65835953_pool
pull64731663pul_l
pylons113011243pylons
pylori1147163pylori
pyro96019393pyro_
pyrola1139003pyrola
pyros105718293pyros
pyrrol1136273pyrrol
quoll14379493quoll
rill45140903ril_l
roll46331653rol_l
ryot75528563ry_ot
salal55425703salal
sall44544683sal_l
salols64017873salols
salon55228553salon
sell45840613sel_l
sheol84318363sheol
shool84523143shool
sill45545153sil_l
silo46037913silo_
silos56029423silos
slob66029423_slob
sloe45534953_sloe
slog56728273_slog
slop66533873_slop
slot46049823_slot
slow77729493_slow
snool55118643snool
sokol94612283sokol
sol37256623__sol
solo45538943solo_
solon55026133solon
solos54830793solos
sotol54917643sotol
spool75219043spool
stool55619893stool
sybo9714743sybo_
syli74318983syl_i
sylis84316023sylis
sylph1347793sylph
sylva11268443sylva
symbol1336083symbol
synod9610283synod
sysop1037193sysop
tall47240213tal_l
tallol63612223tallol
talon55824113talon
taxol124011363taxol
tell44934703tel_l
teloi54217383teloi
telos55424523telos
thiol87616043thiol
thymol1434463thymol
till45941203til_l
toll45535263tol_l
toluol636903toluol
tolyl84710093tolyl
tool46735683_tool
triol55521363triol
troll54416533troll
typal105311153typal
typo95418123typo_
typos106015813typos
tyro76622363tyro_
tyros85118593tyros
valor83614893valor
vill75235073vil_l
viol76523593_viol
wall76236103wal_l
well75832043wel_l
will75737513wil_l
wool76427373_wool
wyle105519383wyl_e
wyled124611843wyled
wyles114615323wyles
xenon122612453xenon
xerox1138623xerox
xylans1635883xylans
xylems1833203xylems
xylene1645793xylene
xylitols1841753xylitols
xyloses1746843xyloses
xyst144714073xy_st
xysti15538153xysti
xystoi16365133xystoi
xystos16356913xystos
xysts15558123xysts
yawl104918973_yawl
yell76028323_yell
yill75628973_yill
ylem9217893_ylem
yo59748553_y_o_
yob87945273_y_ob
yod77545503_y_od
yok107335243_y_ok
yolk116218993_yolk
yom88043443_y_om
yon67348953_y_on
you66641823_y_ou
yow96945293_y_ow
yowl105820953_yowl
zill135727613zil_l

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 Filter178691836670.1231452772.4
2DLD Change Limit836673134.29619475.6
3Display Results3133130.0803912.5
 (SQL Overall)1786913134.49939717.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.