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

167 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
xyloid173819(None) 
amyloid1348542amyloid
cycloid1539282cycloid
cymoid1459472cymoid
haloid104317762haloid
hyaloid1439072hyaloid
hyoid12612442hy_oid
keloid11812622keloid
loid55531492__loid
meloid9616002meloid
myeloid13108122myeloid
myoid11512992my_oid
myxoid1936882myxoid
pyoid11513762py_oid
sloid64619712_sloid
styloid1137552styloid
xylol1546132xylo_l
xylols1634172xylols
xylose1636762xylose
zygoid2045942zygoid
acyloin1247463acyloin
alcid85817973_alcid
algid75415583_algid
algoid83011473algoid
allod64418383allo_d
aloin55227423_aloin
aloud65018073_aloud
amyloids1446003amyloids
aroid65428343_aroid
avoid95516683_avoid
blond85618373_blond
blood85319523_blood
byroad1236623byroad
byword1535053byword
ceboid11310653ceboid
cheloid13310833cheloid
chlorid133211843chlorid
clod76124613_clo_d
cloud86716423_cloud
colloid10312883colloid
conoid9818883conoid
cotyloid1445493cotyloid
cuboid1139503cuboid
cyanid123912043cyanid
cycloids1647043cycloids
cylix17448623cyl_ix
cystoid13309213cystoid
deltoid938573deltoid
devoid1189363devoid
diploid11310293diploid
droid74218543_droid
eloin55923203_eloin
euploid1038963euploid
exploit1648623exploit
eyelid1038443eyelid
felid94717173fel_id
flood95215603_flood
florid10311453_florid
fluid94013963_fluid
fucoid1237893fucoid
fulgid1137043fulgid
gadoid9310463gadoid
ganoid8314443ganoid
gelid74916983gel_id
geoid74215763_geoid
halid94424983hal_id
haloed104717603haloed
haloids113012553haloids
haploid1339833haploid
hemoid12313513hemoid
hyaloids1545993hyaloids
hybrid15237813hybrid
hydrid14248973hydrid
hydroid1539713hydroid
hyenoid1448613hyenoid
hyoids1377673hy_oids
hypnoid1647883hypnoid
hypoed1547923hypoed
inlaid7310143inlaid
keloids1288663keloids
kylix19416323kyl_ix
laid56439143__laid
lid47453523__l_id
lipoid9411043lipoid
load56730603__load
loids66220703__loids
loin46838723__loin
lord55032083__lord
loud55228043__loud
meloids10911453meloids
milord999573milord
mucoid1139783mucoid
myceloid1644853myceloid
mysid11610693my_sid
nevoid1098803nevoid
nylon82910513nylo_n
nylons9267973nylons
oceloid1037973oceloid
onload7268633onload
opioid9310083opioid
ovoid94811023_ovoid
oxblood1743603oxblood
oxyacid2062773oxyacid
pallid93915283pallid
payload1336403payload
phylloid1746193phylloid
phytoid1678753phytoid
plaid85118303_plaid
plod76723273_plo_d
ploidy1237483_ploidy
psyllid1344523psyllid
pygmoid1644533pygmoid
pylon103614003pylo_n
pylons113011243pylons
pylori1147163pylori
pyloric1438063pyloric
relaid75518443relaid
reload7413893reload
salpid9510883salpid
sialoid8310963sialoid
siloed74615303siloed
slid55828983_sl_id
sloids73712693_sloids
slojd13378843_slojd
sloyd9409683_sloyd
solid65025083sol_id
soloed74515743soloed
stolid74213183stolid
sulfid1039063sulfid
syli74318983syl_i_
sylis84316023syl_is
sylphid1645963sylphid
sylvin12247303sylvin
synod9610283syno_d
tabloid1048263tabloid
teloi54217383teloi_
thyroid1438253thyroid
toluid738213toluid
toroid7416013toroid
toxoid1438153toxoid
tylosin1046903tylosin
typhoid1648133typhoid
unlaid7311753unlaid
unload73010803unload
upload9257783upload
valgoid1255213valgoid
valid94618393val_id
viroid10411523viroid
void86220563__void
waylaid1445093waylaid
wyled124611843wyl_ed
xiphoid2045923xiphoid
xylan1537463xyl_an
xylans1635883xylans
xylem1736123xyl_em
xylems1833203xylems
xylene1645793xylene
xylidin1844333xylidin
xyloses1746843xyloses
xylyl1842563xyl_yl
xylyls1931833xylyls
xysti15538153xysti_
xystoi16365133xystoi_
yid76640833_y__id
yod77545503_y_o_d
yond86122313_y_ond
zooid15312103_zooid

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.390458182.1
2DLD Change Limit1127161674.98322620.1
3Display Results1671670.0463630.4
 (SQL Overall)1786911675.41932974.9
 
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.