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

284 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
xylols163417(None) 
xylol1546131xylol_
xylyls1931831xylyls
cymols1377192cymols
nylons9267972nylons
pylons113011242pylons
salols64017872salols
xylans1635882xylans
xylems1833202xylems
xylitols1841752xylitols
xyloid1738182xyloid
xylose1636762xylose
xyloses1746842xyloses
xylyl1842562xylyl_
aldols7109713aldols
allods73615083allods
allots64019173allots
allows94517683allows
alloys94014563alloys
alls46740923_al_ls
allyls9437273allyls
aloes54933673_aloes
argols74514613argols
atolls65511353atolls
awols84713523_awols
axolotls1541783axolotls
azlons154110423azlons
balls76236413bal_ls
bells76432163bel_ls
belons84119413belons
belows114614183belows
bills75632863bil_ls
blobs95620033_blobs
blocs95219653_blocs
blogs85319233_blogs
blots75626173_blots
blows105423833_blows
bolls75531313bol_ls
bolos75531373bolo_s
bulls75629573bul_ls
bylaws14415833bylaws
byrls105711233by_rls
calls75634733cal_ls
calos74431903calo_s
carols85124983carols
cellos84517803cellos
cells75428063cel_ls
celoms10412123celoms
chylous15107263chylous
cibols1039523cibols
clods85320863_clods
clogs85519553_clogs
clons75228133_clons
clops95924853_clops
clots75627643_clots
cloys104916943_cloys
cologs96517353cologs
colons86028683colons
colors86622373colors
cols66553083__cols
cools75632633_cools
culls75425813cul_ls
cyclops1635383cyclops
cyclos1338073cyclo_s
cymol1287623cymol_
cymous1388403cymous
cytons111710183cytons
dells66630943del_ls
dills65530973dil_ls
diols65521013_diols
dolls66126923dol_ls
dolors75115313dolors
dols56943053__dols
drolls75312393drolls
drools74412813drools
drylots1143743drylots
dulls64523743dul_ls
dynels10536813dynels
ells46431353_el_ls
enols54718403_enols
enrols61213383enrols
extolls1444603extolls
extols1337683extols
falls85727653fal_ls
fells85327383fel_ls
felons93615763felons
fillos94415073fillos
fills84632373fil_ls
filos86125383filo_s
flocs105519233_flocs
floes85528143_floes
flogs95919963_flogs
flops105920143_flops
floss85118263_floss
flows115822363_flows
fools86824203_fools
fulls84623523ful_ls
fylfots1642423fylfots
galls64729323gal_ls
galops94712613galops
gaols66717573_gaols
ghylls1335143ghyl_ls
gills64728193gil_ls
globs85616403_globs
gloms85219783_gloms
glops85619553_glops
gloss64319623_gloss
glows95518033_glows
glycols1344133glycols
gulls65222983gul_ls
gyrons105511223gyrons
gyros95616483gyro_s
halals95018313halals
hallos95425103hallos
halls85633783hal_ls
haloes94623863haloes
halons95720713halons
halos85230253halo_s
hellos95321683hellos
hells85032043hel_ls
helos84928063helo_s
helots95217703helots
hillos94618883hillos
hills85431353hil_ls
hollos95320633hollos
hols76946293__hols
hullos94916293hullos
hulls84923563hul_ls
hylas114815903hyl_as
hypos1312014743hypo_s
hysons1237633hysons
idols65514133_idols
idylls10425253idyl_ls
igloos738033igloos
ills47030423_il_ls
indols74714203indols
jalops15329593jalops
jellos134714283jellos
jells125522163jel_ls
jills125122823jil_ls
ketols104210763ketols
kills94526173kil_ls
kilos95021473kilo_s
knolls10367413knolls
kolos94921213kolo_s
lalls55324133lal_ls
lilos55821873lilo_s
lobs66441083__lobs
logs57343113__logs
loll46128383__loll
lolls512121733__lolls
loos49051123__loos
lops66043353__lops
loss45337963__loss
lots47652093__lots
lows75843013__lows
lulls54119653lul_ls
malls76233433mal_ls
maltols939403maltols
mells75031333mel_ls
melons84117713melons
metols84115773metols
mills75435053mil_ls
milos75428013milo_s
molls75129783mol_ls
mols65948573__mols
mools76027173_mools
mulls75124153mul_ls
mylars114310443mylars
nerols6914883nerols
nicols8810243nicols
nills54926673nil_ls
nolos54423353nolo_s
nulls55019983nul_ls
nylon82910513nylo_n
obols73715863_obols
orlons6411013orlons
orlops847303orlops
osmols8137313osmols
palls74332563pal_ls
parols84722613parols
phyllos1535583phyllos
phytols15276553phytols
pills74130973pil_ls
pilots84018873pilots
pilous84717753pilous
plods85719293_plods
plops95920333_plops
plots75025673_plots
plows105419903_plows
ploys105816593_ploys
polls74627723pol_ls
polos76129913polo_s
pols66044563__pols
polyols1238493polyols
pools74427703_pools
pulls74425053pul_ls
pylon103614003pylo_n
pylori1147163pylori
pylorus1235333pylorus
pyrola1139003pyrola
pyrolas1239863pyrolas
pyros105718293pyro_s
pyrrols1235403pyrrols
quolls15327303quolls
rills55032713ril_ls
rolls55326233rol_ls
ryots85313783ry_ots
salals65120083salals
salol55222143salol_
salons63823683salons
sells55134433sel_ls
sheols94614153sheols
shools94919003shools
sills55135983sil_ls
silos56029423silo_s
slobs74419873_slobs
sloes54728873_sloes
slogs64521843_slogs
slops75026013_slops
slots54830523_slots
slows85323463_slows
snools65715873snools
sokols10399083sokols
solons65120013solons
solos54830793solo_s
sols45448163__sols
sotols63714453sotols
spools85115913spools
stools65117023stools
syboes1139343syboes
sylis84316023syl_is
sylphs1435543sylphs
sylvas12288173sylvas
symbols1435523symbols
synods1077953synods
sysops1136013sysops
tallols73311353tallols
talls55133433tal_ls
talons64019423talons
taxols13328633taxols
tells55828943tel_ls
telos55424523telo_s
thiols95112763thiols
thymols1533843thymols
tills54631703til_ls
tolls54728433tol_ls
toluols735823toluols
tolyls9436963tolyls
tools55325243_tools
triols66117803triols
trolls64613943trolls
typos106015813typo_s
tyros85118593tyro_s
valors93413773valors
vills86429323vil_ls
viols86118103_viols
walls85529383wal_ls
wells85426193wel_ls
wills84528963wil_ls
wools84421463_wools
wyles114615323wyl_es
xenons132710483xenons
xylan1537463xyl_an
xylem1736123xyl_em
xylene1645793xylene
xylenes1745093xylenes
xylitol1742023xylitol_
xystos16356913xystos
xysts15558123xy_sts
xystus16354423xystus
yawls114613603_yawls
yells85821943_yells
yills83921553_yills
ylems1039263_ylems
yobs96028083_y_obs
yods86531183_y_ods
yoks116223743_y_oks
yolk116218993_y_olk
yolks125412773_yolks
yous76230653_y_ous
yowls115715433_yowls
yows106433123_y_ows
zills144020783zil_ls

Search took 7 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.1261418182.5
2DLD Change Limit1127162846.45317467.2
3Display Results2842840.0933053.8
 (SQL Overall)1786912846.67226782.2
 
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.