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

307 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
xylems183320(None) 
xylem1736121xylem_
ylems1039261_ylems
golems939322golems
wyles114615322wyle_s
xylans1635882xylans
xylene1645792xylene
xylenes1745092xylenes
xylols1634172xylols
xylyls1931832xylyls
ylem9217892_ylem_
ables75935543able_s
adeems946333adeems
aglets73915683aglets
alecs76620733_alecs
alefs87319663_alefs
ales47067103_ale_s
allees64521483allees
alleys95113303alleys
almes75126543_almes
alms65834923_al_ms
alums75720603_alums
amylums1473613amylums
arles56735743arle_s
asylums1243633asylums
awless939263awless
axles125219473axle_s
ayes76543513ay_e_s
balers85626933balers
bales76250083bale_s
balms95723923bal_ms
biles75542143bile_s
blams95023853_blams
blebs96416153_blebs
bless75917813_bless
blets75324943_blets
boles75448603bole_s
byes95230533by_e_s
bylaws14415833bylaws
byres104421383byre_s
bytes105217493byte_s
calms95222353cal_ms
celebs1037883celebs
celoms10412123celoms
chyles144813283chyle_s
clams95127673_clams
clefs106616243_clefs
clews105516333_clews
coles76055063cole_s
coleus86818273coleus
culets85518513culets
culms95314193cul_ms
cyclers1435873cyclers
cycles1339303cycle_s
cyders12398833cyders
cymes1210118923cyme_s
dales66439743dale_s
deems85421773_deems
deles65139253dele_s
doles67843753dole_s
doyleys14384923doyleys
dyers96617133dy_ers
dyes85331893dy_e_s
dykes135215573dyke_s
dynels10536813dynels
dynes95917583dyne_s
elemi7312503_elemi
elemis8312383_elemis
elms67322703_el_ms
emblems1335043emblems
ems56435493___ems
exilers14419733exilers
exiles134816403exile_s
eyeless1058053eyeless
eyelets1057523eyelets
eyers86521333ey_ers
eyes75837883ey_e_s
eyres84921773eyre_s
fems96428703__fems
filers94623723filers
files85441273file_s
filets94718953filets
films105617963fil_ms
flams105125013_flams
fleams115011943_fleams
fleas86423663_fleas
flees85828753_flees
flews115316443_flews
fleys117015603_fleys
flyers125712803flyers
flyless1335003flyless
foleys123810463foleys
fyces139813643fyce_s
fykes156312693fyke_s
galeas74618513galeas
gales65442483gale_s
gelees74116263gelees
gems75329113__gems
glams85822933_glams
gleams94812253_gleams
gleds75417893_gleds
glees65027593_glees
glens66519853_glens
gleys96514853_gleys
glims87417673_glims
gloms85219783_gloms
glums84621423_glums
golem8416113golem_
gules64831043gule_s
gybes115012723gybe_s
gyms107514593gy__ms
gyres94820323gyre_s
gyves125711553gyve_s
haems105517013_haems
halers94926913halers
hales85449843hale_s
halms105225213hal_ms
harems115513823harems
helms105619463hel_ms
hems95534943__hems
holes84748653hole_s
holms105117803hol_ms
hoyles12315013hoyle_s
hylas114815903hyl_as
hymens1437993hymens
hypers144811913hypers
hypes135818673hype_s
idlers74012813idlers
idles66720123idle_s
ileus54616893_ileus
inlets63915573inlets
isles54220563isle_s
islets64513083islets
items7499613_items
ixtles13217063ixtle_s
joles125230833jole_s
joyless17226513joyless
juleps1535623juleps
kalams12310603kalams
kales95730983kale_s
kayles134712003kayle_s
keleps12478813keleps
kelims1278913kelims
keyless1436163keyless
kilims1277903kilims
kyes115124933ky_e_s
kytes125012913kyte_s
lams66552263__lams
leas45954183__leas
lees45455883__lees
legs56133693__legs
leis45739603__leis
leks85427603__leks
lens46146493__lens
les35663073__le_s
less45635103__less
lets47147943__lets
leys76430183__leys
lums65734243__lums
lycees11428863lycees
lyceums1442403lyceums
lyes75530833ly_e_s
lyres85019963lyre_s
lyses84518253lyse_s
males75049793male_s
malms95021553mal_ms
mayhems1763413mayhems
melees83618083melees
mems85931503__mems
milers84625163milers
miles74645073mile_s
modems114610763modems
moles74747923mole_s
mules75034293mule_s
muleys11409643muleys
mylars114310443mylars
naleds7469133naleds
neems77316293_neems
nylons9267973nylons
odyles10348563odyle_s
oglers74313183oglers
ogles65223183ogle_s
oilers64721193oilers
oleos55419683_oleos
oles46453473_ole_s
oleums8358783_oleums
orles55326213orle_s
owlets93110393owlets
oxygens1843163oxygens
oyers87620883oy_ers
oyes74940133oy_e_s
pales75753803pale_s
palets85122313palets
palms94921753pal_ms
peles75738083pele_s
phlegms1542373phlegms
phloems1433523phloems
piles74742613pile_s
pileus84514943pileus
pleas75627033_pleas
plebs95814583_plebs
plews105415353_plews
plums94619953_plums
plyers114912983plyers
poems95715553_poems
poleis86018353poleis
polers84225643polers
poles75351003pole_s
proems104711163proems
pulers83820283pulers
pules74538813pule_s
pyes95528993py_e_s
pylons113011243pylons
pyres105523883pyre_s
pyxes175911403pyxe_s
rales54947493rale_s
rayless10239003rayless
rehems113410983rehems
relets64025673relets
rems66237723__rems
retems83914573retems
riles55343643rile_s
roles56747983role_s
rulers64317093rulers
rules55234253rule_s
ryes75529353ry_e_s
rykes125513033ryke_s
saleps85014903saleps
sales56055593sale_s
seems75525023_seems
shleps114710333shleps
skelms12368023skelms
slams74927903_slams
sleds64418853_sleds
slews86220353_slews
slims75423653_slims
slums74623433_slums
solemn838643solemn
soles55547923sole_s
soleus64615613soleus
solums85211333solums
stems75219953_stems
stylers10359353stylers
styles94418653style_s
stylets10369213stylets
sycees11409653sycees
syces106416463syce_s
sykes124816863syke_s
sylis84316023syl_is
sylphs1435543sylphs
sylvas12288173sylvas
syrens94911993syrens
systems1234683systems
talers64628143talers
tales55451373tale_s
teems76019783_teems
teles54536003tele_s
tilers63523503tilers
tiles55542103tile_s
toles55147133tole_s
totems86810763totems
toyless10268713toyless
tules54532793tule_s
tyees86019453ty_ees
tyers86220053ty_ers
tyes76433373ty_e_s
tykes125817063tyke_s
tynes85920303tyne_s
types105721063type_s
tyres84725233tyre_s
ulema7109713_ulema
ulemas888963_ulemas
unless62413073unless
vales85434263vale_s
valets93715623valets
voles86234043vole_s
walers94824463walers
wales86142833wale_s
wayless13308243wayless
whelms14377573whelms
wiles85437873wile_s
wyes105727503wy_e_s
wyle105519383wyle__
wyled124611843wyle_d
wytes114113433wyte_s
xebecs17355363xebecs
xylan1537463xyl_an
xyloid1738193xyloid
xylol1546133xyl_ol
xylose1636763xylose
xyloses1746843xyloses
xylyl1842563xyl_yl
xysters17307163xysters
xystos16356913xystos
xysts15558123xy_sts
xystus16354423xystus
yams95330733_y_ams
yeas78638423_y_eas
yelks126413623_yelks
yells85821943_yells
yelps105712993_yelps
yens75832263_y_ens
yeps95924403_y_eps
yes66250613_y_e_s
yews105323963_y_ews
yules84521583yule_s
zymes1924712943zyme_s

Search took 6 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.1401276364.3
2DLD Change Limit1127163075.72019705.6
3Display Results3073070.0933301.1
 (SQL Overall)1786913075.95330017.0
 
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.